>>>Hi everybody,
>>>
>>>I have a customer who wants to get information from VFP database using JAVA and ODBC driver. He asked me for the Database ID. I don't know what to give him. Any suggestions on what is the connection he should use from Java getting to VFP database? I presume that once he has a connection he can call VFP database using SQL command and get the data, right?
>>>
>>>Any suggestions would be appreciated.
>>
>>Did you check http://www.codeproject.com/KB/database/connectionstrings.aspx#Visual%20FoxPro
>
>Thank you. I will cut and send him the in for on VFP connection string.

Just keep in mind that the last ODBC driver for VFP was for VFP6.
If you use newly introduced types as AUTOINC, BLOB, varchar your user will get error.
I saw somewhere (Unfortunately I can't remember right now) some 3th party ODBC for VFP. The company claims that it works woth VFP9, but I never tested it though.
When I remember I'll post the link :-)