opendatasource and linked server
Posted on 2006-03-22
I ran this against my dbf files and it showed me the data. However I still cannot seem to create a linked server I can successfully query.
SELECT * FROM OpenDataSource ( 'Microsoft.Jet.OLEDB.4.0', 'Data Source="V:\dataahh";Extended Properties=dBASE IV;')...county
I can see the tables under the linked server but I am unable to query them.
I cannot get a linked server established with 'Microsoft.Jet.OLEDB.4.0' but only the Microsoft ODBC one. As I said above. I can see the tables under the ODBC but can only see the data on the opendatasource pointing to the Jet.