URGENT: database processing error

  • Thread starter Thread starter thri
  • Start date Start date
T

thri

I have posted this on the general discussion group before
I found this one.
I am using ACCESS 2000 and a back end SQL server 2000
database. I am trying to transfer a file that has about
300,000 + records to SQL server and then process it using
a stored procedure before I exit out of the Access
program. Now the TransferDatabase command goes through
fine but while it is processing this data after the
transfer I get this error message from Access :

run-time error '-2147217871 (80040e31)':
[Microsoft][ODBC SQL Server Driver][SQL Server] Timeout
Expired

I would appreciate any help.
 
I am using the ADO EXecute command to start the stored
procedure as below.

cmd.Execute , , ADODB.adExecuteNoRecords

is there anything I can do about it ?
-----Original Message-----
Sounds like it is timing out.

How are you firing off the stored procedure?



I have posted this on the general discussion group before
I found this one.
I am using ACCESS 2000 and a back end SQL server 2000
database. I am trying to transfer a file that has about
300,000 + records to SQL server and then process it using
a stored procedure before I exit out of the Access
program. Now the TransferDatabase command goes through
fine but while it is processing this data after the
transfer I get this error message from Access :

run-time error '-2147217871 (80040e31)':
[Microsoft][ODBC SQL Server Driver][SQL Server] Timeout
Expired

I would appreciate any help.
Click to expand...


.
Click to expand...
 
Back
Top