Sql

Search

vbscript connect mssql

Const adLockBatchOptimistic = 4
Const adUseClient = 3 

Set iconnTrans = CreateObject("ADODB.Connection")

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

Set rsTrans = CreateObject("ADODB.Recordset")

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

Comment

PREVIOUS	NEXT

Code Example
Sql :: create a view in sqlite
Sql :: mysql update with subquery
Sql :: add current timestamp in mysql
Sql :: add column in sql server
Sql :: how to login sql server using cmd
Sql :: datediff
Sql :: begin transaction sql
Sql :: sql function
Sql :: oracle timestamp to date
Sql :: oracle show procedures
Sql :: generate a random otp in sql server
Sql :: create database sql
Sql :: CALCULATING MONTHS BETWEEN TWO DATES IN POSTGRESQL
Sql :: postgresql get today
Sql :: how to transfer pandas datafra,e to sqlite
Sql :: default constraint in ms sql
Sql :: split string from comma in sql
Sql :: convert varchar column to int in sql server
Sql :: mysql select true or false
Sql :: encrypt password postgresql
Sql :: oracle number to percentage
Sql :: how to find the number of rows updated in oracle pl/sql
Sql :: mysql select default if null
Sql :: json query
Sql :: how to enable mysql 5.7 root user password on linux
Sql :: sqlite unique
Sql :: c# sqldatareader to list
Sql :: mysql delete database
Sql :: Converting mysql tables to charset utf8mb4
Sql :: mysql select distinct date from timestamp

Search

SQL

vbscript connect mssql

ADD CONTENT