Results 1 to 5 of 5

Thread: How to get rid of runtime error 3146 ODBC

  1. #1
    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?

  2. #2
    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.

  3. #3
    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.

  4. #4
    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.

  5. #5
    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

Similar Threads

  1. Replies: 3
    Last Post: 22-04-2009, 11:02 PM
  2. Microsoft Visual C++ Runtime Library... Runtime Error
    By Joko in forum Software Development
    Replies: 2
    Last Post: 17-02-2009, 09:52 PM
  3. Microsoft Visual C++ Runtime Library Symantec Runtime error
    By Ranchero in forum Windows XP Support
    Replies: 8
    Last Post: 27-09-2008, 09:08 AM
  4. Microsoft Visual C++ Runtime Library - Runtime Error
    By Leythos in forum Windows XP Support
    Replies: 3
    Last Post: 01-10-2007, 11:45 PM
  5. Replies: 6
    Last Post: 14-11-2006, 03:37 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,650,599.18480 seconds with 17 queries