Hi Emanuelle,
When I passed the command (Free Table):
SELECT * FROM OPENROWSET('MSDASQL.1',
'DRIVER={Microsoft Visual FoxPro Driver};SourceDB=c:\material.DBF;',
'SELECT * FROM material')
I've got the error message:
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDASQL.1' reported an error.
[OLE/DB provider returned message: [Microsoft][ODBC Visual FoxPro Driver]SourceType]
[OLE/DB provider returned message: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed]
What am I missing?
T.I.A
>>Does anybody know how can I query a DBF file (free table) using command OPENROWSET (with OLE DB Provider for ODBC) in query analyser in SQL 7.0?
>>
>>T.I.A.
>
>Here An Example With Using of DBC:
>
>SELECT * FROM OPENROWSET('MSDASQL.1',
>'DRIVER={Microsoft Visual FoxPro Driver};SourceDB=MyPath\MydataBase.DBC;SourceType=DBC',
>'SELECT * FROM MyDataBase!MyTable')
>
>If you have a free Table you can use this:
>
>SELECT * FROM OPENROWSET('MSDASQL.1',
>'DRIVER={Microsoft Visual FoxPro Driver};SourceDB=MyPath\MyTable.DBF;',
>'SELECT * FROM MyTable')
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only