 | |
Connecting to Oracle via MS ODBC driver error
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Connecting to Oracle via MS ODBC driver error -
03-05-2008
, 01:01 PM
#2
| |||
| |||
|
|
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 |
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.
#3
| |||
| |||
|
|
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 |
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.
#4
| |||
| |||
|
|
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 |
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.
#5
| |||
| |||
|
|
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 |
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.
#6
| |||
| |||
|
|
On Mar 5, 2:01*pm, roadwarrior <john.fi... (AT) science (DOT) doe.gov> 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. |
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 --
#7
| |||
| |||
|
|
On Mar 5, 2:01*pm, roadwarrior <john.fi... (AT) science (DOT) doe.gov> 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. |
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 --
#8
| |||
| |||
|
|
On Mar 5, 2:01*pm, roadwarrior <john.fi... (AT) science (DOT) doe.gov> 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. |
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 --
#9
| |||
| |||
|
|
On Mar 5, 2:01*pm, roadwarrior <john.fi... (AT) science (DOT) doe.gov> 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. |
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 --
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.