Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
DB2 Connect connection with IE 11
#1
Not Solved
I am first timer.   Rolleyes
I have this code to connect to an IBM mainframe via DB2 Connect. It worked with UFT 11.53  and EI 10, I tested with IE 11 and it failed at objConnection.Open strCon. I upgraded to UFT12 same problem. "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"

Set objConnection = CreateObject("ADODB.Connection")
Set objRecordset = CreateObject("ADODB.Recordset")

Dim strCon, SQLStr

strCon = "driver={IBM DB2 ODBC DRIVER - DB2};Database=TestDB2;hostname=DB2CONNSRV1;port=50000;protocol=TCPIP; uid=" & signonuser & "; pwd=" & signonpass

objConnection.Open strCon
Reply
#2
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


Possibly Related Threads…
Thread Author Replies Views Last Post
  Connect to IBM MQ using UFT 12.5 soumen 2 4,625 03-17-2016, 11:16 AM
Last Post: vinod123
  [UFT] Connection String for Oracle robertosalemi 6 12,357 01-15-2016, 04:51 PM
Last Post: robertosalemi
  IBM DB2 connection with VB script bmurali 2 10,977 12-18-2015, 12:38 PM
Last Post: vinod123
  Connection with HP ALM hachem 0 2,661 02-26-2015, 04:36 PM
Last Post: hachem
  “Cannot connect to 8822 (connection timed out)" Ikbal 0 2,181 12-08-2014, 11:38 PM
Last Post: Ikbal

Forum Jump:


Users browsing this thread: 1 Guest(s)