I have created a COM dll in Visual Basic.
I also created a client app in VB and
a client app in ASP. I'm using Sybase 11 ODBC Driver.
to connect.

The VB client is working fine, however,
the asp client fails when in try to create a
connection for the second time.

The failure seems like the connection is not properly closed, or
doesn't allow a new connection at all.

I have tried setting the ODBC settings like AUT = 1,
Prepare method = 2(Full), and select method = 0(cursors).
But still it fails in ASP only.

Has anyone of you created a COM dll that extracts data from sybase
and passes a disconnected recordset or whatever to the client app.

If you can give me examples, I would appreciate it. Thanks!