>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.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up