ODBC Driver Error - Timeout Expired
Feb 18, 2005
Very common error but wired scenario. Every client machine get this error in morning. VB application works fine until evening but when everyone goes home after shut down the machine and they come back again in morning and try to run the application they get this error. Application runs fine, It can access data, pull data, view data but It can not write any data. (Other words can not enter any data).
Application again starts working fine after I copy database on different SQL server. For temporary solution I swap database from one SQL Server to other one day and back to original SQL server next day. Every morning it takes about 2 hours to copy database. I’m doing this from last few days as working solution. FYI, I have 2 different VB application, each has their own database. One working fine and other started giving me problem, the one I described above.
Few thing I want to let you know:
Recently I changed the SQL server. After I changed I started having this problem. But other application working fine. So I don’t think that could be a problem. (Both application basically same in terms of development and tools they use. VB and SQL Server, ODBC connection, Crystal Reports).
In old SQL server both database had daily backup on third party backup built on different server using Client Network Backup. After I changed the SQL server I never modify backup setting. So after I moved SQL server , every night backup was trying to connect to old SQL server and but It couldn’t take the backup cause I changed the machine. Again if that’s the problem both application should not work but one working fine other is giving me problem.
One more thing I want to mention here is I started having this problem when I left the SQL server copying database overnight. Means, I started copying database and I left the machine ON when I came in the morning copying database was done and I just click on the OK and close the window. Basically It has finished copying database in around 2 hours after I started and I close the window when I came back next morning.
That’s the few things I’m thinking about but I don’t know what kind of database setting this might have changed and how to reset again. Any help will appreciated.
Dose any one know how to combine .mdf (Primary data file) and .ndf (secondary data file) ???
View 2 Replies
ADVERTISEMENT
Sep 28, 2005
Hi everyone
I have installed SQL server on my server machine. using localsystem and mixmode option.
It is working fine.
I installed sql server with connectivity tools only option on my client computer.
now, When i try to connect to server using data source from control panel --> Administrative tools --> Data source(ODBC).
but I cant connect.It gives me error as below.
Connection Failed:
SQLState:'HYT00'
Sql Server Error:0
[Microsoft][ODBC SQL Server Driver] Timeout Expired.
I uninstalled sql server from my client and server computer. and installed again.
I tried to ping from client computer to server computer it is working.
even i tried telnet sqlservername 1433
this one is also ok.
But same error facing
Please help me out.
Regards,
ASIF
View 1 Replies
View Related
May 17, 2001
Hi,
I am using SQL Server 7.0 Desktop Edition on Windows NT 4.0 workstation with service pack 6. I'm connecting to my production servers using the Enterprise Manager.A couple of months back, I have installed SQL Server 2000 Evaluation Edition on my desktop and using it to access the production servers.A couple of days back, I was not able to connect to the Query Analyzer either through Enterprise Manager or directly. I am getting the following error:
ODBC: Msg 0, Level 16, State 1
[Microsoft][ODBC SQL Server Driver] Timeout expired.
All our production servers are in a data center. I'm able to connect to the production servers in one particular cage but it is giving the above error if I try to connect to other servers which are in different cages. My colleague is able to connect to all the servers through Query Analyzer from his machine which has only SQL Server 7.0.I uninstalled SQL Server 2000 on his suggestion but it is giving the same error. I uninstalled and installed SQL Server 7.0 but I'm still getting the same problem.
Could you please throw some light on why this is happening ?
Thanks in advance,
MN Rao
View 1 Replies
View Related
May 23, 2002
I am trying to populate a View. I can run the sql code successfully by using SQL Query Analyzer. However, When I try to open the View in SQL Enterprise Manager and request that all rows be returned, I receive the following error:
ODBC SQL Server Driver Timeout Expired
I cannot determine the cause, Can anyone help me determine why the message is occurring? Thank you.
View 2 Replies
View Related
Oct 30, 2007
Hi
I'm running a machine with windows xp pro sp2. I have a MS Access 2000 database on that machine. The database contains 1 odbc linked table
and 1 Access query.
The odbc linked table is connected to a MS SQL Server 2000 database with a ODBC SQL Server System DSN.
The table on SQL Server to which the table in Access is linked has about
3 million + rows.
When I open the ODBC linked table in Access, it opens without a problem.
However, if I use even so much as one criterion such as "where company = ABC" for example, then it "thinks" for a while and returns the dreaded:
[Microsoft][ODBC SQL Driver] Timeout Expired (#0).
I have to use MS Access 2000 as the front end for this SQL Database table.
How do I get around the timeout issue. Is there a setting in SQL?
Please keep in mind that
I can't write the queries as Store procs because the requirement of the client is that there be one Linked Access table that the users can use
to write various access queries. No user are not techies.
please help
View 1 Replies
View Related
Jul 20, 2005
Hi,Has anyone ever had trouble using the query analyzer tool through a vpnclient? I'm able to connect outside of work to a sqlserver db on mycompany lan with enterprise mgr, but the query analyzer times out everytime I try to connect from outside of work. Both utilities work fine atwork (no vpn tunnel).The exact error is:Unable to connect to server blahblahblah:ODBC: Msg 0, Level 16, State 1[Microsoft][ODBC SQL Server Driver] Timeout expiredI've tried increasing the sqlserver odbc driver's CPTimeout without success.Appreciate any advice.Eric
View 2 Replies
View Related
Feb 5, 2008
Hi ,
Well i have one question regarding the Timeout . I have an SQL SERVER 2005 database and have an VB6.0 application. I have a stored procedure which inserts more than 90,000 rows from one table to another . Some times i get an exception as [Microsoft] [ODBC SQL Driver] Timeout Expired in the Visual Basic application and some times it works fine. The exception i receive within 30 seconds , but when i try the same stored procedure in query analyser , it works fine. also i have increased the timeout in visual basic , but still i get the same error.
Can anyone suggest.....
View 6 Replies
View Related
Jun 29, 2002
Hello,
When I connecting thru T-SQL, the following error was thrown.
Unable to connect to server 'SERVERNAME'
ODBC: Msg 0,Level 16, State 1
[Microsoft][ODBC SQL Server Driver] Timeout expired.
How to fix this?
regrads,
vnk.
View 2 Replies
View Related
Aug 19, 1999
I am running a query which pulls back about 200,000 records.
When I run this in ISQL (SQL Server 6.5), it runs in almost 2 minutes.
When I put it in a store procedure and run it off my ASP application, I
get this error
[Microsoft][ODBC SQL Server Driver]Timeout Expired
We've tried many things including:
1) Increased connection and command time outs in Global ASA
2) Have the ODBC driver log long Quires to a file
3) Changed Query Time out in Enterprise Manager(360 seconds) Go to
tools --> Preferences/configure -->Connection Tab
4) Changed Maximum allowed open database from 20 to 200
5) Changed resource timeout to 360 seconds from 5 seconds
6) Changed remote query timeout to 0, allowing infinite wait.
What else can we try???
Thanks for taking the time to read this
Joyce
View 2 Replies
View Related
Feb 1, 1999
Hi all,
I inherited some really twisted asp pages from another developer that crank for a long time. They used to work, albeit slowly. Now when I try to run one I get the error:
Microsoft OLE DB Provider for ODBC Drivers error '80040e31'
[Microsoft][ODBC SQL Server Driver]Timeout expired
Short queries run fine.
IIS4 & SQL Server are on the same box. I didn't the ASP pages or the IIS or SQL server config. I did install VStudio 6.0 a while back.
Anybody got any clues?
View 1 Replies
View Related
May 29, 2002
Thank you to all who reply to this perplexing question.
Mike
Database VMFGSRVRVMFG is SQL 2000 Std.
Database NT002P_GL is SQL 7.0.
All SQL versions are at the current SP levels.
I receive the timeout message when I am in EM,
database,VMFG(database), Views, Open View, Return All
Rows. I can successfully run the code in QA. I believe I
am running up against a time parameter in SQL Server. I
have reviewed all time parameters that I can find.
However, I still receive the error. What parameters should
I be looking at? I am attempting to create a view with the
following code:
--------------
CREATE view uv_olap_adj_co_profit as
select customer.id as customer_number,
customer.name as customer_name,
customer_order.salesrep_id as salesperson,
isnull(customer.country, 'USA') as country,
'7' as business_unit,
customer_order.order_type as order_type,
uv_olap_co_profit.customer_order,
uv_olap_co_profit.work_order,
uv_olap_co_profit.close_date,
uv_olap_co_profit.period_year,
uv_olap_co_profit.gl_period,
isnull((uv_olap_co_profit.billing + ut_man_adj.billing)
*ut_fin_adj.billing,
uv_olap_co_profit.billing*ut_fin_adj.billing) as billing,
isnull((uv_olap_co_profit.material_cost +
ut_man_adj.material)*ut_fin_adj.material,
uv_olap_co_profit.material_cost*ut_fin_adj.materia l) as
material,
isnull((uv_olap_co_profit.labor_cost + ut_man_adj.labor)
*ut_fin_adj.labor,
uv_olap_co_profit.labor_cost*ut_fin_adj.labor) as labor,
isnull((uv_olap_co_profit.burden_cost + ut_man_adj.burden)
*ut_fin_adj.burden,
uv_olap_co_profit.burden_cost*ut_fin_adj.burden) as
burden,
uv_olap_co_profit.service_cost as service
from uv_olap_co_profit,
ut_man_adj,
ut_fin_adj,
customer_order,
customer
where uv_olap_co_profit.customer_order *=
ut_man_adj.cust_order_id and
uv_olap_co_profit.work_order *= ut_man_adj.work_order and
uv_olap_co_profit.period_year = ut_fin_adj.year and
uv_olap_co_profit.customer_order = customer_order.id and
customer_order.customer_id = customer.id and
(customer_order.salesrep_id = 'LABELAIREP' or
customer_order.salesrep_id = 'OMOHUNDR' or
customer_order.salesrep_id = 'EGGERSR')
union all
select customer.id as customer_number,
customer.name as customer_name,
customer_order.salesrep_id as salesperson,
isnull(customer.country, 'USA') as country,
customer.user_2 as business_unit,
customer_order.order_type as order_type,
uv_olap_co_profit.customer_order,
uv_olap_co_profit.work_order,
uv_olap_co_profit.close_date,
uv_olap_co_profit.period_year,
uv_olap_co_profit.gl_period,
isnull((uv_olap_co_profit.billing + ut_man_adj.billing)
*ut_fin_adj.billing,
uv_olap_co_profit.billing*ut_fin_adj.billing) as billing,
isnull((uv_olap_co_profit.material_cost +
ut_man_adj.material)*ut_fin_adj.material,
uv_olap_co_profit.material_cost*ut_fin_adj.materia l) as
material,
isnull((uv_olap_co_profit.labor_cost + ut_man_adj.labor)
*ut_fin_adj.labor,
uv_olap_co_profit.labor_cost*ut_fin_adj.labor) as labor,
isnull((uv_olap_co_profit.burden_cost + ut_man_adj.burden)
*ut_fin_adj.burden,
uv_olap_co_profit.burden_cost*ut_fin_adj.burden) as
burden,
uv_olap_co_profit.service_cost as service
from uv_olap_co_profit,
ut_man_adj,
ut_fin_adj,
customer_order,
where uv_olap_co_profit.customer_order *=
ut_man_adj.cust_order_id and
uv_olap_co_profit.work_order *= ut_man_adj.work_order and
uv_olap_co_profit.period_year = ut_fin_adj.year and
uv_olap_co_profit.customer_order = customer_order.id and
customer_order.customer_id
View 1 Replies
View Related
Apr 9, 2001
Hi!,
I am running sqlserver 2000 enterprise edition on windows 2000.
When I try to run a select statement. I am encountering
[microsoft][odbc sql server driver] timeout expired
How do fix this problem?
Thanks,
Ranjan
View 1 Replies
View Related
Oct 30, 2007
I've tried every websearch possible to try and get a solution for this problem but can't.
Development Software:
SQL Server 2000
Enterprise Manager 8.0
Query Analyzer 8.00.194
Error:
When I run a mildly complex view in Enterprise Manager I get the error:[Microsoft][ODBC SQL Server Driver]Timeout Expired
after about 30 seconds.
When I copy and paste and run the exact same code in Query Analyzer the Query runs for longer than 30 seconds and runs until completion. Now my question is since this apparently seems to be an Enterpise Manager problem and not on the server end, where do I go in Enterprise Manager to change that setting? I've looked everywhere in Enterpise manager and can't find a "command timeout" setting.
Thanks!
View 4 Replies
View Related
May 18, 2004
Hello,
I installed MS SQL Server 2000 Evaluation Edition on
Windows XP Pro. I have database on the same PC. When I
am running a query(view) from Query Analyser I
get "[Microsoft][ODBC SQL Server Driver] Timeout Expired"
error message . When I am running the same view on
smaller amount of data it works.
:confused:
Could you please help me with that?
Thanks
DJ
View 3 Replies
View Related
Mar 6, 2008
Hi,
I have tried updating the DSN configure option i.e. 30000 milliseconds.
But I am still facing the problem of Timeout Expired.
I am using sql server 2005 for daily importing data from Excel Dump Files into sql server table.
Everyday the database gets updated.
The Error mentioned in Subject normally gets once a month, due to daily updation of database whether each table structure gets changed like index, trigger, etc.
Kindly let me know how to resolve this error.
Regards,
Srinivas Alwala
View 1 Replies
View Related
May 10, 2006
Hi,
Ive got a collection of view which piece together data from varying sources and assemble it ready for a stored procedure to squirt the data into a table.
This has worked fine up til yesterday when i had to amend one of the views to include a reference to another data set.
Essentially the data is for students and comes from our old db and our new one, each year group has different values so the views act to extract all data relevant for a child from both databases and accross all year data sets.
The problem im having is that i can get the final stored procedure to run. It ran fine the other day but since ive amended one of the views i get timeout errors wherever it's run. real problem when query analyser which has no timeout settings (apparently) times out as it means i cant run the query anywhere....enterprise manager will timeout after 30secs despite amending the query timeout setting to 600s.
so im a bit stuck, both views which the problem view is trying to combine run in under 30 seconds...when you try and combine them it times out- seems to run for a long long time.
note sure why this has started happening, from all ive read most peeps get this with EM and solve it using QA. but what if QA cant handle the query either?
heres the sql: (wont make much sense but hopefully shows that its not a complex query)
SELECT TOP 100 PERCENT dbo.StudentDetMaster.SetId, dbo.StudentDetMaster.StudentId,
dbo.StudentDetMaster.Name,
dbo.StudentDetMaster.CourseYear,
dbo.StudentDetMaster.House,
dbo.StudentDetMaster.Tutor,
dbo.PGJSProfile.[Key Stage 1 Reading],
dbo.PGJSProfile.[Key Stage 1 Writing],
dbo.PGJSProfile.[Key Stage 1 Speaking & Listening],
dbo.PGJSProfile.[Key Stage 1 Maths],
dbo.PGJSProfile.[Key Stage 2 English],
dbo.PGJSProfile.[Key Stage 2 Maths],
dbo.PGJSProfile.[Key Stage 2 Science],
dbo.PGJSProfile.[Verbal Reasoning Year 3],
dbo.PGJSProfile.[Year 3 English Autumn],
dbo.PGJSProfile.[Year 3 English Year Group Average],
dbo.PGJSProfile.[Year 3 English Summer],
dbo.PGJSProfile.[Year 3 English Year Group Average Score], dbo.PGJSProfile.[Year 3 Maths Autumn],
dbo.PGJSProfile.[Year 3 Maths Year Group Average],
dbo.PGJSProfile.[Year 3 Maths Summer],
dbo.PGJSProfile.[Year 3 Maths Year Group Average Score], dbo.StudentDetMaster.[Year 3 Maths Set],
dbo.PGJSProfile.[Verbal Reasoning Year 4],
dbo.PGJSProfile.[Year 4 English Autumn],
dbo.PGJSProfile.[Year 4 English Year Group Average],
dbo.PGJSProfile.[Year 4 English Summer],
dbo.PGJSProfile.[Year 4 English Year Group Average Score], dbo.PGJSProfile.[Year 4 Maths Autumn],
dbo.PGJSProfile.[Year 4 Maths Year Group Average],
dbo.PGJSProfile.[Year 4 Maths Summer],
dbo.PGJSProfile.[Year 4 Maths Year Group Average Score], dbo.StudentDetMaster.[Year 4 Maths Set],
dbo.PGJSProfile.[Verbal Reasoning Year 5],
dbo.PGJSProfile.[Year 5 English Autumn],
dbo.PGJSProfile.[Year 5 English Year Group Average],
dbo.PGJSProfile.[Year 5 English Summer],
dbo.PGJSProfile.[Year 5 English Year Group Average Score], dbo.PGJSProfile.[Year 5 Maths Autumn],
dbo.PGJSProfile.[Year 5 Maths Year Group Average],
dbo.PGJSProfile.[Year 5 Maths Summer],
dbo.PGJSProfile.[Year 5 Maths Year Group Average Score], dbo.StudentDetMaster.[Year 5 Maths Set],
dbo.PGJSProfile.[Verbal Reasoning Year 6],
dbo.PGJSProfile.[Year 6 English Autumn],
dbo.PGJSProfile.[Year 6 English Year Group Average],
dbo.PGJSProfile.[Year 6 English Year Group Average Score], dbo.PGJSProfile.[Year 6 Maths Autumn],
dbo.StudentDetMaster.[Year 6 Maths Set],
dbo.StudentDetMaster.[JS Baseline],
dbo.PGJSProfile.[Year 6 English Mock],
dbo.PGJSProfile.[Year 6 Maths Mock],
dbo.PGJSProfile.[Year 6 English Mock Year Group Average], dbo.PGJSProfile.[Year 6 Maths Mock Year Group Average]
FROM
dbo.PGJSProfile LEFT OUTER JOIN
dbo.StudentDetMaster ON dbo.PGJSProfile.SetId = dbo.StudentDetMaster.SetId AND
dbo.PGJSProfile.StudentId = dbo.StudentDetMaster.StudentId
ORDER BY dbo.StudentDetMaster.Name
cheers
greg
View 11 Replies
View Related
Jul 20, 2005
sql server 2000 8.00.194Microsoft Windows 2000 Service Pack 2I looked into my sqlserver agent log and found the followingODBC Error 0 Timeout expired[SQLSTATE HYT00]logon to server local '( failed)' (Job manager)I have no idea what that means but it did keep out users for a minute or more.The threads found on this forum almost all point to reccuring situationsmine is a sporadic one time issue.Is it Ok to conclude it is a network error as I did?TIAVince
View 1 Replies
View Related
Sep 12, 2001
Receiving error "Microsoft ODBC Server Driver Timeout Expired".
This is happening when running queries or stored procedures through VB6 and also in Enterprise Manager.
Have set query timeout to 0 and command timeout to 0 but no joy.
Enterprise manager cannot even perform a count of records (16Million) without timeing out.
Can anyone help...at end of tether!
Cheers,
Brookesy
View 1 Replies
View Related
Jul 3, 2007
Hi,
I am running a stored procedure that collects some records from two tables do some calculations with those records and insert those calculation result in a temp. table. I am calling this stored procedure in my aspx page and then later select all the records from temp table and show it in a table.
When I run this application on browser it give me Timeout expired error but whn I execute the stored procedure it runs properly but takes around 3:10 mins to execute in query analyzer. I did some google work and based on that I specified CommandTimeout = 300 for SP and Connection timeout=400 in web.config. But still it didnt worked. Sometimes it runs properly but sometimes its not.
Where I am doing mistake? and Wht should i do to resolve this? Plz. help.
Thanks in adv.
Regards,
Yogita
View 1 Replies
View Related
Dec 26, 2007
Guys,
I am trying to attach a database object to the App_Data directory I got thie error
Error: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
This is what I did. I right click the App_Data folder and click Add New Item. Then I click the SQL Database. This is where I got the error.
What should I do? Please help
View 2 Replies
View Related
Nov 10, 2006
Hi,I
get this error from our web application every once in a while. " Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding". I email
myself when an error occurs, and once every 2-3 days I get this timeout
error emails, like 5-10 emails in a span of few minutes. Then it goes
away. I have set the command timeout for 60 secs.
It
doesn't happen from the same stored procedure, actually I have seen it
timeout from really simple 1 or 2 line stored procedures, which shouldn't normally take 1 sec. Its like
sql server just shuts down for few minutes. We have some
backups and maintenance jobs scheduled, but they run only after
midnight. I have checked the
application event viewer, there are no warnings or
error messages for MSSQLSERVER. Can
any one tell me how to check whats going on during that short timespan
when timeout error occurs, and what causes it? I don't want to run sql
profiler continuously for 2-3 days, I am afraid it will slow down the
server more. Thanks.
View 3 Replies
View Related
Oct 28, 2004
Hi,
Please help share with me if you know the version compatibility matrix of Ms SQL Server, ODBC driver (sqlsrv32.dll), Driver Manager (odbc32.dll) and ODBC API spec. For instance, how can I know Ms SQL Server 2000 can work with which version of sqlsrv32.dll, a particular version of sqlsrv32.dll can work with which version of odbc32.dll and a certain version of sqlsrv32.dll/odbc32.dll conforms to which version of ODBC API spec (e.g. 3.5).
Any help will be appreciated.
Thanks,
vtluu.
View 1 Replies
View Related
Sep 2, 2006
I have an Update stored procedure that is used to update four tables at the same time. The issue is that it works perfect when i run the application in local server,but when i upload the application on to the server that is located in U.S, it gives an error "System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed
prior to completion of the operation or the server is not responding. " I think the sqlCommand is timing out and the value is not returned. Is there a workaround to this issue? What could be the reason for this? Any ideas.. Please help..
View 5 Replies
View Related
Feb 15, 2008
Hi:
Just purchased a web application, sometime it will cause the timeout error, that will cause the web page can't be opened, and popup an error page."Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding."
The function is below:public static ProfileAnswer[] FetchNonApproved()
{
using (SqlConnection conn = Config.DB.Open())
{
SqlDataReader reader = SqlHelper.ExecuteReader(conn,"FetchNonApprovedAnswers"); //this is the line where the timeout error occurs.
List lAnswers = new List();
while (reader.Read())
{
//do something here
lAnswers.Add(answer);
}
return lAnswers.ToArray();
}
}
Is there anyway to jump out of the error if the timeout occurs, abort the further action, and back to current page. (what is the problem with the code?)
Thanks a lot.
Jt
View 1 Replies
View Related
Oct 11, 2004
Hi;
I am getting this error sometimes what can I do for this
Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
thank you...
View 2 Replies
View Related
Apr 14, 2006
My application always face timeout expired error (as following) whenever i first run the application. But it can run well for second time.
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
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.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Is there any suggestion or advice for me about this problem? Thank You.
View 2 Replies
View Related
Aug 10, 1999
Can anyone please help me... I'm getting the following error and the database
I'm dealing with only has about 10 records in it.....
-----Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver]Timeout expired
Any help would be greatly appreciated. I'm running SQL 7.0
Thank you,
T. Teal
View 1 Replies
View Related
Oct 9, 2006
I am getting problem from one of my client that is..
connection Failed: SQLstate: 'HYT00' Sql Server Error: 0 [Microsoft] [ODBC Sql Server Driver]TimeOut expired.
How to solve it please solve....
View 3 Replies
View Related
Jul 20, 2005
Hello:I have an application (using ADO 2.7 - written in VB) that access a SQLServer 2000 Database.Every once in a while, the program hangs when I am accessing the DB, andsometimes I get a timeout expired error. The wierd thing is, when it hangs,if you try the function again - it goes throught every timeFor example, If I call a function that retrieves a password from a table inthe DB, it will hang (sometimes it hangs for a few seconds and then goesthrought, sometimes it will timeout and gives me the timeout expired error).If I then call the same function immediately after, there will be no delay.I am stumped on this, any help would be appreciated. I have tried shrinkingthe DB and Backing it up to no avail.Regards,Ryan Kennedy
View 1 Replies
View Related
Apr 14, 2004
I am getting error
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
StackTrace> at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) at Galileo.Modules.Data.DBDeclare.RunProcedure(String sp, IDataParameter[] parameters) at GalileoModules.Data.PrivateAccomodation.Search3.Query(String[] values
If I don't cache this page, would that help?
Any other suggestions?
View 3 Replies
View Related
Jan 22, 2001
Hello,
I am using a VB script active task object in a DTS package
to connect to one of my databases using an OLE DB connection.
I send an SQL string executing stored procedures, and depending
on the size of the procedures I get a "Timeout Expired" error
on execution of the DTS package. I have trimmed and tuned the
stored procedures to be much smaller and faster, but still
haven't beaten the timeout. How do i avoid, switch off, or
lengthen the timeout period?
Thanks, Joshua
PS, alternately, how might I modify the parameters of and execute
DTS packages from stored procedures?
View 1 Replies
View Related
Jan 29, 2008
i am using sql server 2000. and have a DTS with script in it. now the script if failing saying timeout expired.
The script has db connection and calls stored procedure to fetch data. The records are around 63K but its failing due to timeout expired.
is there a way to increase the timeout in script. i dont want to do any changes to sql server settings.
View 4 Replies
View Related
May 5, 2003
Hi everybody,
I do custom log shipping over network like
step 1 backup log to C:..
step 2 zip log file c:... zip
step 3 copy zip to \sm01
estorelogs...
step 4 unzip file
step 5 restore log with stand by
Few times a month it fails with
Error = -2147467259 (80004005) Error string: Timeout expired Error source: Microsoft OLE DB Provider for SQL Server Help file: Help context: 0 Error Detail Records: Error: -2147467259 (80004005); Provider Error: 0 (0) Error string: Timeout expired Error source: Microsoft OLE DB Provider for SQL Server
Any idea ,what might cause it ?
Thank you
Alex
View 3 Replies
View Related
