Post reply

Cannot get the data of the row from OLE DB provider "Sql server" for linked server "(null)

  • December 23, 2008 at 6:09 am

    #204459

    Hi,

    I have created linked server to Oracle. What is most interesting I can see all tables. I can make any command and get results to almost all tables except one table where I get constantly next message:

    Msg 7330, Level 16, State 2, Line 1

    Cannot fetch a row from OLE DB provider "MSDAORA" for linked server "ORAMS".

    Try to find solution over the net and nothing helped me.

    In linked server properties under server options Connection timeout is 0.

    On the other pc with the same platform I can get result, but this pc can't get it.

    All pc's are under service pack2.

    I am confused and can't find a way to solve this issue.

    after 30 minutes searching internet I found solution:

    select * from openquery (linked server, 'select * from table name')

    and now it works.

    Do you have any explanation? Why msora works with other tables except one which is no so big like other tables?

  • December 24, 2008 at 6:44 am

    #917353

    Looks like a regional settings problem.

    Compare Regional Setting in control panel and NLS_parametars in the Oracle Home in registry on the PC where it works and on the one where it does not.

    Crazy problem.

    Good luck

    Aleksandar

  • December 24, 2008 at 6:48 am

    #917360

    Hvala covek. Thanks It could be a reason. I will check it.

  • December 24, 2008 at 7:06 am

    #917367

    U svako vreme sto se Oracle tice.

    Any time for Oracle hints.

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

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