SQLAllocHandle on SQL_HANDLE_ENV

Discussion in 'Databases' started by jordanbrock, Jul 26, 2003.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. jordanbrock

    jordanbrock

    Howdy,

    I am just trying to open a connection to a database, and am getting the following error:

    SQLAllocHandle on SQL_HANDLE_ENV

    My Connect string is as follows:

    <%
    dim dbConn
    set dbConn = Server.CreateObject ("adodb.Connection")
    dbConn.Open "DSN=spintechcom_sqlConn;uid=XXXXX;pwd=XXXXX"
    %>

    Has anyone else come across this?

    Cheers,
    Jordan
     
    jordanbrock, Jul 26, 2003
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    Is this error persistent?



    quote:Originally posted by jordanbrock

    Howdy,

    I am just trying to open a connection to a database, and am getting the following error:

    SQLAllocHandle on SQL_HANDLE_ENV

    My Connect string is as follows:

    <%
    dim dbConn
    set dbConn = Server.CreateObject ("adodb.Connection")
    dbConn.Open "DSN=spintechcom_sqlConn;uid=XXXXX;pwd=XXXXX"
    %>

    Has anyone else come across this?

    Cheers,
    Jordan

    </blockquote id="quote"></font id="quote">
     
    Bruce, Jul 27, 2003
    #2
  3. jordanbrock

    jordanbrock

    It was happening for about a week, and when I checked it this morning everything was ok. Any ideas?
     
    jordanbrock, Jul 27, 2003
    #3
  4. Bruce

    Bruce DiscountASP.NET Staff

    Hmmm....

    I haven't seen this error before. It'll be tough if we can't replicate this.

    Let us know if you see this again.

    quote:Originally posted by jordanbrock

    It was happening for about a week, and when I checked it this morning everything was ok. Any ideas?


    </blockquote id="quote"></font id="quote">
     
    Bruce, Jul 28, 2003
    #4
  5. jordanbrock

    jordanbrock

    Bruce,

    This error is occurring again. You can see it for yourself at

    http://www.balneaire.com.au/content/monets.asp

    I dispose of the connection at the end of the page, as well as the recordsets used within the page. I have not modified the content since the page was working properly earlier on this week.

    Cheers,
     
    jordanbrock, Jul 30, 2003
    #5
  6. jordanbrock

    jordanbrock

    OK, so now it's stopped happening again. Grrrr.
     
    jordanbrock, Jul 31, 2003
    #6
  7. Bruce

    Bruce DiscountASP.NET Staff

    Very strange.

    I'll send this to the SA and see if they can figure anything out

    quote:Originally posted by jordanbrock

    OK, so now it's stopped happening again. Grrrr.
    </blockquote id="quote"></font id="quote">
     
    Bruce, Aug 1, 2003
    #7
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page