Re: Oracle; DBI connect failed

[Carsten Heim <raise@topmail.de>]

******    message to minivend-users from Carsten Heim <raise@topmail.de>     ******

Am 17.03.1999 um 20.51 Uhr schrieb Mark Stosberg:
> ******    message to minivend-users from Mark Stosberg <mark@summersault.com>     ******
> 
> 
> First, Verify that your Perl/DBI/Oracle connection works without
> Minivend involved. 
> 
> Then, in your catalog.cfg, try a syntax like this:
> Database            products     products.asc      SQL
> Database            products DSN  dbi:Pg:dbname=music host=host.com
> Database            products USER    music
> Database            products PASS   XXXXXX
> 
> the dbi: connect string verify a bit depending on which driver you are using.
> 
> 
>    -mark
> 
> 
> Carsten Heim wrote:
> > 
> > ******    message to minivend-users from Carsten Heim <raise@topmail.de>     ******
> > 
> > Hi all,
> > 
> > I'm trying to use an Oracle-DB with MiniVend 3.09
> > and I always get the following message while restarting the server:
> > 
> > Configuring catalog test...test config error: DBI connect failed: ORA-06401:
> > NETCMN: invalid driver designator (DBD ERROR: OCIServerAttach)
> > at home/pcuser/mvend/lib/Vend/Data.pm line 419
> > 
> > I'm sure that DBI and DBD for Oracle are installed correctly.
> > I created a DB named minivend and a table named products.
> > Via sqlplus I have no problems getting to the DB.
> > 
> > My catalog.cfg entries look like this:
> > 
> > Database   products   products.asc dbi:Oracle:minvend:ORACLESERVER
> > Database   products   USER  MY_USER_AT_DB
> > Database   products   PASS  MY_PASS
> > 
> > Can anyone help???
> > Thanks a lot in advance!!!
> > 
> > ___________________________________________________________
> > TopMail - Jetzt kostenlos anmelden - http://www.topmail.de
> > *** com!online: Jetzt 2 Ausgaben kostenlos testen unter ***
> > ------- http://www.com-online.de/service/index6.html ------
> > -
> > To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
> > email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
> > Archive of past messages: http://www.minivend.com/minivend/minivend-list
> 
> -- 
> http://flip.summersault.com/
> -
> To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
> email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
> Archive of past messages: http://www.minivend.com/minivend/minivend-list

Hi again !

I tried the syntax

 Database            products     products.asc      SQL
 Database            products DSN  dbi:Pg:dbname=music host=host.com
 Database            products USER    music
 Database            products PASS   XXXXXX

and now I get this message:

...test config error: install_driver(Pg) failed: Perhaps the DBD::Pg module...
Available drivers:ADO, ExampleP, Oracle, Proxy, XBase
at home/pcuser/mvend/lib/Vend/Table/DBI.pm line 109

But when I use the syntax with dbi:Oracle......
the driver seems to be found and I get the 'old' message.

Any further ideas (thanx for Mark to help a real newbie)?

___________________________________________________________
TopMail - Jetzt kostenlos anmelden - http://www.topmail.de
*** com!online: Jetzt 2 Ausgaben kostenlos testen unter ***
------- http://www.com-online.de/service/index6.html ------
-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list