Microsoft ODBC Driver for Oracle
-
Hi all, Does Windows Server 2003 R2 service pack 1 come out with a Microsoft ODBC driver for Oracle, if so, why would it not be present?? Many thanks Regards,
The only programmers that are better that C programmers are those who code in 1's and 0's :bob: :)Programm3r My Blog: ^_^
-
Hi all, Does Windows Server 2003 R2 service pack 1 come out with a Microsoft ODBC driver for Oracle, if so, why would it not be present?? Many thanks Regards,
The only programmers that are better that C programmers are those who code in 1's and 0's :bob: :)Programm3r My Blog: ^_^
because Oracle isn't a Microsoft product?
-- Help me! I'm turning into a grapefruit! Buzzwords!
-
because Oracle isn't a Microsoft product?
-- Help me! I'm turning into a grapefruit! Buzzwords!
benjymous wrote:
because Oracle isn't a Microsoft product?
I am well aware of that fact, but usually it come standard with every installation of Windows. And please note that I'm referring to the Microsoft ODBC Driver for Oracle. Thanks.... Regards,
The only programmers that are better that C programmers are those who code in 1's and 0's :bob: :)Programm3r My Blog: ^_^
-
Hi all, Does Windows Server 2003 R2 service pack 1 come out with a Microsoft ODBC driver for Oracle, if so, why would it not be present?? Many thanks Regards,
The only programmers that are better that C programmers are those who code in 1's and 0's :bob: :)Programm3r My Blog: ^_^
If not present do the following: Make sure that the Microsoft drivers for Oracle is present at the following locations in the regestry: HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC Drivers If not import the two entries. Restart the ODBC DSN Manager and :bob: 's your uncle :) Regards,
The only programmers that are better that C programmers are those who code in 1's and 0's :bob: :)Programm3r My Blog: ^_^
-
If not present do the following: Make sure that the Microsoft drivers for Oracle is present at the following locations in the regestry: HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC Drivers If not import the two entries. Restart the ODBC DSN Manager and :bob: 's your uncle :) Regards,
The only programmers that are better that C programmers are those who code in 1's and 0's :bob: :)Programm3r My Blog: ^_^
This driver has never been robust for me in any application where I have tried to use it. It has caused GPFs, SQL failures, problems with Oracle datatypes, you name it. After long suffering:mad:, I have come to the conclusion that using Oracle's own ODBC driver, installed from Oracle source media, is the only way to go. This is easily accomplished when installing Oracle client or maybe put on separately. I would avoid the MS driver altogether - what motivation does MS have to work well with Oracle anyway. Other ODBC drivers such as those from what used to be MetaSolv may also work, but is the necessary testing worth the effort?:(
-
If not present do the following: Make sure that the Microsoft drivers for Oracle is present at the following locations in the regestry: HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC Drivers If not import the two entries. Restart the ODBC DSN Manager and :bob: 's your uncle :) Regards,
The only programmers that are better that C programmers are those who code in 1's and 0's :bob: :)Programm3r My Blog: ^_^
Important note: For EACH of the entries in those 2 sections: HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC Drivers The (Default) value must show (value not set). If it has any other value, such as an empty string, the drivers that were installed subsequent to that one will not list in the ODBC Administrator's Drivers list.
Tom Garth Developer R. L. Nelson and Associates, Inc., Virginia
-
benjymous wrote:
because Oracle isn't a Microsoft product?
I am well aware of that fact, but usually it come standard with every installation of Windows. And please note that I'm referring to the Microsoft ODBC Driver for Oracle. Thanks.... Regards,
The only programmers that are better that C programmers are those who code in 1's and 0's :bob: :)Programm3r My Blog: ^_^
Probably because noone ever used it and Microsoft finally dropped it.
A guide to posting questions on CodeProject[^]
Dave Kreskowiak Microsoft MVP Visual Developer - Visual Basic
2006, 2007 -
This driver has never been robust for me in any application where I have tried to use it. It has caused GPFs, SQL failures, problems with Oracle datatypes, you name it. After long suffering:mad:, I have come to the conclusion that using Oracle's own ODBC driver, installed from Oracle source media, is the only way to go. This is easily accomplished when installing Oracle client or maybe put on separately. I would avoid the MS driver altogether - what motivation does MS have to work well with Oracle anyway. Other ODBC drivers such as those from what used to be MetaSolv may also work, but is the necessary testing worth the effort?:(
AllenRogerMarshall wrote:
This is easily accomplished when installing Oracle client or maybe put on separately.
"Easily" might be going a bit far, but yeah, once installed it's heaps more useful than the MS one.
----
...the wind blows over it and it is gone, and its place remembers it no more...