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

Al wrote:
>
> 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!

Except that I CAN connect through the applicaiton if it is compiled to an .EXE, and it will be using the exact same .INI file whether it is compiled or being run from the development environment. Also, I can get an ODBC connection through other tools (such as the ODBC tester), as well as just through SQL*Net using SQL*Plus. (As I understand it, this would not be the case if I had a definition problem in my TNSNAMES.ORA file.) The only way I cannot connect is from the application being run from the development environment.

• ML