Hi Jim,

m.lnHandle = SQLSTRINGCONNECT('DRIVER={Microsoft Visual FoxPro Driver};
            UID=VisiPak;PWD=VisiPak;SourceType=DBC;SourceDB=[folder\]VisiPak')

MartinJ

>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