Home Forums SQL Server 2008 Working with Oracle Oracle Instant Client on SQL 2008 R2 64bit RE: Oracle Instant Client on SQL 2008 R2 64bit

  • July 26, 2013 at 10:15 am

    #1636232

    Patti Johnson (7/26/2013)

    Thank you Lowell. It looks like you have installed the Oracle full client not the Oracle Instant client. Is that correct?

    Patti yes, that is correct; we just tend to install the fuller tools.

    I googled SQL SERVER +"ORACLE INSTANT CLIENT" and only see one post that was reported working 100%; a lot report problems setting up, which i guess is typical.

    make sure you run this for the driver just in case, and then create your linked server the way you were before, i think;

    --Required settings for the provider to work correctly as a linked server

    EXEC master.dbo.sp_MSset_oledb_prop N'MSDASQL', N'AllowInProcess', 1

    GO

    EXEC master.dbo.sp_MSset_oledb_prop N'MSDASQL', N'DynamicParameters', 1

    a thread here on SSC also suggested using the full version of the drivers, but the OP posted that it worked for him after the commands above.

    http://www.sqlservercentral.com/Forums/Topic1343393-1044-1.aspx#bm1349868

    you could post a follow up in that thread, maybe the OP who installed the light client could script his linked server out as an example?

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!