How to call Oracle DBs via DBI ODBC
From: Javier Moreno (JavierMoreno_at_eaton.com)
Date: 01/17/05
- Next message: Ron Reidy: "RE: How to call Oracle DBs via DBI ODBC"
- Previous message: Amonotod: "Re: DBD Oracle DBI driver"
- Next in thread: Ron Reidy: "RE: How to call Oracle DBs via DBI ODBC"
- Maybe reply: Ron Reidy: "RE: How to call Oracle DBs via DBI ODBC"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Mon, 17 Jan 2005 12:32:06 -0600 To: <dbi-users@perl.org>
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
- Next message: Ron Reidy: "RE: How to call Oracle DBs via DBI ODBC"
- Previous message: Amonotod: "Re: DBD Oracle DBI driver"
- Next in thread: Ron Reidy: "RE: How to call Oracle DBs via DBI ODBC"
- Maybe reply: Ron Reidy: "RE: How to call Oracle DBs via DBI ODBC"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
