Linked Servers - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Linked Servers

Author

Topic

DB King
Starting Member

21 Posts

Posted - 2005-08-23 : 10:48:13

I am trying to Link an Excel 2003 spreadsheet to a Enterprise Ed of SQL Server running Windows 2000 AS.

I add the spreadsheet as a Linked server with the following configuration:

linked server: TEST
server Type: Microsoft Jet 4.0 OLD DB Provider
Product name: Excel
Data Source: c:\temp\new.xls

Security
--------
Be made without using a security context - CHECKED

It then makes the connection and I can see the tables and views. When I click on the table in Enterprise manager i get:

Error 7399: OLE DB provider 'microsoft.Jet.OLEDB.4.0' reported an error.
OLE DB Trace [OLE/DB Provider 'microsoft.Jet.OLEDB.4.0'IDBInitialize returned 0x80004005: ].

PLEASE HELP !!!

DB King
Starting Member

21 Posts

Posted - 2005-08-23 : 12:03:14

this worked:

Put "Excel 5.0" in Provider string;

Check RPC and RPC out in server option.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources