Reserved error (-7778); there is no message for this error.


  • What is wrong with my command?  I'm trying to use VBA to import a table from DB2 to MS Access.

    acImport, _ 
    "ODBC Database", _ 
    "ODBC;Driver=IBM DB2 ODBC DRIVER;" &
    _ "Hostname=A70DB2P;DBALIAS=A70DB2P;"
    & _ "UID=db2user;PWD=12345678;",
    acTable, _ 
    "ESDWI.T_SYSTEM_ID", "TESTimport"

    Friday, July 13, 2012 3:43 PM

All replies

  • Hi Smith,

    Welcome to the MSDN forum!

    Please check these links to see if they help:

    ACC2000: Using File DSN to Import or Link a FoxPro ODBC Data Source Causes Reserved Error -7778

    Reserved error (-7778) There is no message for this error 

    Reserved error -7778 - ODBC connection to IBM DB2 ODBC DRIVER


    Yoyo Jiang[MSFT]
    MSDN Community Support | Feedback to us

    This response contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.

    Monday, July 16, 2012 7:35 AM