Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Auto create odbc
Message
De
19/04/2004 05:19:23
 
 
À
19/04/2004 04:57:41
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00896018
Message ID:
00896045
Vues:
14
You can crate connection as a string connection in Your DB before create a remote view & then yuse that connection for creating the view. Other way is to crate File DSN from Control Panel->ODBC copy & paste contents of that file.

something like that:
  #define CRLF CHR(13)+CHR(10)
  m1 = "[ODBC]"+CRLF+;
       "DRIVER=SQL Server"+CRLF+;
       "UID=YourUserID"+CRLF+;
       "PWD=YourUserPassword"+;
       "DATABASE=Task"+CRLF+;
       "WSID=BORIS"+CRLF+;
       "APP=Microsoft Open Database Connectivity"+CRLF+;
       "SERVER=YourSQLServeName"
STRTOFILE(m1, [c:\program files\Common files\ODBC\Data sources\MyDSN.DSN])
but I thing to crate connection in Yur DB where the RV is stored is much easier.
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