ODBC Connects from EXE, fails from DLL
Date: 1998/05/26
Message-ID: <6kf8m1$q8u$1_at_nnrp1.dejanews.com>#1/1
I am experiencing a similar connectivity problem trying to open an Oracle database from a DLL. My application was previously an EXE, and as an EXE had no problems connecting to the database.
What I'm working with:
Windows NT workstation, HP server
An Intersolv ODBC driver (INTERSOLV 3.01 32bit Oracle 7)
DevStudio, VC++ 5.0, using CRecordSet classes.
My connect string:
db.OpenEx( _T( "DSN=picasso_sqa;UID=me;PWD=pwd" ) );
Here is the error popup message:
[INTERSOLV][ODBC Oracle Driver][Oracle]ORA-06413: Connection not open.
Here's the sqlnet.log file that gets created in my working directory:
Fatal OSN connect error 6413, connecting to: (DESCRIPTION=(CONNECT_DATA=(SID=sqa1)(CID=(PROGRAM=G:\Work\ ... \MyTestDLL\Debug\SimpleTest.exe)(HOST=Windows NT PC)(USER=me)))(ADDRESS_LIST=(ADDRESS=(PROTOCOL=ipc)(KEY=picasso_sqa1.world))(A DDRESS=(PROTOCOL=TCP)(Host=HPK200)(Port=1521))))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 2.3.2.1.0 - Production
Time: 26-MAY-98 15:13:11
Tracing not turned on.
Any help is gratefully appreciated.
Alex <akrowitz_at_kronos.com>
In article <edCNqxKi9GA.210_at_uppssnewspub04.moswest.msn.net>,
"David A. Schramm" <dschramm_at_ipworld.com> wrote:
>
> After attempting to upgrade NT 4.0 WS from Peer Web Service to IIS 4.0 WS, I
> can no longer connect from an ISAPI dll on the workstation to the SQL Server
> 6.5 database on the server. If I run the same code as an .exe on the
> workstation, it connects OK. If I run the same code as an ISAPI dll on the
> server it connects OK. HELP!!! My code / test environment is down because of
> this! Below is the output from the ODBC driver trace showing an attempt to
> connect through inetinfo.exe (iis 3.0) and a successful connection through
> odbctest.exe, and finally the program running as an .exe successfully.
>
> ----------------------------------------------------------------------------
> ----------------
(Snip)
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue May 26 1998 - 00:00:00 CEST