On Fri, Aug 29, 2003 at 12:16:35PM -0500, Peter Fleck wrote:
> We seem to get an attempt to connect to the database but then this error:
>
> Database connection not made: OR
> A-06401: NETCMN: invalid driver designator (DBD ERROR:
> OCIServerAttach) at /var/www/cgi-bin/pftester.cgi line 27. at
> /usr/lib/perl5/
> 5.8.0/CGI/Carp.pm line 301
>
> Here is the sample perl for connecting to the database. $ORACLE_HOME
> is set to the Solaris home for Oracle.
>
> my $db = "dbi:Oracle:host=server3.cancer.umn.edu:CCD";
^^^ missing sid
If you're using this style connection, it's
dbi:Oracle:host=server3.cancer.umn.edu;sid=CCD
^ semicolon
If (from the Linux machine) you can connect with
sqlplus user_id/[EMAIL PROTECTED] (tnsnames entry)
then try a connection string of "dbi:Oracle:sid"
Tom
