>>nHandle = SQLCONNECT("MyConnection","MyUserID","MyPassword")
>>
>>fails with the "Feature is not available"
>>
>>nHandle = SQLCONNECT("MyConnection")
>>
>>works OK
>
>Hi Fred,
>
>I guess, "MyConnection" is a named connection that was created using connection string. SQLCONNECT doesn't provide ability to override user name and password for connections like that, but it should be possible to do for connection that is based on ODBC Data Source Name.
>
>If I guessed wrong, please give more information about how "MyConnection" is configured.
>
>Thanks,
>Aleksey.
It's a connection made inside VFP, using the Connection Designer. I don't have access to that machine right now, but it probably is created using a connection string. I'll see if I can create a DSN for it and try it that way. Thanks!