What type of dll is it?<BR>What type of database connection are you using - ODBC,OLE DB, native?<BR>What is the Database format - SQL Server, Oracle, DB2 ...?<BR><BR>This information will make it easier to answer.
It is a vb component. <BR>ODBC connection<BR>SQL Server.<BR>Actually i am passing values from ASP form to the component. From the component i am executing SP which will fetch me a value from the SP. It is working fine when i execute from query window. But i dont how to catch this value in the component.<BR><BR>Thanks If U do Solve this
When you call the SP from your DLL, make sure you setup the output parameter as type: adParamOutput<BR><BR>In the return from an ADO command object the code would look something like:<BR><BR>sTicket = ADO.Command.Parameters("@Ticket").Value