Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


How can I resolve "Runtime Error 3146 ODBC Call Fail

How can I resolve "Runtime Error 3146 ODBC Call Fail

How can I resolve "Runtime Error 3146 ODBC Call Fail

QUESTION:  How do I modify ODBC driver configuration???

--> After exactly "5" minutes, I am receiving this error msg on my ACCESS screen: RUNTIME ERROR 3146 ODBC CALL FAILED

Process includes:
--> I'm invoking a SQL 2K stored procedure REMOTELY from an ACCESS command button

--> I connect OK to the remote server & the SP runs to successful completion (SP runs for approx 30 minutes)

(fyi, the SQL SP invokes xp_cmdshell, then runs DTSRUN api successfully)

RE: How can I resolve "Runtime Error 3146 ODBC Call Fail

is it possible, that this runtime-error occures if I am not able to write to the database (no write-rights)? Could that be?
txs bart3

RE: How can I resolve "Runtime Error 3146 ODBC Call Fail

3146 is a generic failure to connect message. You really need to examine the complete error message in order to know the cause. It is likely that the problem is caused by a remote timeout on the server. The default timeout is 300 minutes which is exactly 5 minutes.

Excuting a stored proc to execute a package via xp_cmdshell and DTSRUN seems like a complex way to perform this. Why not executing the package from VBA in Access? See the article at SQLDTS.com for instructions and samples of executing packages from VB.


Terry L. Broadbent - DBA
Computing Links: http://tlbroadbent.home.attbi.com/prog.htm
FAQ183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close