I could be wrong, and someone please correct me if I am, but if your script is running
on NT and connecting to an Oracle database on any platform, you would use DBD:ODBC
because the connect string contains an ODBC DSN. If your are running the script on a
UNIX box, then DBD:Oracle is used. In this case the connect string would contain an
entry from the tnsnames.ora file.
Example:
Win32:
DBI->connect('dbi:ODBC:OraDb', $User, $Password);
Where 'OraDb' is an ODBC DSN that points to an entry in the tnsnames.ora file.
UNIX:
DBI->connect('dbi:Oracle:OraDb', $User, $Password);
Where 'OraDb' directly points to an entry in the tnsnames.ora file.
Stanley G. Martin
Midwest Consulting Group
Sprint Platform & Strategy Mgmt.
913.315.3133
[EMAIL PROTECTED]
-----Original Message-----
From: egil [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, December 19, 2000 9:01 AM
To: perl-win32-database; perl-win32-web
Cc: egil
Subject: Perl, DBI and DBD-Oracle - Anyone got this to work in perlscript?
I have made a good handful of websites allready, most of which use
perl (perlscript) as language, DBI for connection and either ADO or
ODBC connections thorugh DBI.
Now, I would like to move from these rather slow methods over to the
Oracle DBD module, but I cannot get this to work properly.
Whenever I change from DBD::ODBC or whatever, to DBD::Oracle in the
connect string, all my perlscript scripts outputs all the code with
an internal error? at the bottom.
If I try to do the same sql statements through DBD::Oracle in pure
perl, everything works smoothly.
All my servers are WIn32 based, running NT 4 SP6a, Oracle is 8.1.5,
both local and remote server installations have been tried.
PLEASE PLEASE PLEASE help me out on this, because I dont understand
why this happens at all!
Regards,
Egil
-=//
Egil Helland / IKON AS - MCSE, Internet, Intranet
mailto:[EMAIL PROTECTED] http://egil.net
//=-
_______________________________________________
Perl-Win32-Web mailing list
[EMAIL PROTECTED]
http://listserv.ActiveState.com/mailman/listinfo/perl-win32-web
