error while calling a DB2 stored procedure

[Ashish Sheth]

Hi all,
I am calling a stored procedure named 'NUALP_NUMID_GEN' on DB2 database. It
is giving me the following error. What might be the cause?

System.Data.OleDb.OleDbException: [DB2/NT] SQL1109N The specified DLL
"NUALP_NUMID_GEN" could not be loaded.
at System.Data.OleDb.OleDbDataReader.ProcessResults(Int32 hr)
at System.Data.OleDb.OleDbDataReader.NextResult()
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior
behav
ior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.OleDb.OleDbCommand.ExecuteReader()
at StoredProcCheck.Class1.Main(String[] arg) in
d:\nualpproject\storedprocche
ck\class1.cs:line 34

thanks and regards,
Ashish Sheth

 

[Guest]

NOTE: I am not a DB2 expert, so I do not know the proper words for talking
about DB2. I have worked with the concepts before, however.

It depends on the setup of your DB2 database. With some setups, you need to
specify the instance/library (?) you are calling the sproc under. For
example, the "instance/library" may be called Production. To call
'NUALP_NUMID_GEN' you may have to acutally call Production.NUALP_NUMID_GEN.
This appears to work a bit differently under COM based systems, which is why
the confusion occurs.


---

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************