Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2002
    Posts
    1

    Question Unanswered: Error 7399: OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.

    I tried to make one with following options in enterprise manager:

    Server type: Other data source
    Provider name: test
    Product name: Access 2000
    Data source: c:\db\test.mdb
    Provider string: Microsoft.Jet.OLEDB.4.0

    When I try to access the linked server tables I receive following error:
    Error 7399: OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.

    When I try to make a view (select * from linkedserver1...table) I receive following error:
    [Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB provider returned message: Disk or network error.]

    Can anyone help me? the only thing I want to do is link an access table to SQL Server (NOT sql server table in access but access table in sql server!)

  2. #2
    Join Date
    Sep 2002
    Posts
    4

    Re: Error 7399: OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.

    Have you definately got the paths setup right?

    'c:\db\test.mdb' needs to be on the SQL Server machine itself and has the system got the correct permissions to access the mdb file.

    If you check this and this is all OK then is it not a possibility to import your table into SQL Server?

  3. #3
    Join Date
    Dec 2002
    Posts
    3

    Re: Error 7399: OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error.

    make sure that u are connected to you Domain Server.
    and that u make a System DSN (best solution in DSN) correctly to your SQL Server.

    hope this will help u
    bye

Posting Permissions

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