Results 1 to 7 of 7
  1. #1
    Join Date
    Jul 2003
    Posts
    16

    Unhappy Unanswered: OLE DB Provider - Error 7399

    Hi,

    When I run a query connected to a linked server I started facing the following error:

    Server: Msg 7399, Level 16, State 1, Line 1
    OLE DB provider 'SQLOLEDB' reported an error. The provider did not give any information about the error.
    OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IUnknown::QueryInterface returned 0x80004005: The provider did not give any information about the error.].


    I found MS Base Article - 814398, which tells me to change TMP and TEMP enviroment variable to a new folder, and give all permission to the SQLServer account. After that restarted the server.
    I did it all, but unfortunately the error remains the same.

    Can anybody help me?

    Thank a lot,
    Felicia Schimidt

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    What's the linked server?

    What's the Query?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Sep 2003
    Posts
    522
    check the security credentials in linked server properties.

  4. #4
    Join Date
    Jul 2003
    Posts
    16
    Originally posted by Brett Kaiser
    What's the linked server?

    What's the Query?
    Hi Brett,

    The linked server runs at SQL Server, using OLE DB Provider for SQL Server.

    The query runs from one SQL Server to another.

    Something like:

    select * from WEP.odm.dbo.tb_name

    Thanks again!

  5. #5
    Join Date
    Jul 2003
    Posts
    16
    Originally posted by ms_sql_dba
    check the security credentials in linked server properties.
    I have used the option "be made using the security context: ", using the "sa" user to connect.

    Is there other better way to use it?

    Thanks again.

  6. #6
    Join Date
    Jul 2003
    Posts
    16
    Originally posted by fschimidt
    Hi Brett,

    The linked server runs at SQL Server, using OLE DB Provider for SQL Server.

    The query runs from one SQL Server to another.

    Something like:

    select * from WEP.odm.dbo.tb_name

    Thanks again!

    I have changed to Microsoft Jet 4.0 OLE DB Provider, but the error remains the same....

    Any ideas?

    Thanks!

  7. #7
    Join Date
    Jul 2003
    Posts
    16

    Smile

    Just to help people with the same problem.

    I could fix it when I have setup the option
    "Allow In Process" at Provider Options when creating the linked server.

    Hope It can helps you too.

    Regards,
    Felicia

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •