Whoops...let me make one think clear....CREATE CONNECTION is not a way out either as CREATE CONNECTION also requires a DSN.

>Hi Jeroen!
>
>I don't think you can do SQLCONNECT() without a DSN unless you have defined a connection in your database via CREATE CONNECTION.....
>
>So the only two valid syntaxes are:
>
>SQLCONNECT(DataSourceName, cUserID, cPassword)
>-or-
>SQLCONNECT(cConnectionName)
>
>
>>Does anyone know the syntax, or have an example on how to do a sqlconnect() without a dsn ?
>>
>>Thx,
>>Jeroen