Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Connection string
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2008
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01528660
Message ID:
01528679
Vues:
53
>>Have you set the SQL server to allow remote connections, use TCP/IP, and allow port 1433 so you can connect remotely?
>I can get in using sql manager no problem and remote connections allowed. I've managed to login using
>constring = "Driver=SQL Server;Server=SERVER-ACC\SQLEXPRESS; Initial Catalog=acctrax; User Id=user1; Password=password1"
>
>but now this code fails
>
lcsqlSelect = "SELECT * from isinvoices"
>IF SQLEXEC(lnSqlHandler,lcSqlselect,"Cur1") <0
>
>
>~M

What is the error this time? Do you have IsInvoices table and does this user has access rights to the tables?
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform