asked on

Timeout Error

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.

ASKER CERTIFIED SOLUTION

WebWanderer

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Naser

ASKER

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,,

SOLUTION

David Todd

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

avbsql

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

CleanupPing

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.