MS SQL Server ODBC - ERROR: Accessing FoxPro data from Query Analyzer

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

ERROR: Accessing FoxPro data from Query Analyzer

Jon Devel

2006-10-24, 6:40 pm

Please help,
I can't for the life of me figure out why i get this error when executing
the following statement. I have installed the latest OleDb drivers.......
Any help will be greatly appreciated.

Jon

Statement:
SELECT * FROM OPENROWSET('VFPOLEDB
.1', '\\TESTDATA\CTC\DBF\
'; ' '; '
','SELECT * FROM myFoxTable')

Error:
Server: Msg 7302, Level 16, State 1, Line 1
Could not create an instance of OLE DB provider 'VFPOLEDB.1'.
OLE DB error trace [Non-interface error: CoCreate of DSO for VFPOLEDB.1
returned 0x80040154].

Sponsored Links