Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How can i guess a sql server is already install on my pc
Message
 
 
À
05/02/2008 09:55:54
Arjun Bagojikop
Dynamic Super Software
Sangli, Inde
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01289516
Message ID:
01289532
Vues:
11
This message has been marked as the solution to the initial question of the thread.
>hi All
>how can i guess a sql server is already install on my pc through programatically.
>even i want to start and stop service programatically. if any idea please give me suggestion.
>
>thanks in Advance
>Regards From
>arjun

Well, I found the following http://www.devx.com/vb2themax/Tip/18459 and I found some code in Sergey's message:
LOCAL oSQL AS "SQLDMO.SQLServer", ;
  oDatabase AS "SQLDMO.Database"

oSQL = CREATEOBJECT('SQLDMO.SQLServer')
oSQL.Connect(< server name >, < user name >, < password >)
oDatabase = oSQL.DataBases("pubs")
lcCmd = "DBCC CheckDB"
lcMsg = ""
oDatabase.ExecuteWithResultsAndMessages(lcCmd,, @lcMsg)
If it's not broken, fix it until it is.


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

Click here to load this message in the networking platform