Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Incorrect ODBC driver being used.

Re: Incorrect ODBC driver being used.

From: Kenneth C Stahl <kcstahl_at_atl.mediaone.net>
Date: Sun, 03 Sep 2000 04:10:49 GMT
Message-ID: <39B1CF46.978E1380@atl.mediaone.net>

chris_booth_at_my-deja.com wrote:
>
> We're using the Oracle ODBC driver and have installed Oracle 8i server.
> However, the system appears to be using the MS ODBC driver by default
> instead of the Oracle ODBC driver. Any ideas?
>
> Chris
> In article <8onrru$vpv$1_at_nnrp1.deja.com>,
> qiangye_at_my-deja.com wrote:
> > No matter you use which driver, MS ODBC for Oracle or Oracle ODBC
> > driver, you have to install Oracle Client/Server first, which will
> > install Oracle ODBC driver into control panel.
> >
> > It seems MS ODBC for Oracle does not support some features of Oracle
 8i
> > (8.1.5). So, you'd better use Oracle ODBC driver.
> >
> > Qiang Ye
> >
> > ZTE Corp.
> >
> > In article <8onqnc$ui3$1_at_nnrp1.deja.com>,
> > chris_booth_at_my-deja.com wrote:
> > > I'm looking for some help with a problem whereby ODBC is using the
> > > Microsoft ODBC driver instead of the control panel configured Oracle
> > > ODBC driver. The underlying RDBMS is Oracle 8.01.05.00 for Windows
 NT.
> > >
> > > Thanks in advance,
> > > Chris Booth
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> > >

How are you using it? Are you using setting up a DSN? If so, you pick the driver when you create the DSN. If you are using a dsn-less connection with ADO in VB then you simply have to specify the correct driver in your connect string. The same pretty much goes for VC++. However, you didn't give any specifics on how you are using ODBC so it is pretty difficult to provide helpful answers since generic answers tend not to solve specific problems.

What you might want to do is post a message saying EXACTLY how you are using ODBC - that way someone can provide an answer that is tailored to your specific situation.

One problem that I have seen in the past with a report writer that I once used is that the ODBC connection was determined by some parameters that were entered in the options dialogue box for the application. It always assumed that the driver would be Microsoft's, so it did not provide any means of overriding that selection. If that is true with the package that you are using, then throw it away and get one that doesn't make such assumptions. Received on Sat Sep 02 2000 - 23:10:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US