64bit Microsoft oledb driver for Oracle? Where is the download??

Question

Post reply

64bit Microsoft oledb driver for Oracle? Where is the download??

neotokyo

SSCertifiable

Points: 7239
More actions
October 4, 2007 at 1:39 pm

#118461

i know it's installed automatically; but if thats the case why don't i see it
in my providers list??
Management Studio\Server Objects\Linked Servers\Providers
this is all i have under 'Providers'
ADsDSOObject
MSDAOSP
MSIDXS
MSOLAP
SQLNCLI
SQLOLEDB
SQLXMLOLEDB
SQLXMLOLEDB.4.0
i'm looking for this, but don't see it.
MSDAORA
any ideas about this?
_________________________

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

AlexSQLForums SSChampion Points: 14277 More actions · Answer 1

Download and install these drivers.

http://www.oracle.com/technology/software/tech/windows/odpnet/64-bit/index.html

Oracle server 64 bit or 32 bit?

Alex S

neotokyo SSCertifiable Points: 7239 More actions · Answer 2

it's an SQL 2005 64bit environment, but as to the Oracle environment i'm unaware of

what bit it it.

_________________________

neotokyo SSCertifiable Points: 7239 More actions · Answer 3

here's something interesting...

when looking at the registry i can see MSDAORA

'hkey_local_machine', 'software\microsoft\microsoft sql server\mssql.l\providers'

why does Management Studio not reflect it under the Providers list???

any ideas?

_________________________

Joe Clifford SSCrazy Eights Points: 8739 More actions · Answer 4

Watch yourself with this one, on a 64-bit machine you may well need to install both the 32 and 64 bit oracle drivers before you can see "it" everywhere including SSIS, linked servers, etc.

The MS Oracle driver (written by MS) was last updated for version 8.0 of Oracle and MS has stated that they're out of the Oracle driver business... there will not be updated or 64 bit versions of that driver. Newer versions of Oracle particularly 11 may not work correctly with a driver written for 8.0 (Oracle maintains compatibilitity for 2 versions...).

Joe

neotokyo SSCertifiable Points: 7239 More actions · Answer 5

"...Oracle and MS has stated that they're out of the Oracle driver business... there will not be updated or 64 bit versions of that driver..."

do what now? i'm hard pressed to believe that.

_________________________

Joe Clifford SSCrazy Eights Points: 8739 More actions · Answer 6

I should have clarified that, MS says to use the Oracle drivers provided by Oracle.

See http://support.microsoft.com/kb/q244661/

neotokyo SSCertifiable Points: 7239 More actions · Answer 7

ahh... i understand.

however; for the moment MSDAORA is installed with SQL Server 2005, so do

you have any ideas about my original inquiry about why i can't see it in my providers

list?

_________________________

Joe Clifford SSCrazy Eights Points: 8739 More actions · Answer 8

Yup, the core database engine is 64-bit, that particular driver is 32-bit only... what you're seeing is a list of available 64 bit drivers. Download and install the 64-bit oracle driver and it will appear in the list of available drivers for a linked server.

The older 32-bit driver is there, you can get at it with the 32-bit odbc admin tool but SSMS won't see it as it is looking only for 64 bit drivers.

neotokyo SSCertifiable Points: 7239 More actions · Answer 9

great! thats the info i was looking for.

now i know where to start.

many thanks!

_________________________

pas0116 SSC Journeyman Points: 98 More actions · Answer 10

Hello:

I have been reading your string of emails for the Oracle 64 bit driver support for SQL Server 64 bit. I am having the same issue and it was resolved by installing the 64 bit Oracle client.

My next question to add to this is, would you know Oracle will support a 64 bit MSDAORA sql server connection to a 32 bit Oracle database server.

SQL Server MSDAORA 64 bit === > 32 bit Oracle DB (remote)

I cannot find these compatibility specs anywhere on line and need to confirm. I do not have a metalink account.

Thanks!

jgrubb SSCrazy Points: 2542 More actions · Answer 11

When you are going across the network, bit level doesn't really matter. The problems start when a program written for a bit level needs to import libraries on the machine its running on. It need the correct bit level libraries/dlls. You shouldn't experience any problems.

pas0116 SSC Journeyman Points: 98 More actions · Answer 12

pas0116

SSC Journeyman

Points: 98

October 21, 2008 at 8:45 am

#887639

Perfect! Thank You!

jsqldba SSChampion Points: 11257 More actions · Answer 13

is there a 64 bit MSDAORA driver available from MS yet?

i have been struggling with creating a linked server from SQL 2005 64 bit to an Oracle (9.2.0.4) database. i have found a workaround using the info in the below links but it's not pretty.

- Install 64Bit Oracle Client

- Install 64Bit Oracle OLEDB Provider

- Set the AllowInProcess value in the registry

http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/dfd61545-1cb3-4353-9d70-b93387f65c8c/

- set up the linked server using oracle oledb provider

http://sqlservercorner.blogspot.com/2009/03/linked-servers-for-64-bit-sql-2005-sp3.html

- queries return error - Invalid data for type "numeric" for columns with numeric datatype. seems to be a problem with implicit numeric conversions. if you wrap the numeric in a function such as ROUND(), it works fine.