Post reply

CSV to Oracle Error

  • September 23, 2003 at 9:08 pm

    #106619

    Hi All,

    im trying to upload a CSV file using DSN connection to Oracle database using DTS. it sometime fails due to this errror.

    "Specified driver could not be loaded due to system error 1114 (Microsoft Text-Treiber (*.txt; *.csv))"

    can anyone help me, why this error occurs? Thanks a lot.

  • September 23, 2003 at 9:18 pm

    #475527

    Error 1114 indicates a DLL failed to initialize.

    Try re-installing MDAC, or maybe re-registering ODBCJT32.DLL

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

  • September 24, 2003 at 3:53 am

    #475556

    Hi Carter,

    If that is the case what you mentioned, it should fail all the time when it runs right? but when i rerun the process, its working fine. anyway i would try re-installing the MDAC. Thanks for your reply

  • September 24, 2003 at 8:17 pm

    #475711

    quote:

    If that is the case what you mentioned, it should fail all the time when it runs right? but when i rerun the process, its working fine.

    Not necessarily the case, a flaky DLL can load successfully one time, not the next, and vice versa. It can depend on what is currently in memory when the DLL is initialised.

    Hope this helps

    Phill Carter

    --------------------

    Colt 45 - the original point and click interface

    --------------------
    Colt 45 - the original point and click interface

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply