Post reply

Error 7357! Please, Help me!!!

  • December 2, 2002 at 6:47 am

    #81261

    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

  • December 2, 2002 at 12:03 pm

    #442822

    Try this.

    select * from LSERVER.tablename.dbo.dbfcustomers

  • December 2, 2002 at 12:03 pm

    #442821

    Try this.

    select * from LSERVER.databasename.dbo.dbfcustomers

  • December 2, 2002 at 7:20 pm

    #442859

    Use openquery instead.

    SELECT * FROM OPENQUERY(LSERVER,'SELECT * FROM dbfcustomers')

    Access is one of those that the four paert naming convention does not apply. Also, I am not sure as not test items here but try

    SELECT * FROM LSERVER.dbfcustomers

  • December 3, 2002 at 6:59 pm

    #442969

    Thanks for help me!!!

    Now, I found the solution...

    The problem was in the access permissions, because the owner of the tables was not the Admin. I have to change the tables owners and I got to do a query ...

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply