Database suddenly inaccessible

[cragi]

I haven't performed any updates on the site, but suddenly I get an error message on pages that access the database. The only modifications I was doing were on the directory permissions, and I reset those to see if that affected the database somehow. This is the message received:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

/search/includes/db_open.asp, line 12



The line of code its referring to is:
Con.Open "Driver={SQL Server};Server=mssql05.discountasp.net;Network=DBM SSOCN;Database=DB_65955;Uid=XXXXXXXX;Pwd=XXXXXX"

Where XXXXXXX refers to my username & Password

[bruce]

This is a common problem w/ ODBC

Switch your code to OleDB should solve the problem, see http://kb.discountasp.net/article.aspx?id=10061


quote:Originally posted by cragi

I haven't performed any updates on the site, but suddenly I get an error message on pages that access the database. The only modifications I was doing were on the directory permissions, and I reset those to see if that affected the database somehow. This is the message received:
[b]Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

/search/includes/db_open.asp, line 12



The line of code its referring to is:
Con.Open "Driver={SQL Server};Server=mssql05.discountasp.net;Network=DBM SSOCN;Database=DB_65955;Uid=XXXXXXXX;Pwd=XXXXXX"

Where XXXXXXX refers to my username & Password

</blockquote id="quote"></font id="quote">