![](/uploads/1/2/5/5/125524614/348880751.jpg)
OK, here are the details. I have an SQL server with a database that is currently in used on a live website. The website is currently running as a cold fusion app. I have spent the past week converting all the cold fusion to ASP. Now, I am ready to test my conversion. So, I made a copy of the live database for testing, changed the DSN on my webserver to point to the test database, setup the username and password for the test database correctly, and changed my Initial Catalog in my ASP code to point to the test database.
This is what I get whenever I run queries against the test database:
The timeout period elapsed prior to completion of the operation or the server is not responding. Connection timeout expired during select query on sql server 2000 8.00.194 How to execute query without 'Timeout expired' exception for large data.
quote:Microsoft OLE DB Provider for SQL Server error '80040e31'
Timeout expired
/pjr/joblist_results.asp, line 72
This is line 72 of joblist_results.asp:
code:
Obviously, it is hanging on the execution of the query. I know the query is correct because I set the all the database stuff (DSN, Initial Catalog, etc..) back to the live database and ran the query against that and everything worked fine.
![Classic Asp Microsoft Odbc Sql Server Driver Query Timeout Expired Classic Asp Microsoft Odbc Sql Server Driver Query Timeout Expired](http://www.ironspeed.com/designer/12.2.0/webhelp/desktop/Part_VIII/Part_VIII_files/image357.png)
Any clues of what I might be doing wrong with the test database?
ASP Tutorials
ASP HOMEWP Tutorial
WebPages IntroWebPages RazorWebPages LayoutWebPages FoldersWebPages GlobalWebPages FormsWebPages ObjectsWebPages FilesWebPages DatabasesWebPages HelpersWebPages WebGridWebPages ChartsWebPages EmailWebPages SecurityWebPages PublishWebPages ExamplesWebPages ClassesASP.NET Razor
Razor IntroRazor SyntaxRazor C# VariablesRazor C# LoopsRazor C# LogicRazor VB VariablesRazor VB LoopsRazor VB LogicASP Classic
ASP IntroASP SyntaxASP VariablesASP ProceduresASP ConditionalsASP LoopingASP FormsASP CookiesASP SessionASP ApplicationASP #includeASP Global.asaASP AJAXASP e-mailASP Examples![Sql Sql](/uploads/1/2/5/5/125524614/560490636.jpg)
ASP Reference
ASP VB FunctionsASP VB KeywordsASP ResponseASP RequestASP ApplicationASP SessionASP ServerASP ErrorASP FileSystemASP TextStreamASP DriveASP FileASP FolderASP DictionaryASP AdRotatorASP BrowserCapASP Content LinkingASP Content RotatorASP Quick RefADO Tutorial
ADO IntroADO ConnectADO RecordsetADO DisplayADO QueryADO SortADO AddADO UpdateADO DeleteADO DemoADO Speed UpADO Objects
ADO CommandADO ConnectionADO ErrorADO FieldADO ParameterADO PropertyADO RecordADO RecordsetADO StreamADO DataTypes![](/uploads/1/2/5/5/125524614/348880751.jpg)