Vbscript connect mssql

Const adLockBatchOptimistic = 4
Const adUseClient = 3 

Set iconnTrans = CreateObject("ADODB.Connection")

iconnTrans.open _
	"Provider=SQLOLEDB.1;Data Source = localhost\sqlexpress;Integrated Security = SSPI;Initial Catalog=dw2"

Set rsTrans = CreateObject("ADODB.Recordset")

rsTrans.CursorLocation = adUseClient
rsTrans.LockType = adLockBatchOptimistic
rsTrans.open "SELECT * FROM ir_Transactions", iconnTrans

Source: vbforums.com

Similar codes

0 vote322 views1 answer
How to drop a column in mysql laravel stackoverflow
SQL
49 votes372 views6 answers
Get duplicate records in sql
SQL
9 votes318 views3 answers
Oracle undo usage by session
SQL
1 vote329 views1 answer
Found option without preceding group in config file: /etc/mysql/mariadb.conf.d/50-server.cnf at line: 1
SQL
0 vote338 views1 answer
Sql find record cannot cast date
SQL
3 votes301 views4 answers
Show sql server database
SQL
0 vote350 views1 answer
Login failed for user sql server
SQL
1 vote329 views1 answer
Oracle drop chain step
SQL
2 votes336 views2 answers
Mysql find max value row
SQL
0 vote350 views1 answer
Postgres dump sql insert
SQL