Timer86
04-14-2022, 09:24 AM
Hi All,
i have an issue with my vba code, in my vba code i was able using the DB2 with V9.7fp9 drivers to execute a query and then grab some data on it, however after the recent change of the DB drivers buy the db master, whenever i do the same identic query, i obtain the errore: Provider Cannot Be Found.
i tried to search some maybe installation of any new Db2 11, and i did, but the issue is continue to be not resolved and the message is the same, Provider cannot be found.
here so
me query sample any sugggestion?
im strConnectionString2
strConnectionString2 = " Provider=IBMADB2;Database=ECRT;HOSTNAME=crt.pi.it;PROTOCOL=TCPIP;PORT=50004 ;uid=username;pwd=password;"
Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.ConnectionTimeout = 30
conn.Open strConnectionString2
i have an issue with my vba code, in my vba code i was able using the DB2 with V9.7fp9 drivers to execute a query and then grab some data on it, however after the recent change of the DB drivers buy the db master, whenever i do the same identic query, i obtain the errore: Provider Cannot Be Found.
i tried to search some maybe installation of any new Db2 11, and i did, but the issue is continue to be not resolved and the message is the same, Provider cannot be found.
here so
me query sample any sugggestion?
im strConnectionString2
strConnectionString2 = " Provider=IBMADB2;Database=ECRT;HOSTNAME=crt.pi.it;PROTOCOL=TCPIP;PORT=50004 ;uid=username;pwd=password;"
Set conn = New ADODB.Connection
Set rs = New ADODB.Recordset
conn.ConnectionTimeout = 30
conn.Open strConnectionString2