>I'm converting a VFP app to SQL Server.
>
>Which syntax should I use:
>
>

>SQLCONNECT([nStatementHandle])
>

>
>or
>
>

>SQLCONNECT([cConnectionName | cDataSourceName [, cUserID [, cPassword ]][, lShared]])
>

Kevin,

I prefer to use:

SQLSTRINGCONNECT('DRIVER={SQL Server};SERVER=(local);database=AL;integrated security=true')

This connects to the SQL Server on my local PC using Windows Authentication. You can also substitue a username/password combination if you want.

HTH,
Chad