Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remote view with SQLSTRINGCONNECT?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows NT
Database:
MS SQL Server
Divers
Thread ID:
01146479
Message ID:
01146518
Vues:
27
try this:
*** replace Connection string with actual one you used
CLOSE DATABASES all
CREATE DATABASE test
CREATE CONNECTION Test CONNSTRING [Driver={SQL Server};Server=XXXXXXXXXXX;Trusted_Connection=yes;DataBase=master]
CREATE SQL VIEW Test REMOTE CONNECTION Test AS SELECT * from SysObjects
USE Test
BROWSE
USE
DELETE CONNECTION Test
CLOSE DATABASES ALL
lnSQL = SQLSTRINGCONNECT([Driver={SQL Server};Server=XXXXXXXX;Trusted_Connection=yes;DataBase=master])
USE Test!Test CONNSTRING lnSQL
BROWSE
SQLDISCONNECT(0)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform