Re: ORACLE 73 ODBC DRIVER Ver 2.5

From: <yliu_at_dri.mgh.com>
Date: Tue, 14 Apr 1998 13:33:00 -0600
Message-ID: <6h0a4s$ofd$1@nnrp1.dejanews.com>

I have no problem with this driver with a console exe application. The call CDataBase::OpenEx succeed. But the same code dosen't work in an ISAPI extension DLL an dI'm getting the error :

ORA-12545: TNS:name lookup failure.
Driver's SQLSetConnectAttr failed.

My code looks like this:
CDatabase pdb;
strConnString = _T("ODBC;DATABASE=TSD;DSN=tsd_test;UID=myuid;PWD=mypwd"); if ( pdb.OpenEx(strConnString,

		CDatabase::openReadOnly
		| CDatabase::noOdbcDialog
		| CDatabase::useCursorLib)
		== 0 )

{
...
}

and if I use 0 replacing all 3 options above, I get error: Only SQL_DRIVER_NOPROMPT is allowed when connection pooling is enabled .

In article <3524f192.8058958_at_news.netnews.att.com>,   tminor_at_att.com (Thomas Minor) wrote:
>
> On Thu, 26 Mar 1998 16:17:14 -0500, Lisa Lombardo
> <llombardo_at_courion.com> wrote:
>
> >Anyone else seeing this when using this ODBC driver?
> >
>
> I am not seeing that. I cannot even call CDataBase::OpenEx
>
> I am getting an ORA-12641 error TNS: authentication service failed to
> initialize.
>
> The Oracle ODBC driver works in other applications and my C++ code
> works with other ODBC drivers, but the Oracle ODBC driver with
> CDataBase does not work.
>
> Have you seen this one?
>
> Thanks,
>
> Tom Minor
>
> Thomas Minor
> tminor_at_att.com
> (908) 234 - 4665
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Tue Apr 14 1998 - 14:33:00 CDT