>>If I try to connect to an MSDE with user/password arguements to SQLCONNECT(), I get an error "Feature is not available". Isn't this available?
>>
>>nHandle = SQLCONNECT("MyConnection","MyUserID","MyPassword")
>>
>>fails with the "Feature is not available"
>>
>>nHandle = SQLCONNECT("MyConnection")
>>
>>works OK, but I've got an existing app that uses the passed parameters for user/password extensively and would prefer not to change it.
>>
>>Any tips I can try to get this to work with VFP8/MSDE 2K?
>
>This is a SWAG, but with MSDE 2K (as with SQL Server 2K) it's possible to install the product to use 1 of 3 authentication modes:
>
>- NT integrated
>- SQL Server
>- "Mixed mode" which supports both
>
>If it was installed as "NT integrated" (I believe it is the default) then SQL Server mode isn't available.

I've changed the entry in the registry for that, HKLM\SOFTWARE\Microsoft\MSQLServer\MSSQLServer\LoginMode and it made no difference. I'm pretty sure the connection was created using a connection string, and not a DSN, and that does seem to be the difference.

I'd like to see where it's documented that a connection string connection cannot use the userid and password parameters to SQLCONNECT(), or did I just miss it?