Cannot see ODBC driver as a data source
933437Apr 26 2012 — edited May 21 2012Hi
I've installed both the Win32 and Win64 11.2g clients on our Win2008R2sp1 server.
I can get my connection to test fine from c:\windows\sysWOW64\odbcad32.exe (the 32bit ODBC Admin panel), and from sqlplus and sqldeveloper (all on the "client_2" x32bit product).
I've set ORACLE_HOME to the 32bit product.
D:\>echo %ORACLE_HOME%
D:\oracle\product\11.2.0\client_2
I have Strawberry Perl x32 installed and a x32bit VB Application. Neither will connect.
Perl...
D:\>perl -MDBI -le "my $h = DBI->connect('dbi:ODBC:dbase02',rouser,rouser); $h->disconnect()"DBI connect('dbase02','rouser',...) failed: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (SQL-IM002) at -e line 1
On my App I get
S1000: [oracle]p[ODBC][Ora]ORA-12560: TNS:protocol adapter error.
As I've said, the System DSN is on the 32bit ODBC Panel and is 'test's fine from there.
Oddly enough I have a few identical servers where I'd set up connections that work fine, using the same setup. Could be we've had a patch that messed things up? Any ideas on how to get roud the SQL-IM002 or ORA-12560 error would be greatly appreciated.
UPDATE: on servers where we have a working System DSN, if I simply clone it (open existing, change TNS Name and Identified and Save) the cloned 'new' System DSN works fine. However if I create it from scratch it does not! So something is prohibiting me from creating new System DSN entries that are accepted/read by the ODBC Driver???
Many Thanks
Kieran
Edited by: user10688427 on 26-Apr-2012 06:18