Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    1

    Question Unanswered: SQL1109N The specified DLL "Insert_OIG_SSNs.insert_OIG_SSNs" could not be loaded.

    Hi all,

    I am trying to connect to an remote database server in order to acess a stored procedure.

    I configured an Db2 client version 7.2 on my M/c to talk to the remote server. Connection came out to be sucessful but then i am gettign the following error. Can any one help me with this.


    COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/NT] SQL1109N The specified
    DLL "Insert_OIG_SSNs.insert_OIG_SSNs" could not be loaded.

    at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_S QLException(SQLExce
    ptionGenerator.java:270)
    at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_S QLException(SQLExce
    ptionGenerator.java:207)
    at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_r eturn_code(SQLExcep
    tionGenerator.java:458)
    at COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute2 (DB2PreparedStateme
    nt.java:2110)
    at COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute( DB2PreparedStatemen
    t.java:3887)
    at OigMQ.insertSSN(OigMQ.java:175)
    at OigMQ.main(OigMQ.java:55)


    Thank you

    Regards,
    Vikram

  2. #2
    Join Date
    Oct 2001
    Location
    Bangalore
    Posts
    186
    Hi Vikram,

    Is the object.object whose DLL mentioned here has failed to load, a stored procedure.
    If it is a stored procedure check whether it is compiled or not.

    When the procedure gets compiled, a DLL is created in the
    Program Files\SQLLIB\function\routine\sqlproc\dbname folder.

    Check it and let us know.

    Cheers,
    Prashant

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •