Query Dbase7 DBF using linked server in SQL Server 2005

Get help on databases - MySQL, Oracle, Access, etc.
Post Reply
ArmatageShanks
Registered User
Posts: 636
Joined: 01 Feb 2006, 02:00
Location: Cape Town

Query Dbase7 DBF using linked server in SQL Server 2005

Post by ArmatageShanks »

I have to import DBF files into a SQL Server 2005 db. I'm using a linked server to query the files directly, however certain files keep throwing errors at me. I've since discovered that the problematic files are Dbase7. The others are all Dbase3/5.

The problem:
1. Using Microsoft.Jet.OLEDB.4.0 Driver

1.1. EXEC sp_tables_ex <LinkedServer>
Retrieves all tables in the linked server directory (including Dbase 7 tables)

1.2. Select * From <LinkedServer>...<DBase7 DBF>
"OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server <LinkedServer> returned message "External table is not in the expected format.".
Msg 7311, Level 16, State 2, Line 1
Cannot obtain the schema rowset "DBSCHEMA_COLUMNS" for OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server <LinkedServer>. The provider supports the interface, but returns a failure code when it is used."


2. Using Visual FoxPro VFPOLEDB Driver

1.1. EXEC sp_tables_ex <LinkedServer>
Retrieves all tables in the linked server directory except Dbase 7 tables

1.2. Select * From <LinkedServer>...<DBase7 DBF>
The OLE DB provider "VFPOLEDB" for linked server <LinkedServer> does not contain the table <Table>. The table either does not exist or the current user does not have permissions on that table.


Anyone have any ideas?
xchuckx has been flushed and respawned neo-nymbo
Post Reply