Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
MSDE and SQLCONNECT()
Message
From
12/05/2003 15:22:23
 
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00787161
Message ID:
00787468
Views:
10
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform