>>>Hi All,
>>>
>>>I tried this code, but it asks me DSN name. Where is my mistake?
>>>
>>>xconn=SQLSTRINGCONNECT("Provider=Advantage.OLEDB.1;Data Source=d:\prg\kalem\data\cem2004;"+;
>>> "ServerType=ADS_LOCAL_SERVER;"+;
>>> "TableType=ADS_VFP_TABLE;LockMode=ADS_COMPATIBLE_LOCKING")
>>>
>>
>>You use OLEDB string to connect with ODBC.
>
>So?
Check what is the valid ODBC connection string.
I'm sorry, I don't know it for Advantage.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.