cancel
Showing results for 
Search instead for 
Did you mean: 

Mainframe DB2 table access

AarthiVellingir
Level 3
Hi I am trying to connect Mainframe DB2 Tables using OLEDB VBO Below is the connection string I tried "Provider=IBM DB2 ODBC DRIVER;Database=DSNT;Hostname=1xx.xx.xx.xxx;Protocol=TCPIP; Port=60000;Uid=;Pwd=;" I am receiving an error Internal : Could not execute code stage because exception thrown by code stage: The 'Provider=IBMDADB2;Database=DSNT;Hostname=1xx.xx.xx.xxx;Protocol=TCPIP; Port=60000;Uid=;Pwd=; provider is not registered on the local machine. Could anyone suggest on this?
3 REPLIES 3

John__Carter
Staff
Staff
Looks like your machine does not have the necessary driver. I suggest contacting your IT team.

DougHeller
Level 2
Was there a solution to this issue?  I am starting to configure a process that includes updating a DB2 table as part of the overall reference.  Any and all help is appreciated.

UvarajThangavel
Level 4
Yes, i too looking forward for a solution to connect with DB2 via Network authentication option. do anyone have any idea how to do that?