general odbc error querytable.refresh Westerville Ohio

Address 897 High St, Worthington, OH 43085
Phone (614) 437-8412
Website Link
Hours

general odbc error querytable.refresh Westerville, Ohio

Advertisements Latest Threads Is my Netgear router suitable for fibre optic broadband? When i click on the shortcut, I get an error pop up: Run time error 1004' General ODBC error. I used SET NOCOUNT ON; It worked! If the specified connection string is missing required values, dialog boxes will be displayed to prompt the user for the required information.

The program works fine on my computer, but when my user > >> > > tries to run > >> > > it on his computer, (same versoion of Excel, 2000), Kindly help. asked 1 year ago viewed 2317 times active 1 year ago Related 2Excel VBA 2010 - Command buttons stop working with multiple sheets selected0Excel 2010 Run-Time error '91'1Run time error 1004 Is there any job that can't be automated?

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. The time now is 11:14 PM. I've googled the error and it seems to mention an awful lot that there could be a problem with the link but I'm very inexperienced with Access and not quite sure Friday, July 08, 2016 8:56 AM Reply | Quote Microsoft is conducting an online survey to understand your opinion of the Technet Web site.

Thanks to those that responded. Join them; it only takes a minute: Sign up Refresh QueryTable throwing “General ODBC error” - VBA Excel 2011 for Mac up vote 6 down vote favorite EDIT: New mistake found? Also check that the network connection...if the file is found over a network.. We're a friendly computing community, bustling with knowledgeable members to help solve your tech questions.

I always edit recorded macros eliminating >>>>>> the unecessary items and replace SELECTION with absolute cell references. >>>>>> >>>>>> "CLR" wrote: >>>>>> Submitted via EggHeadCafe - Software Developer Portal of Choice I have copied the excel sheet from a working copy and am trying to point it at a different server. But why does it work on his and not mine? Your name or email address: Do you already have an account?

Not sure why. Why would a password requirement prohibit a number in the last character? Appease Your Google Overlords: Draw the "G" Logo How much interest should I pay on a loan from a friend? If the DisplayAlerts property is False, dialog boxes aren't displayed and the Refresh method fails with the Insufficient Connection Information exception.

If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.Would you like to participate? asked 3 years ago viewed 19820 times active 1 year ago Visit Chat Linked 0 QueryTables.Add application error Related 0excel vba run-time error 1004 - not clear why1Run-time error 1004 when tables.SELECT #event_data.truck, hours, tkm, vol FROM #event_dataINNER JOIN #cycle_data ON #cycle_data.truck = #event_data.truckORDER BY #event_data.truckDROP TABLE #event_dataDROP TABLE #cycle_dataWhen I typed ?Array(reportdate)into the immediate window it gave me a type mismatch All rights reserved.Unauthorized reproduction or linking forbidden without expressed written permission.

The refresh commands prior to that one seem to work (different worksheets). Close this window and log in. Are there any rules or guidelines about designing a flag? You may also re-connect the Excel file with the SQL server database.

How to use the binomial theorem to calculate binomials with a negative exponent Why must the speed of light be the universal speed limit for all the fundamental forces of nature? Not the answer you're looking for? COde:: Sub Macro1() ' ' Macro1 Macro ' Macro recorded 10/07/2013 by wadhwra ' ' With ActiveSheet.QueryTables.Add(Connection:=Array(Array( _ "ODBC;DSN=MS Access Database;DBQ=I:\Sharepoint MIS\Misc\New Microsoft Office Access Application (2).mdb;DefaultDir=I:\Sharepoint MIS\" _ ), Array("Misc;DriverId=25;FIL=MS no problem.

Apparently the date needs to be 'yyyy-mm-dd' even though the Microsoft Query editor show it as 'm-d'. Sign Up Now! Unproven vs. Are the words "expression" and "term" interchangeable in programming language theory?

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. RE: Run-time error '1004' General ODBC Error SkipVought (Programmer) 9 Sep 10 16:05 Here is the returned stringODBC;DSN=dsn201;Description=JPdb;UID=minedata;PWD=1xx$F;APP=Microsoft® Query;WSID=CAL-L-97076;DATABASE=PowerYou did NOT return the entire string.Get rid of the Array() functions also! Also check that the network connection...if the file is found over a network.. Sheets("DataQuery").Selectreportdate = ActiveSheet.Range("B1").ValueRange("A3").SelectWith Selection.QueryTable.Connection = Array(Array( _"ODBC;DSN=DSN201 ;Description=JPdb;UID=minedata;PWD=1xx$F;APP=Microsoft® Query;DATABASE=Power;Network=" _), Array("DBMSSOCN;Address=111.11.221.70,1433")).Sql = Array(reportdate).Refresh BackgroundQuery:=FalseEnd WithI have not had any luck googling the '1004' error, it seems that it could be many

All rights reserved.Newsletter|Contact Us|Privacy Statement|Terms of Use|Trademarks|Site Feedback TechNet Products IT Resources Downloads Training Support Products Windows Windows Server System Center Browser   Office Office 365 Exchange Server   SQL Server One thing to check is > > the error option in BA. Skip,Just traded in my old subtlety...for a NUANCE! How exactly does the typical shell "fork bomb" calls itself twice?

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. > Run Time Error '1004' General ODBC Error Obviously some difference between the two machines, but who knows what to do to fix it? go to VBA menu Tools - Options - General - Error > > Trapping. > > > > "CLR" wrote: > > > > > Hi All......... > > > I Also, a refresh will fail there if there's an access issue. –Liss Feb 3 at 21:05 This may or may not help, but I notice that strConn = "ODBC;DSN=KundeDB;"

If I enter the code "Excel.ODBCConnection.Refresh" it throws the error "Method or Data Member not found" highlighting only the word "ODBCConnection". Similar topics Copying Worksheet to another Workbook - ERROR ODBC Connection Error read/write excel using odbc ODBC has error but no error message displayed Excel Automation Getting Excel worksheet names with but you never know =P. LinkBack LinkBack URL About LinkBacks Bookmark & Share Digg this Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable Version Display Linear Mode Switch to Hybrid Mode