Showing posts with label reported. Show all posts
Showing posts with label reported. Show all posts

Wednesday, March 21, 2012

Error 7399: OLE DB provider 'SQLOLEDB' reported an error.

Hello everyone!
I try to setup a linked server connection to an other SQL Server and receive
the following error message:
Error 7399: OLE DB provider 'SQLOLEDB' reported an error.
OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDBInitialize::Initialize
returned 0x80004005: ].
I am using a trusted connection.
Does anybody have an idea what I am doing wrong here? Or how I can get a
more specific error message?
Thanks for any hints!
brgds,
tom.Hi Thomas:
Please see the KB article, it may be useful:
http://support.microsoft.com/defaul...kb;en-us;314530
Best Wishes
Wei Ci Zhou

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