' DB connection string
Const DB_CONNECT_STRING = " DRIVER={SQL Server};SERVER=CSILT13\SALESLOGIX;UID=sysdba;PWD=masterkey;DATABASE=Lease15CRM "
Set myConn = CreateObject("ADODB.Connection")
Set myCommand = CreateObject("ADODB.Command" )
myConn.Open DB_CONNECT_STRING
Set myCommand.ActiveConnection = myConn
myCommand.CommandText = " [your sql query goes here - Insert, update, delete] "
myCommand.Execute
myConn.Close
Tuesday, May 3, 2016
Update, Insert, Delete Record in SQL Server using VB Script
Subscribe to:
Post Comments (Atom)
No comments:
Write comments