Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Runtime Error 3146 ODBC Call Failed

Status
Not open for further replies.
btturner

btturner

Programmer
Joined
May 17, 2001
Messages
175
Location
US
How can I resolve an ambiguous msg: "Runtime Error 3146 ODBC Call Failed"

--> 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)

--> Unfortanately, after "5" minutes, I am receiving this error msg on my ACCESS screen

(fyi, the SQL SP invokes xp_cmdshell, then runs DTSRUN api successfully
 
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question Question
Error in Select query
Replies
14
Views
1K
Andrzejek
Andrzejek
Virendra Yaduvanshi
  • Locked
  • Question Question
SSRS - Subscription page error
Replies
0
Views
545
Virendra Yaduvanshi
Virendra Yaduvanshi
kingz2000
  • Locked
  • Question Question
connection - runtime error (Excel to SQL-Sever)
Replies
2
Views
428
kingz2000
kingz2000
new_to_sql
  • Locked
  • Question Question
Access SQL Query Error
Replies
5
Views
558
dhookom
dhookom
G12Consult
  • Locked
  • Question Question
Geography data type error
Replies
3
Views
450
G12Consult
G12Consult

Part and Inventory Search

Sponsor

Back
Top