Re: Connecting to Oracle DB

Replies are listed 'Best First'.
Re: Re: Connecting to Oracle DB by mrmorales (Initiate) on Dec 20, 2001 at 10:36 UTC
First of all thank for you input. I would like to clarify on my last post. The Oracle server instance and client software are both on the same machine that I am trying to run the code on; so everything is local. Let me know what you think. I'm currently going through the docs on DBD::Oracle but haven't found anything specific to this yet. Thanks again. I have only read about being able to do what I'm trying to accomplish with Oracle on MySql. So now that I have everything installed, all I have to do is start with the code writing. In fact Ive started and now im getting an error regarding "DBI" and "DBD::Oracle". Everything installed just fine, but the error reads: DBI->connect(T:melchior:dev01) failed: ORA-06401: NETCMN: invalid driver designator (DBD ERROR: OCIServerAttach) at ./insert-LDB_EXTID.pl line 11 Could not connect: ORA-06401: NETCMN: invalid driver designator (DBD ERROR: OCIServerAttach) Now this is obviously an issue with the connect string. I'm fairly familar with Oracle and the Listener, and I can connect to the DB with Sql*Plus just fine. Thanks again.	[reply]
Re: Re: Re: Connecting to Oracle DB by runrig (Abbot) on Dec 21, 2001 at 00:11 UTC
It sounds like maybe you installed DBI & DBD from an RPM like package, and didn't go through the 'perl Makefile.PL','make','make test' and 'make install'. I find that sometimes these things are best done manually one step at a time, so you can look through the README's in the CPAN distribution as (or before) issues arise) during installation. Unless someone more familiar with Oracle has a clue and can help :-) BTW, you don't need to reply to every post in the thread with the same message :)	[reply]