Information générale
Titre:
VFP/SQL 7 connectivity
I've created a linked server on SQL7 with the following commands:
EXEC sp_addlinkedserver
@server = 'DBFSERVER' ,
@provider = 'MSDASQL',
@provstr = 'DRIVER=Microsoft FoxPro VFP
Driver(*.dbf);UID=;Deleted=Yes;Null=Yes;Collate=Machine
;BackgroundFetch=Yes
;Exclusive=No
;SourceType=DBF
;SourceDB=c:\vfptest',
@srvproduct='s'
go
C:\vfptest is a directory on the server that has the .dbf files I'm
trying to access.
When I use sp_tables_ex, I get output similar to the following:
TABLE_CAT TABLE_SCHEM TABLE_NAME TABLE_TYPE
c:\vfptest NULL country TABLE
c:\vfptest NULL orders TABLE
c:\vfptest NULL customer TABLE
But I cannot query these tables. No syntax seems to work. I've tried
select * from [dbfserver].[c:\vfptest]..[orders.dbf]
select * from [dbfserver]...[orders.dbf]
select * from [dbfserver]...[orders]
select * from [dbfserver].[c:\vfptest].dbo.[orders.dbf]
select * from [dbfserver].[c:\vfptest].dbo.[orders]
But all these return errors either that the file could not be found or
that the schema or catalog supplied are invalid. Does anyone have any
ideas?
Thanks.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement