Jay
Newbie
Join Date: 6/25/2009
Posts: 3
|
|
|
Posted: 6/26/2009 11:26:22 AM
|
|
|
I installed DMG forums on one of my websites and it was working fine. Then all of a sudden, it started producing an error. The error is
ERROR [HYT00] [Microsoft][ODBC SQL Server Driver]Timeout expired
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.Odbc.OdbcException: ERROR [HYT00] [Microsoft][ODBC SQL Server Driver]Timeout expired
Stack Trace:
[OdbcException (0x80131937): ERROR [HYT00] [Microsoft][ODBC SQL Server Driver]Timeout expired]
System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode) +1156770
System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle) +95
System.Data.Odbc.OdbcConnectionOpen..ctor(OdbcConnection outerConnection, OdbcConnectionString connectionOptions) +53
System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) +55
System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +29
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +4863644
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +117
System.Data.Odbc.OdbcConnection.Open() +40
DMGForums.Global.Database.Read(String strSql, Int32 Rows) +145
DMGForums.Global.Settings..ctor() +155
ASP.Settings..ctor() +13
ASP.default_aspx.__BuildControl__control2() +26
ASP.default_aspx.__BuildControlTree(default_aspx __ctrl) +62
ASP.default_aspx.FrameworkInitialize() +46
System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +56
System.Web.UI.Page.ProcessRequest() +80
System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) +21
System.Web.UI.Page.ProcessRequest(HttpContext context) +49
ASP.default_aspx.ProcessRequest(HttpContext context) +4
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +181
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75
So far I
1.I have reinstalled my database
2.Created a new database
3.Reinstalled the forums
4.Read the forums here
5.Searched the internet
6.Repeated steps 1-5
None of thee above worked. Can someone give me a suggestion as to what is wrong?
|
|
grimmeissen
Administrator
Join Date: 8/30/2005
Posts: 656
Location: Cincinnati, Ohio
|
|
|
Posted: 6/27/2009 9:20:32 PM
|
|
|
Most of the stuff I have found from searching points to a network issue. When the DB requests are being made, they are taking such a long time that the ODBC driver is giving up.
Try using the IP address in the connection string rather than a hostname.
|
|
Jay
Newbie
Join Date: 6/25/2009
Posts: 3
|
|
|
Posted: 6/28/2009 11:54:00 PM
|
|
|
ok, tried that and it worked, for a few hours. In my web.config file there is a the line <add key="DatabaseString" value="Driver={SQL Server};Server=YOUR_SERVER;Database=YOUR_DATABASE;Uid=YOUR_USERNAME;Pwd=YOUR_PASSWORD;" /> with the proper informaion in it. That should be all that is needed to make a ODBC connection. If this is correct, are there anymore solutions?
|
|
grimmeissen
Administrator
Join Date: 8/30/2005
Posts: 656
Location: Cincinnati, Ohio
|
|
|
Posted: 6/30/2009 7:12:14 AM
|
|
|
I would assume your connection string is correct, because the ODBC driver is not coming back and saying that it can't find the database. It is coming back and saying that communications with the database are extremely slow.
Beyond that I don't really have any ideas as to how to help you. It seems like a communication issue between the web app and the database server.
|
|