SQLAllocHandle on SQL_HANDLE_ENV

[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

[bruce]

Is this error persistent?



[b]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">

[jordanbrock]

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

[bruce]

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.

[b]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">

[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]

OK, so now it's stopped happening again. Grrrr.

[bruce]

Very strange.

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

[b]quote:Originally posted by jordanbrock

OK, so now it's stopped happening again. Grrrr.
</blockquote id="quote"></font id="quote">