Hi All, I need to connect to the oracle database from sql server. I have oracle client 11g installed and have setup the tnsnames. I can connect to the oracle database using SSIS and do my work. But I have a requirement where a Linked Server needs to be created in order to connect to the oracle db. But in the providers list, I can't see OraOLEDB.Oracle provider. Not sure what needs to be done. I have MS-SQL 2008 R2 installed.

Do you mean this in SQL Server Management Studio: Installed 32 and 64 bit client? Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Hi SSISJoost, Yes, the one in the screen shot. Its 32 bit client

Hi SSISJoost, Yes, the one in the screen shot. Its 32 bit client And your SQL Server version? Use this query if you don't know: Select @@version Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

its Microsoft Corporation Developer Edition (64-bit)

its Microsoft Corporation Developer Edition (64-bit) I think you also need to install the 64bit client...Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

thanks for the replies, just had a query, if installing the 64 bit client will cause any issue with the client already installed.

No if you run the package in 32bit mode it will use the 32bit client and visa versa... BIDS is 32bit and I think SSMS is 64bit and that's why you don't see the driver in de list. Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

thanks for the help. i will give it a try by installing a 64 bit client.

Ok let me know if it worked...Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter