URGENT ! database processing timeout

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

thri

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.
 
Hello! I just signed up for this Newsgroup Account. I'm kind of a Computer
Expert for Windows XP. If you need any help reply this message.
 
Oh. If you need help I need to know how much is the size in KB or MB for
your Transfer File.
 
how do I find out the size of this table of data. there
are many such tables in this database but only one is
trasferred.
 
Hore are you running the stored procedure, in code or through a passthrough
query? You will need to make the time out value higher. How you do it
depends on how you are running the stored procedure.

Sue
 
Back
Top