I want to set up a DSN-less connection to a VFP database. I want to do this because I don't want to have to config ODBC DSN connections to the database on the users' workstations. I've tried several different combinations but I can't seem to get the right syntax for the SQLSTRINGCONNECT() function. What I am trying to do is to have a database that my app accesses via the SQL Pass Thru functions regardless of the fact that the database is VFP or MS SQL. In both cases I want to use the SQLEXEC(), etc. commands to do data manipulation.

My database container is named: VisiPak.dbc

I've tried connecting to it using various permutations of the following command but to no avail:

m.lnHandle = SQLSTRINGCONNECT('DRIVER={Microsoft Visual FoxPro Driver};
UID=VisiPak;PWD=VisiPak;DATABASE=VisiPak')

I'm getting a 'CONNECTIVITY ERROR...' whenever I try to run this. I went into the database and created a connection to try to establish the logon userid, password, etc. but that didn't have any effect. The function SQLCONNECT() works if I have DSN set up in the Control Panel of Windows.

Am I missing something or is there just no way to have a DSN-less connection to a VFP database? Any help would be greatly appreciated.

Jim White