stevesaved
Programmer
Greetings,
I have a directory on the network called 0:\ESPEC\PDM, which contains dBASE files (*.dbf).
I have created a linked server in SQL Server using the following command:
exec sp_addlinkedserver
@server='Test2',
@srvproduct='db5',
@provider='MSDASQL',
@datasrc='PDMdBASE'
I also have an ODBC data source called PDMdBASE (system DSN) which points to the directory containing the dBASE files. When I try to access data in the dBASE files SQL Server tells me that my table name does not exist, even though it does:
SELECT * FROM Test2.[O:\ESPEC\PDM]..ATAB
Produces:
OLE DB provider 'Test2' does not contain table '`O:\ESPEC\PDM`\`ATAB`'. The table either does not exist or the current user does not have permissions on that table.
ATAB.DBF DOES exist in O:\ESPEC\PDM
Does anyone have any clues on how to make this work?
Thanks for your help.
I have a directory on the network called 0:\ESPEC\PDM, which contains dBASE files (*.dbf).
I have created a linked server in SQL Server using the following command:
exec sp_addlinkedserver
@server='Test2',
@srvproduct='db5',
@provider='MSDASQL',
@datasrc='PDMdBASE'
I also have an ODBC data source called PDMdBASE (system DSN) which points to the directory containing the dBASE files. When I try to access data in the dBASE files SQL Server tells me that my table name does not exist, even though it does:
SELECT * FROM Test2.[O:\ESPEC\PDM]..ATAB
Produces:
OLE DB provider 'Test2' does not contain table '`O:\ESPEC\PDM`\`ATAB`'. The table either does not exist or the current user does not have permissions on that table.
ATAB.DBF DOES exist in O:\ESPEC\PDM
Does anyone have any clues on how to make this work?
Thanks for your help.