Regarding execution of stored Procedure

I m Girish Pandit,

I m executing a stored procedure by calling "dblib" Library Functions

i create two functions, in first function i initialise PDBPROCESS

structure with necessary information like, login, user, passwd

SQL- server name, database name.

in second function in same PDBPROCESS structure i pass stored procedure

name, and the execute that.

result set is again in PDBPROCESS structure.

up to this stage it work perfactly, this funtion gives o/p only once

if i m executing second function once again it fails to execute,

the same stored procedure which was executing last time.

to execute this stored procedure again from second function i hv to again initialise the first function. then it will work.
[810 byte] By [Girish Pandit] at [2007-11-15 22:06:49]