OLE DB Provider Wont Work With Free Table Directory

[pcawdron]

I have a FOXPRO free table directory and can run PassThrough ODBC queries from Access with no problem.

I'm trying to migrate to SQL Server, using its LinkedServer function. This requires an OLE DB Provider ODBC, but it doesn't appear to recognize FoxPro's Free Table directory (b/c Free Tables dont support SQLTables or SQLColumns)

The SQL I'm using is fine, as I said, it runs in Access OK. But SQL Server doesn't recognise the table name in the query.

I'm also running into problems where a valid AS400 DB2 SQL string is being rejected as an OPENQUERY view. It only happens where ' or " are used within the query. I've been able to correct some of these but not all

(This has also been posted under FoxPro)

Thanks for your help with this...