Re: Connecting to Oracle via MS ODBC driver error

On Mar 5, 2:21 pm, Charles Hooper <hooperc2...@xxxxxxxxx> wrote:
On Mar 5, 2:01 pm, roadwarrior <john.fi...@xxxxxxxxxxxxxxx> wrote:

Trying to connect to Oracle using Oracle 9.2 client - a VB6 app
from windows 2003 server using microsoft odbc for oracle drivers....
(the app works un win95, win nt, win200)

getting a microsoft driver error. - using msorcl32.dll .....2007

any information on this would be greatly appreciated ....

DSNs and the communication layer all work ...Since SQL plus works

Thanks

I had problems with the Microsoft ODBC driver when we switched from
Oracle 8.0.5 to Oracle 8.1.7.3... several years ago.  Use the Oracle
ODBC or OLEDB driver instead (might need to perform a custom install
of the client, at least that is the case with the Oracle 10.2.0.1
client).  The OLEDB driver seems to retrieve data faster than the
Oracle ODBC driver.

Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc.

Is the Windows system 32 or 64 bit?
What full version is the target Oracle version?

Have you checked your ODBC and OLE drivers againt MS list of currently
available drivers?

How To Acquire and Install the Microsoft Oracle ODBC Driver
http://support.microsoft.com/kb/175018

List of ODBC drivers installed by Access, Office, and MDAC
http://support.microsoft.com/kb/208689

Installation of the Oracle ODBC and OLE drivers as mentioned by
Charles does require a custom install of the client. After running
the runtime install just run a custom install and look under the
Windows feature.

HTH -- Mark D Powell --
.

Relevant Pages

  • Adding new driver
    ... I tried to install the odbc driver of the oracle instant client. ... The entry disapeared from the odbc data source administrator. ...
    (microsoft.public.data.odbc)
  • RE: ORACLE DRIVER
    ... Subject: ORACLE DRIVER ... DBI - is the perl module to handle all the request of the database, ... So is there any free Oracle ODBC driver for Linux? ...
    (perl.dbi.users)
  • Re: DTS for Oracle through ODBC: Error Calling GetNextRows in Prev
    ... I found out the Oracle driver they had installed on my system was for Oracle ... installer app in order to install their ODBC's.. ... I decided to use the Oracle ODBC provided in their client install. ...
    (microsoft.public.sqlserver.dts)
  • Re: ASP.net and Oracle error System.Data.OleDb.OleDbException
    ... The oledb driver is not part of the 'standard' oracle client install ... > on our test web server, There is only one oracle home on the test server. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: [dbi] DSNs and DRIVER attribute
    ... You need to find where your ODBC driver shared object is installed ... unixODBC then looks up ... I'm trying to debug an install for my DBD::ODBC module, and since this is my first experiment with the DBI, I have a question on format/syntax. ... I've already installed/tested Perl5, DBI, unixODBC Now, I'm trying to install the ODBC driver ...
    (perl.dbi.users)