Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to get rid of runtime error 3146 ODBC

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 29-08-2009
Member
 
Join Date: Dec 2008
Posts: 87
How to get rid of runtime error 3146 ODBC
  

I'm getting this error Run-Time error 3146 ODBC - Call failed when i try to make connection to the database using the SQL queries, I am using SQL 2000 and Access 97, I am getting this error while SELECTING, UPDATING and INSERTING record, but gives me a "Run-time error 3146 ODBC--call failed" on the second one from rs1. Both rs and rs1 are queries. The documentation for this error is quite limited, anyone can help? I need solutions?

Reply With Quote
  #2  
Old 29-08-2009
Member
 
Join Date: Jan 2009
Posts: 143
Re: How to get rid of runtime error 3146 ODBC

Is the ODBC-Data source configured as System-Datasource? (The Systemdatasource tab when configuring the datasource) As the open connections accumulate, new connections are not possible, when the maximum (in mysql.ini file) is reached. it is known that DAO can appear to have blocked ODBC connection until QueryTimeout property of the database object (default = 60 seconds) expires.
Reply With Quote
  #3  
Old 29-08-2009
Member
 
Join Date: Feb 2009
Posts: 105
Re: How to get rid of runtime error 3146 ODBC

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. I do not see how making the connection a "System-Datasource" is going to change anything other than the user accounts that can access it. I do not need multiple accounts accessing the data source. I just need it to ask for a password. The default timeout is 300 minutes which is exactly 5 minutes.
Reply With Quote
  #4  
Old 29-08-2009
Member
 
Join Date: Mar 2008
Posts: 192
Re: How to get rid of runtime error 3146 ODBC

Other reasons for having runtime errors include the incorrect loading, Once again, these can all be the source of missing or broken links in your windows registry, 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. thus it causes your windows to pop up these troublesome error alerts, or even worse problems.unloading of software, problems which may appear when you have a large number of applications on your computer, viruses and spyware, and so forth.
Reply With Quote
  #5  
Old 01-04-2011
Member
 
Join Date: Apr 2011
Posts: 1
Re: How to get rid of runtime error 3146 ODBC

In my case, I had some bad data.
The user had entered a single digit in a number field where my SQL was looking for two digists. I was requiring two digits but the user entered a space as the first digit...<sigh> My bust.
In my case the Front end was Access 2003 and the backend was MySQL. Hope this helps someone in the future
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to get rid of runtime error 3146 ODBC"
Thread Thread Starter Forum Replies Last Post
Using Internet Explorer gives Microsoft Visual C++ Runtime Library Runtime Error Abejar Windows Software 3 22-04-2009 11:02 PM
Microsoft Visual C++ Runtime Library... Runtime Error Joko Software Development 2 17-02-2009 08:52 PM
Microsoft Visual C++ Runtime Library Symantec Runtime error Ranchero Windows XP Support 8 27-09-2008 09:08 AM
Microsoft Visual C++ Runtime Library - Runtime Error Leythos Windows XP Support 3 01-10-2007 11:45 PM
HELP!!! Microsoft Visual C++ Runtime Library - Runtime Error Jay Windows XP Support 6 14-11-2006 02:37 PM


All times are GMT +5.5. The time now is 06:25 PM.