All,
I have a web application which calls an Oracle database. I was unable to
connect to it but I found out it was because the HTTP port the TNS was
listening to was not the same one the webserver was running on. I have fixed
that on the webserver end. However, it seems the call to the TNS is getting
mixed up. The DBI ODBC driver appears to be sending the HOST_NAME as
SERVICE_NAME. My call is very standard, is there something else I should do in
order for this to work?
$::dbh = DBI->connect('dbi:ODBC:ILOG', 'system', '##########', { AutoCommit =>
0 }) or
&Error("Unable to connect to database.<br>$DBI::errstr");
17-JAN-2005 11:18:19 *
(CONNECT_DATA=(SID=*)(SERVICE_NAME=slpmxwmorenojav)(CID=(PROGRAM=C:\Perl\bin\perl.exe)(HOST=SLPMXWMORENOJAV)(USER=SYSTEM)))
* (ADDRESS=(PROTOCOL=tcp)(HOST=151.110.117.153)(PORT=3772)) * establish *
slpmxwmorenojav * 12514
TNS-12514: TNS:listener could not resolve SERVICE_NAME given in connect
descriptor
Regards,
Javier Moreno
