Smart questions
Smart answers
Smart people
Join Tek-Tips Forums
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • 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!

Join Tek-Tips
*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.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

How can I resolve "Runtime Error 3146 ODBC Call Fail

btturner (Programmer) (OP)
23 Jan 02 12:44
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)
Guest (Visitor)
8 Mar 02 4:38
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
tlbroadbent (MIS)
8 Mar 02 16:00

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.

http://www.sqldts.com/article.asp?nav=1,6,208,7

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.

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!

Back To Forum

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