Re: VB & Oracle73, compiled app connects fine, but NOT running in design!?

The name (SID) of the database that your are trying to connect to is not defined in your TNSNAMES.ORA file. Maybe your picking this up from your application's INI file, and yu have not siwtched back to your development DB name ??

mlindeland_at_tech-exch.com wrote in message <34F7391C.2D8B_at_tech-exch.com>...
>Has anyone encountered a problem connecting to an Oracle73 server from a
>VB application run from the designer, when they could connect from the
>exact same application (and drivers, &c.) when it was compiled to an
>.exe?
>
>Both running in development mode and running compiled worked fine
>connecting to an Oracle71 server.
>
>Now, when running in development mode, the following set of errors are
>returned in the dbengine.errors collection:
>
>[Microsoft][ODBC DLL] Driver's SQLSetConnectOption failed
>[Oracle][ODBC Oracle Driver]Driver not capable.
>[Oracle][ODBC Oracle Driver][Oracle OCI]ORA-12154: TNS:could not resolve
>service name.
>ODBC--call failed.
>
>
>
>Any help/ideas/&c. appreciated!
Received on Wed Mar 04 1998 - 00:00:00 CST