Linking ODBC table programmatically

[jackyccc]

HI all, i'm trying to link an ODBC table into MS Access programmatically by using the following VBA code. But it gives me the error message "Could not find installable ISAM." Can anyone please help me out? Thanks..


DoCmd.TransferDatabase acLink, "ODBC Database", "driver={IBM DB2 ODBC DRIVER};DBALIAS=DB2;UID=username;PWD=password", acTable, "ISO47.UAT00000", "Linked_ISO47_UAT00000"

 

[Pat Hartman]

I don't have access to DB2 so I can't tell if your connection string is correct. I would link the table manually and then open the MSysObjects table and copy the connection string to be sure it was typed correctly.

 

[boblarson]

This is the connection string (according to the Connection Strings website
http://www.connectionstrings.com/?carrier=ibmdb2 )

Driver={IBM DB2 ODBC DRIVER};Database=myDataBase;Hostname=myServerAddress;Port=1234;Protocol=TCPIP;Uid=myUsername;Pwd=myPassword;