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')