Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Connection String
Message
 
 
À
19/06/2006 14:56:33
Randy Hooper
Ranco Business Software
Tampa, Floride, États-Unis
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 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01130047
Message ID:
01130134
Vues:
18
Randy,

Sure.
if ( "PROG-DFRANK" $ sys(0) )
   set path to office_dir_structure...
   lcConnectTo = "devsql02"
else
   set path to home_dir_structure...
   lcConnectTo = "(local)"
endif

set classlib to microsystem additive

public oSystem
osystem = createobject( "sqlservermicrosystem" )
with oSystem
   .cServername = lcConnectTo
   .cDatabase = "HHCommon"
   ? .GetConnection()
endwith
the microsystem class tree is an object wrapper around SPT calls.

If you are using a DBC and remote views you can swap out the connection as appropriate.

>Can a connection string be change at run time? I have develop an application from my home office and in my connection string I have the IP address for the server I'm hitting. Now I'm going to move my app in side the office I need to change the IP address to the server I'm wanting to use.
>
>I think this is what's going on the app runs fine from my home office I have move it to the office I'm getting the connection failure error and when the dialog box comes up I can enter in the IP address and all works fine.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform