Hi,

I create a Linked server on a Foxpro Database with this command

EXECUTE sp_addlinkedserver
@server = 'test',
@provider = 'MSDASQL',
@srvproduct = 'FOXPRO',
@provstr = 'INITIAL CATALOG=facturation;Driver=MICROSOFT VISUAL FOXPRO DRIVER;SourceType=DBC;SourceDb=C:\Fox\facturation. dbc;'

I can see the new linked server with the instruction sp_linkedservers, all seems OK.

But when I want to access to a table of the foxpro database (select * from test...adr_facturation) , I have this error message (number 7313):

Invalid schema or catalog specified for provider 'MSDASQL'

I have no idee about this problem...

Thanks

Yannick