general odbc error excel West Millgrove Ohio

Address Holland, OH 43528
Phone (419) 344-3980
Website Link
Hours

general odbc error excel West Millgrove, Ohio

Just click the sign up button to choose a username and then you can ask your own questions on the forum. One thing to >> > check is >> > the error option in BA. RE: Run-time error '1004' General ODBC Error Imakeoil (Programmer) (OP) 9 Sep 10 14:22 Here is the SQL. Is this a problem with something else?

I would > remove some unecessary line in the command until you get it to work. > First > try on the working computer to eliminate as many unecessary items as If the query isn't valid, the Refresh method fails with the SQL Syntax Error exception. You may also re-connect the Excel file with the SQL server database. These are the codes highlighted in color when I debug the macro back on July.

RE: Run-time error '1004' General ODBC Error Imakeoil (Programmer) (OP) 9 Sep 10 18:11 I am not sure what you mean by 'You did not return the entire string.' I even share|improve this answer answered Jul 2 '15 at 13:09 pkk 1 Could you please elaborate on where this should go and what it does? –SuperBiasedMan Jul 2 '15 at RE: Run-time error '1004' General ODBC Error Imakeoil (Programmer) (OP) 9 Sep 10 14:50 No go. I always edit recorded macros eliminating the unecessary items and replace SELECTION with absolute cell references. "CLR" wrote: > Hi Joel......... > Well, you saved the day, or week, or several

Advanced Search VBForums Visual Basic Office Development MsOf03 [RESOLVED] General ODBC error If this is your first visit, be sure to check out the FAQ by clicking the link above. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote « Previous Thread | Next Thread » Like this thread? If the specified connection string is missing required values, dialog boxes will be displayed to prompt the user for the required information. thanks for the reply, btw, I'm going to do that right now.

Not the answer you're looking for? Jan 31 '08 #3 reply Expert 100+ P: 1,295 kadghar I think the error comes from the Connection. Sub Uppdatera_order_stock() ' ' Uppdatera_order_stock Macro ' Macro recorded 2001-02-28 by X ' ' Application.ScreenUpdating = False Sheets("Data_order").Select Range("A2").Select Selection.QueryTable.Refresh BackgroundQuery:=False Range("r2:u2").Select Selection.AutoFill Destination:=Range("r2:u2000"), Type:=xlFillDefault All contents Copyright 1998-2016 by MrExcel Consulting.

Facts: I'm running Windows 7 Professional (64bit) Excel 2010 (reverted back to 32bit because of a plugin issue) I have both Oracle 11g 32bit and 64bit client on my pc. Powered by vBulletin® Version 4.1.8 Copyright © 2012 vBulletin Solutions, Inc. What happens if one brings more than 10,000 USD with them in the US? 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

What do I do when two squares are equally valid? I reopened the query from the cell and I did get results back after closing the MSQuery box. With the debugger still pointing to the .Refresh BackgroundQuery line. Not the answer you're looking for?

Please take your time to try the suggestions and let me know the results at your earliest convenience. 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 But now, my boss is not able to run the Macro either. Make all the statements true Why is water evaporated from the ocean not salty?

Join UsClose Dev Shed Forums Navigation Forums Tools Newsletter Signup Articles Help Devshed Network Developer Shed ASP Free Dev Shed Dev Articles Dev Hardware Tutorialized SEO Chat Scripts Codewalkers Web Hosters Yes, my password is: Forgot your password? When you run 32 bit software, you are automatically directed to the "%SystemRoot%\syswow64\" directory. Convert mp4 to mp3 Using Shell Script Make all the statements true Is it illegal for regular US citizens to possess or read documents published by Wikileaks?

more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed How should I interpret "English is poor" review when I used a language check service before submission? When I right click and try to refresh, excel prompts me for Server. I am passing SQL code to run in the database, and I have tested the SQL code in Access and the query runs fine.

With modern technology, is it possible to permanently stay in sunlight, without going into space? By default, when you access the ODBC manager, you are using the 64 bit manager. With ActiveSheet.QueryTables.Add(Connection:=Array(Array( _ "ODBC;DSN=MS Access Database;DBQ=" & NewFile & ";DefaultDir= " _ ), Array( _ ";DriverId=281;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;" _ )), Destination:=Range("A1")) .CommandText = Array( _ "SELECT `NPR Database`.`Disposition Date`, `NPR Database`.`Inspection Date`, Data > From Other Sources > From Data Connection Wizard?

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 > then put these changes in the > non-working PC. > > Here are things that I think are un-needed > > 1) DefaultDir= > 2) DriverId=281 > > Also make sure Also, can you try it on any other PCs? Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free.

asked 3 years ago viewed 19820 times active 1 year ago Linked 0 QueryTables.Add application error Related 0excel vba run-time error 1004 - not clear why1Run-time error 1004 when copy/pasting cells Run-time error '3011' in select statement in access2002 Browse more Visual Basic 4 / 5 / 6 Questions on Bytes Question stats viewed: 2879 replies: 5 date asked: Jan 31 '08 Hello. I am stumped.

I ran some tests and adding those two characters fixed it all. Hopefully this will at least help someone else with the same error as my search turned up very little. It seems to be a conversion issue between what it takes successfully in the CommandText line and what MS Query shows and uses. cov(x,y)=0 but corr(x,y)=1 Is it plausible for my creature to have similar IQ as humans?

To use the 32 bit manager, you must specifically run %SystemRoot%\syswow64\odbcad32.exe. Powered by vBulletin Version 4.2.3 Copyright © 2016 vBulletin Solutions, Inc. 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