Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2004
    Posts
    2

    Unanswered: AsaConnection Problem

    Hello,

    I've got a little problem. When I connect to my Sybase database with a webapplication I get two connections. When I do the same with a win32 application i get only 1 connection.

    This is the code:
    ' Dim myAsaConnection As New AsaConnection("...")
    ' myAsaConnection.Open()
    ' myAsaConnection.Close()

    Can someone help me with this?

    Greetz,

    Martijn

  2. #2
    Join Date
    Nov 2003
    Location
    Christchurch, New Zealand
    Posts
    1,618
    Not sure why you would be getting two conenctions. perhaps if you posted the web app code I may be able to come up with something (the above code looks like the windows app code).

    One possible thing might be that you are not setting your connections to nothing (eg set ASAConnection=nothing) which will kill the object completely and perhaps IIS is managing some connection pooling...

    Like I said, without the code it is hard to say....

  3. #3
    Join Date
    Aug 2004
    Posts
    2
    This is the only code the progam has. I've made a webapplication in visual studio.net, add a button and put code behind the button.

    What you say works but on a very strange way.

    I tried it earlier to set the connection to nothing and it doesn't work. I've tried it now and it works. But i have to restart my computerc change the code and test the connection. If it doesn't work right: restart computer, chagne code and test connection. Strange but true.

    Now it works fine. (but for how long?)
    Last edited by IkBenOtto; 09-01-04 at 03:45.

Posting Permissions

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