DB2 URL connection string for VBScript

Hi All,

Can anyone please help me with connection string for DB2 URL connection string using vbscript?

Thanks,
Lakshmikanth

1 answer

IBM AS400 Database access using vbscript uses the iSeries for Windows data connector installed on the IIS server pass SQL string to function, returns array of results.

example: arrResults = DB("select * from library.member")

Private Function DB(strSQL)
	Const adOpenForwardOnly = 0, adOpenStatic = 3, adUseServer = 2, adLockReadOnly = 1
	Dim objRS, strConn
	strConn = "Provider=IBMDA400;" & "Data Source=DataSourceName;" & "User Id=userid;" & "Password=password"
	Set objRS = Server.CreateObject("ADODB.Recordset")
	With objRS
		.CursorType = adOpenForwardOnly
		.CursorLocation = adUseServer
		.LockType = adLockReadOnly
		.ActiveConnection = strConn
		.Source = strSQL
		.Open
		If .BOF then
			DB = Null
		Else
			DB = .GetRows()
		End If
		.Close
	End With
	Set objRS = Nothing
End Function