general odbc error excel 2010 Whiteside Tennessee

Computer And Laptop Repair , Computer and Laptop Parts, Computer and Laptop Sales. Chattanooga Computer And Laptop Service And Parts.

Address 4738 Highway 58, Chattanooga, TN 37416
Phone (423) 508-8122
Website Link

general odbc error excel 2010 Whiteside, Tennessee

Show that a nonabelian group must have at least five distinct elements Modulo % with big number- Infinity error - Javascript Is there a Korean word for 'Syllable Block'? I am a VBA noob and have no idea why it isn't working. As I understand it the ports tend to be standard, but I couldn't figure out how to check the settings on this server. The real strange thing is why it does not work on my machine, but on the guys next to me it does?

This is the error we have got: Run-Time Error 1004, General ODBC error. TIA Vaya con Dios, Chuck, CABGx3 CLR, Nov 7, 2008 #1 Advertisements Joel Guest It would help to know which line of code is failing. This was due to the fact that MS Query saves not only the Datasource Name for the ODBC connection that you used to build the query, but also the driver location Vaya con Dios, Chuck, CABGx3 "Joel" wrote: > It would help to know which line of code is failing.

You may want to make some attempt to refresh the table manually to see if that functions properly. Any help offered is appreciated, I'm out of ideas. Register Lost Password? After Microsoft Excel makes a successful connection, it stores the completed connection string so that prompts won't be displayed for subsequent calls to the Refresh method during the same editing session.

The Excel file has multiple macros. The difference is that on 64 bit systems, all the library files and drivers in the "%SystemRoot%\system32\" directory are 64 bit. Reply With Quote Jan 4th, 2011,03:11 PM #4 Baconator View Profile View Forum Posts Thread Starter New Member Join Date Nov 2010 Posts 4 Re: General ODBC error Oh brother! Why doesn't ${@:-1} return the last element of [email protected]?

Can Communism become a stable economic strategy? One thing to > >> > check is > >> > the error option in BA. arrays: A string is just text encased in quotes, "hello there". Forum Board FAQ Forum Rules Guidelines for Forum Use FAQ Forum Actions Mark Forums Read Quick Links Today's Posts Search New Posts Zero Reply Posts Subscribed Threads MrExcel Consulting Advanced Search

Hopefully this will at least help someone else with the same error as my search turned up very little. When I step through the code, it fails at the Refresh line and throws a run time error '1004' - General ODBC error (very descriptive, I know). I used SET NOCOUNT ON; It worked! The bit about strings vs.

About Us PC Review is a computing review website with helpful tech support forums staffed by PC experts. Implementation of a generic List Radius of Convergence of Infinite Series Meaning of "oh freak" Physically locating the server Is there any way to know when NOT to use my Oyster The Refresh method causes Microsoft Excel to connect to the data source of the QueryTable object, execute the SQL query, and return data to the range that is based on the RE: Run-time error '1004' General ODBC Error Imakeoil (Programmer) (OP) 9 Sep 10 14:50 No go.

Join them; it only takes a minute: Sign up Excel 2010: Run time error 1004 general odbc error up vote 0 down vote favorite I have a small Excel 2010 query Just click the sign up button to choose a username and then you can ask your own questions on the forum. Thanks Minh Monday, June 02, 2014 10:10 AM Reply | Quote 0 Sign in to vote I'm hitting this same issue and you're post is the first one I've found experiencing go to VBA menu Tools - Options - General - Error > > Trapping. > > > > "CLR" wrote: > > > > > Hi All......... > > > I

Sign Up Now! Member Login Remember Me Forgot your password? All contents Copyright 1998-2016 by MrExcel Consulting. You will see your connection string and SQL.

Apparently the date needs to be 'yyyy-mm-dd' even though the Microsoft Query editor show it as 'm-d'. The program works fine on my computer, but when my user tries to run > it on his computer, (same versoion of Excel, 2000), he gets the following > error. > One thing to check is > the error option in BA. You can obtain the completed connection string by examining the value of the Connection property.

Could it have to do with the @start date being set both in the stored procedure and in the =exec sp_name line?Thanks so much for your help. Reply With Quote Jan 4th, 2011,03:58 PM #5 RobDog888 View Profile View Forum Posts Visit Homepage Super Moderator Join Date Apr 2001 Location LA, Calif. Am I doing that in the following place? Members List Calendar Forum Rules Dashboard Commercial Services Advanced Search Forum Microsoft Office Application Help - Excel Help forum Excel General Excel - New Users/Basics Runtime error '1004' General ODBC error

One thing to > >> > check is > >> > the error option in BA. J.A Coutts Faq July 22nd, 2013,05:18 PM #3 No Profile Picture anziga View Profile View Forum Posts  Contributing User Devshed Newbie (0 - 499 posts)     Faq July 23rd, 2013,10:31 AM #5 No Profile Picture eljefe_cendigit View Profile View Forum Posts  Registered User Devshed Newbie (0 - 499 posts)  Facebook Google + Join Date If anything is unclear or if there is anything I can do for you, please feel free to let me know.

Last edited by anziga; July 22nd, 2013 at 06:56 PM. Powered by vBulletin® Version 4.1.8 Copyright © 2012 vBulletin Solutions, Inc. I can't seem to find the correct place to make a connection to the driver, do I need to put the full path in my code? After the database connection is made, the SQL query is validated.

Here's Why Members Love Tek-Tips Forums: Talk To Other Members Notification Of Responses To Questions Favorite Forums One Click Access Keyword Search Of All Posts, And More... All times are GMT -5. go to VBA menu Tools - Options - General - Error >> Trapping. >> >> "CLR" wrote: >>> On Friday, November 07, 2008 10:36 AM CL wrote: >>> Hi Joel........ >>> This still throws a '1004' error.Could it be the port?

Also, can you try it on any other PCs? What is missing from it? Sub Refresh_all() Application.ScreenUpdating = False Application.Goto Reference:="querycell" Range("A2").Select Selection.QueryTable.Refresh BackgroundQuery:=False Dim pt As PivotTable Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets For Each pt In ws.PivotTables pt.RefreshTable Next pt Jan 31 '08 #4 reply Expert 5K+ P: 8,435 Killer42 Just on the date theme, it might be worth checking whether both PCs have the same settings for date format.

Not sure why. I am wondering if it is a setting on my actual computer? Post your question and get tips & solutions from a community of 418,553 IT Pros & Developers. Strings?

The time now is 11:22 PM. Close this window and log in.