Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
IBM DB2 connection with VB script
#3
Not Solved
Code:
Set cmd = Server.CreateObject("ADODB.Command")
cmd.ActiveConnection = ConnVar
cmd.CommandType = adCmdStoredProc
cmd.CommandText = "Test"
cmd.Parameters.Append(cmd.CreateParameter("@my_date", adVarChar, adParamInput,10))
cmd.Parameters("@my_date") = "10/12/2012"

Set rsResults = Server.CreateObject("ADODB.Recordset")
rsResults.CursorLocation = adUseClient
rsResults.Open cmd,,adOpenForwardOnly,adLockBatchOptimistic


Using CursorLocation = adUseClient means you can navigate the rsResults RecordSet using MoveNext, MoveFirst etc.
Reply


Messages In This Thread
IBM DB2 connection with VB script - by bmurali - 08-06-2014, 11:55 AM
RE: IBM DB2 connection with VB script - by SRP - 12-17-2015, 10:35 PM
RE: IBM DB2 connection with VB script - by vinod123 - 12-18-2015, 12:38 PM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Connect to IBM MQ using UFT 12.5 soumen 2 4,574 03-17-2016, 11:16 AM
Last Post: vinod123
  [UFT] Connection String for Oracle robertosalemi 6 12,287 01-15-2016, 04:51 PM
Last Post: robertosalemi
  DB2 Connect connection with IE 11 SRP 1 2,621 12-18-2015, 12:41 PM
Last Post: vinod123
  Connection with HP ALM hachem 0 2,622 02-26-2015, 04:36 PM
Last Post: hachem
  “Cannot connect to 8822 (connection timed out)" Ikbal 0 2,138 12-08-2014, 11:38 PM
Last Post: Ikbal

Forum Jump:


Users browsing this thread: 2 Guest(s)