VB3.0 Oracle 9i ODBC Connectivity kmshaju[ at ]gmail.com 31.08.2006 11:31:46 When connecting Vb 3.0 application with oracle 9.1 database through oracle 7.1 client we are getting the following error ERR #3146 ODBC-- call failed. [Microsoft][ODBC DLL] Driver'SQLSetConnectoption failed[Oracle][Driver not capable][Oracle][ODBC ORacle Driver][Oracle OCI][ORA-12154: TNS:Could not resolve Service name.(#12154) front end : VB 3.0 back end : Oracle 9.2 ( server) on SOLARIS : Client Oracle 7 We have two environment of which one works fine other one throws the above error. Thanks in advance

Re: VB3.0 Oracle 9i ODBC Connectivity Stefan Hoffmann <stefan.hoffmann[ at ]explido.de> 31.08.2006 11:52:40 hi, kmshaju[ at ]gmail.com wrote: [Quoted Text] > When connecting Vb 3.0 application with oracle 9.1 database through > oracle 7.1 client we are getting the following error Why are you not using the 9.1 client? > We have two environment of which one works fine other one throws the > above error. Same client, same ODBC settings, same TNS file? mfG --> stefan <--