January 21, 2009 at 4:09 pm
i have read so many forums but could not find an answer..so please only person with right solution or experienced person suggest me..i have sql serevr 2005 sp2 64 bit and using DTS packages as legacy components..i installed oracle 10g X64 edition...the linked servers were created with "Oracle provider for OLE DB" option..in DTS package the oracle task was created with "MS OLE DB Provider for Oracle"..when i try to create the oracle task with "Oracle provider for OLE DB" option i get error " the specified module cannot be found" erro source:MS OLE DB service components.error description: class not registered..i cannot create linked server with "MS OLE DB Provider for Oracle" as i do not see in the list..can anyone please give me the answer..thanks in advance..
February 12, 2009 at 1:13 pm
From my experience, the Oracle 64 bits driver doesn't work.
I've installed my SQL 2005 server since 1 year with many tests and search
At the end, we work with the 32 bits driver just to import some tables from an Oracle 10g server
Inside SQL, no problem with the 64 bits
For more details, send me a PM
Fabrice
February 13, 2009 at 10:10 pm
i got the solution..thanks for answering...
February 15, 2009 at 1:42 pm
iqtedar (2/13/2009)
i got the solution..thanks for answering...
[font="Verdana"]...and the solution was?[/font]
February 17, 2009 at 3:33 pm
solution was?
install oracle 11i 32 bit cleint components on sql server 2005/8 64 bit machine. this will work without any issues.
February 17, 2009 at 9:10 pm
yes you are right..on a 64 bit sql server..u will need 64 bit 10g client to connect linked servers..and if your SSIS or DTS packages are using open query to Oracle database you should be fine with 64 bit 10g client..but if you are using an OLE or ODBC connection to Oracle you will need 11g 32 bit client..this is suggested by microsoft..i spend 1week without any solution for this..finally ending up in callin MSFT..they gave me this solution..any other questions..please let me know..thanks..
March 11, 2009 at 1:31 pm
i got this working and am using it right now.
March 27, 2009 at 7:03 am
I have installed 32 bit 11g client on the SQL Server 2008 64 bit box and SQL Server 2008 doesnt list the provider.
March 27, 2009 at 8:19 am
not sure about 2008..
August 5, 2009 at 2:13 am
Oldham, we're migrating to SQL 2008 64 bit - have asked the same question on every forum I could find. I'm having to recode the complete integration using Oracle OLE DB provider because I haven't been able to find a work around. Good luck ... if you find a solution I'd love to hear about it.
September 1, 2009 at 12:53 pm
I 've just installed SQL Server 2005 on Windows 2003 Server 64 bit. One of my databases need to connect to seveal Oracle databases.
- I tried installing 64 bit Orcale 9 on this server. Got a strange message that the application (Oracle 64 bit) could not be installed on a 32 bit server! Strange!
- I installed Oracle 9 32 bit on the server, but I could not find ODBC driver in the Data sources! Neither the oledb under providers in MSS Manager Studio!
- Same result efter several desintall and installation. A college copied the .dll files och run a script to register the dll files. We could then se the Oracle driver in the Database sources, but we could not create any connection.
- We have even tried an 10G version of Oracle with the same result.
September 2, 2009 at 8:32 am
On a 64 bit sql server with windows 64 bit you will need two versions of Oracle clients
i) 10 G 64 bit for Linked Servers
ii)11 G 32 bit for ODBC/OLE DB connections.
This should work. Thanks,
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply