From: Gary England Subject: Re: ODBC 3.0 vs. Oracle 7.3 ODBC driver -- Help! Date: 1997/09/09 Message-ID: <34152DB2.4D27@hiwaay.net>#1/1 References: <01bcb70a$911fd630$0200a8c0@bcesrvr> <5ukal7$kek$1@client2.news.psi.net> Reply-To: gengland@hiwaay.net Newsgroups: comp.databases.oracle.server Mike White wrote: > > "Bryan C. Everly" wrote: > > We've had good luck with the Intersolve drivers. You can download > demo versions from their web site. > > >I have a tiny little ODBC program that I have written with Visual C++ 5.0 > >and am running fine against Microsoft SQL Server 6.5 on a single NT > >machine. However, when I try to run the same program against Oracle 7.3 or > >Sybase 11.0.2 (using the vendor-supplied ODBC drivers), it throws an > >exception during SQLConnect() when the userid and password are invalid. > >1. Has anyone else seen this behavior? > >2. Does anyone have a solution? > >Thanks in advance, > >Bryan Everly > >bceverly@softart.com > > Mike White > The Image Consulting Group > mwhite@icgconsulting.com I have not had good luck with the Intersolv drivers. They are not multi-thread until version 3.0, and a copy for NT is $5,000. There are some syntax differences between SQL Server and ORACLE since one is ANSI and the other is not. I may be missing something. Should you not get an error when the userid and password are invalid? Gary