Wednesday, March 21, 2012

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!)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?|||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

No comments:

Post a Comment