URGENT ! database processing timeout

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.
 
K

Kevin Eller

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.
 
K

Kevin Eller

Oh. If you need help I need to know how much is the size in KB or MB for
your Transfer File.
 
G

Guest

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.
 
S

Sue Harsevoort

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Timeout from access to SQL server connection 1
URGENT: database processing error 2
URGENT:Error and timeout 2
Data Access Page timeout problem 1
Access Timeout 5
Reconnecting after ODBC timeout 3
[Microsoft][ODBC SQL Server Driver] Timeout expired 4
Does Microsoft recommend databases or projects to connect to SQL s 1

Top