Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

VB and TSQL Query?

Status
Not open for further replies.
bowwow

bowwow

IS-IT--Management
Jun 11, 2002
60
GB
Hi All

Is it possible to run a TSQL query (aka 'SELECT * FROM' etc) from within a VB Script. Ive made the following connection from the VB Script, is this the right method of connecting into SQL to then run the TSQL Query?

----------

strDBServerName = "."

Set objSQLServer = CreateObject("SQLDMO.SQLServer")
objSQLServer.LoginSecure = True
objSQLServer.Connect strDBServerName

-----------

Any pointers much appreciated.
Kind Regards
Andrew
 
Status
Not open for further replies.

Similar threads

K
  • Question
VBSCRIPT dont work windows 11 23h2 ???
Replies
2
Views
213
SoftwareRT
SoftwareRT
bdwilcox
  • Question
Trying to adapt VBScript to search if machine is in an AD group 6
Replies
8
Views
790
SoftwareRT
SoftwareRT
lunter
  • Locked
  • Question
How to create vbArray+vbByte (8209) in *.vbs stript
Replies
0
Views
152
lunter
lunter
asel
  • Locked
  • Question
Copy cell data from excel and paste into portable software application
Replies
0
Views
124
asel
asel
GessWurker1
  • Locked
  • Question
problem with AD query, empty values and form field population
Replies
0
Views
88
GessWurker1
GessWurker1

Part and Inventory Search

Sponsor

Back
Top