Error 7357 - Access Linked Server

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)

Error 7357 - Access Linked Server

Author

Topic

akuniyoshi
Starting Member

2 Posts

Posted - 2002-12-02 : 05:56:56

Hello,

I have one linked server, a access 97 database. When I had made a query in the tables of this linked server, I receive the following message:

Server: Msg 7357, Level 16, State 2, Line 1
Could not process object 'dbfcustomers'. The OLE DB provider 'Microsoft.Jet.OLEDB.4.0' indicates that the object has no columns.

I did this statement:

select * from LSERVER...dbfcustomers

But, I check, the table isn't empty, there are 3 rows. Somebody could help me?

Thanks,

Adriana

ValterBorges
Master Smack Fu Yak Hacker

1429 Posts

Posted - 2002-12-05 : 02:57:48

Have you tried select col1, col2, col3 from LSERVER...dbfcustomers

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources