Post reply

Linked Server Error

  • March 4, 2008 at 7:55 pm

    #203825

    Msg 7303, Level 16, State 1, Line 1

    Could not initialize OLE DB ...

    Please see if I have forgotten anything to set-up

    I check Allow Inprocess in Provider Options

    TNSNames and SQLnet connection are ok..

    I am able to connect and disc thru SQLplus..

    by the way i am using Oracle 9i client

    Do i need to set-up registry in the server??

    and how???

    Thanks in advance..

    //jhoy//

  • March 24, 2008 at 6:36 pm

    #793288

    Could you please tell me exactly how you are creating your OLE-DB data source?

    Thank you.

    Thank-you,
    David Russell
    Any Cloud, Any Database, Oracle since 1982

  • April 15, 2008 at 10:30 am

    #802685

    I am also establishing a linked server, running into some problems. You may need to change the registry entires for 9i, similar to what I did for 10g.

    See my post at

    http://www.sqlservercentral.com/Forums/Search1-0-2.aspx?SessionID=sgigyf45djq4ef55ypegcxfy&SortBy=2&SortOrder=1

  • April 21, 2008 at 3:44 pm

    #805230

    I've had issues with this due to permissions on the folder containing the Oracle Home files. Quick test is to open up the permissions to everyone full (I know ,I Know) and try to link and query. If it works you can then tighten security on that folder.

Viewing 4 posts - 1 through 3 (of 3 total)

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