Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQLConnect Issues
Message
 
 
À
10/03/2003 08:24:56
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00763562
Message ID:
00763588
Vues:
11
Clarification. There's always current database for any connection. If one is not specified in connection string than default DB for the user that made connection is used. The technique below can be used with any type of ODBC connection to Sql Server, DSN or DSN-less.

>
>You could use SQLStringConnect and define no database. You could directly refer to a table with Database.Owner.TableName or switch database with use command. ie:
>
>
>lnHandle = SQLStringConnect('Driver=SQL server;Server=servername;'+;
>  'Integrated Security=SSPI;')
>SQLExec(lnHandle,'select * from Northwind.dbo.employees')
>SQLExec(lnHandle,'use Pubs') && Database pubs
>SQLExec(lnHandle,'select * from authors')
>
Cetin
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform