Solved

Timeout Error

Posted on 2002-03-20
5
230 Views
Last Modified: 2011-09-20
Hello All...

can you please help me in the following  problem:

I have MS ACCESS DB that have a linked table to SQL Server, when I try to insert records from the ACCESS DB table into the SQL Server linked table,I get the following error:
ODBC-insert on a linked table 'Table Name' failed
[Microsoft][ODBC SQL Server Driver] timeout expires(#0).

FYI :
I'm using SQL SERVER 2000 ,MS ACCESS 2000, the linked table(sql server side) has more than 30,000,000 records.
0
Comment
Question by:Naser
5 Comments
 

Accepted Solution

by:
WebWanderer earned 50 total points
Comment Utility
Have you considered changing the OLE timeout options? I have access 97 - it's under Tools, Options, Advanced - the OLE/DDE Timeout setting.

That should help, but I think that you will just be delaying your problem. You need to determine why the timeout has occured. Check to ensure that you are not having locking issues (all though it seems unlikely, since with a 30M plus table, it's unlikely to be table locked ...

Look at the number of rows that you are looking to insert... see if you can reduce the size of rows to be inserted in a single connection.

HTH
0
 

Author Comment

by:Naser
Comment Utility
webwnderer ,,,thanx for ur help, but I have increase the OLE/DDE Timeout setting to 150 ,also I have reduce number of records to be inserted(1000 rec. at a time) , but still having the same problem,,
0
 
LVL 35

Assisted Solution

by:David Todd
David Todd earned 50 total points
Comment Utility
Hi Naser,

Two things:
1. From your comment above you have declined or rejected the answer from WebWanderer. Can you formally reject the answer as many experts don't visit locked questions.

2. What is the severs performance like? Have you run a dbcc on the clustered index of all tables, along with an update statistics? This can be done via a maintenance plan or I can give you the SQL to do this ... Do you have indexes with correct fill-factors on these tables?

Q) Did this just sart doing this, ie the databse grew to x number of records and performance dropped off, or are you creating an access application which links to an existing system?

WebWanderer: Answers are more commonly proposed as comments ...

Regards
  David
0
 
LVL 3

Assisted Solution

by:avbsql
avbsql earned 50 total points
Comment Utility
Are the table structure same as in Access and SQL. try to relink the tables after you have changed the option of timeout.
0
 

Expert Comment

by:CleanupPing
Comment Utility
Naser:
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1
EXPERTS:
Post your closing recommendations!  No comment means you don't care.
0

Featured Post

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Need Counts 11 40
sql query 7 34
Server 2008 Cluster Fail-over Errors 5 40
Increasing Identity length in sql server 4 15
Introduced in Microsoft SQL Server 2005, the Copy Database Wizard (http://msdn.microsoft.com/en-us/library/ms188664.aspx) is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now