Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
MSDE and SQLCONNECT()
Message
De
12/05/2003 15:22:23
 
 
À
11/05/2003 16:32:38
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00787161
Message ID:
00787468
Vues:
23
>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform