ccirn.org

Home > General Odbc > Error Number 1004 General Odbc Error

Error Number 1004 General Odbc Error

Contents

Thanks for the help Daniel. When run on the server it doens't throw any errors.ALTER PROCEDURE [dbo].[jpm_tiretrack] (@endd int) AS--Altered to report all trucks11-25-09 /*DECLARE @sDate datetime, @eDate datetime, @startd int, @endd intSET @sDate = '2010-01-01'SET 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 Dev Mechanic I have an ODBC with read-only privileges and I recorded part of the code from the macro.

Can anyone help, or point me in the direction of some good resources for setting the connection?Thanks RE: Run-time error '1004' General ODBC Error SkipVought (Programmer) 9 Sep 10 12:58 This You'll be able to ask any tech support questions, or chat with the community and help others. What's a word for helpful knowledge you should have, but don't? You may want to make some attempt to refresh the table manually to see if that functions properly. http://stackoverflow.com/questions/16151560/excel-2007-1004-run-time-error-refresh-query-table

Run Time Error 1004 General Odbc Error

Not the answer you're looking for? Jan 31 '08 #1 Post Reply Share this Question 5 Replies 100+ P: 491 daniel aristidou Since he said it might be date...which is possible have you checked you computer date asked 1 year ago viewed 1471 times active 1 year ago Get the weekly newsletter! By default, when you access the ODBC manager, you are using the 64 bit manager.

Should I alter a quote, if in today's world it might be considered racist? Does this Warlock ability combo allow the whole party to ignore Darkness? Also, be sure that the table/view owner is fully qualified within your query. Odbc Runtime Error 1004 Join them; it only takes a minute: Sign up Excel 2007 - 1004 Run-time error Refresh Query Table up vote 1 down vote favorite It appears that this error is so

Also check that the network connection...if the file is found over a network.. Run Time Error 1004 General Odbc Error Refresh Backgroundquery False Type: Print Worksheets("yoursheetname").Querytables(0).Connection This assumes that the query is the first one on that particular sheet, you may need to go up to (1) or (2) if you have multiple queries. Is this a problem with something else? http://stackoverflow.com/questions/27172202/run-time-error-1004-general-odbc-error-refresh-backgroundquery-false The machines with Excel 2007 only have "SQL Server".

However I have changed various parts of the example provided to something slightly more generic as the select statement goes on a while. General Odbc Error Microsoft Odbc Sql Server Driver Communication Link Failure is there any syntax that isn't compatible in 2010? –Matt Feb 3 '15 at 10:46 Is it still timing out even if you remove the On Error Resume Next How much clearer are stars in earths orbit? 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

Run Time Error 1004 General Odbc Error Refresh Backgroundquery False

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 http://www.mrexcel.com/forum/excel-questions/433755-general-odbc-error-run-time-error-1004-a.html In my case I have created a macro that works in Excel 2010 and does not work in Excel 2007. Run Time Error 1004 General Odbc Error 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. Run Time Error 1004 General Odbc Error In Excel I put your Array code back in and saved it this time.

Friday, August 13, 2010 1:08 AM Reply | Quote 0 Sign in to vote Hi, did you find any solution for you problem ?? More About Us... Can someone please offer some advice? The error you are getting indicates an error with the query connection. General Odbc Error 1004 Excel 2010

Each worksheet had its own attached MS Query which connected to an Oracle database view. write Expand|Select|Wrap|Line Numbers msgbox(.connection) before you refresh the querytable, this will show you the connection path, so you can check it. Talk With Other Members Be Notified Of ResponsesTo Your Posts Keyword Search One-Click Access To YourFavorite Forums Automated SignaturesOn Your Posts Best Of All, It's Free! Why did Snow laugh at the end of Mockingjay?

Register Lost Password? Runtime Error 1004 General Odbc Error Excel I create the querytable via vba and the connection string is this: (it works greate without any odbc or tnsnames configuration) ODBC;Driver={Microsoft ODBC for Oracle};Server=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ora1)(PORT=1521))(CONNECT_DATA=(SID=PRODEBS)));Uid=appsr;Pwd=xyzz; My macro does the .refresh and more hot questions question feed lang-vb about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation

It takes just 2 minutes to sign up (and it's free!).

Reason: Added more information Faq July 19th, 2013,05:39 PM #2 No Profile Picture couttsj View Profile View Forum Posts  Contributing User Devshed Newbie (0 - 499 posts)   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 Skip,Just traded in my old subtlety...for a NUANCE! General Odbc Error Refresh Backgroundquery These are the codes highlighted in color when I debug the macro back on July.

Microsoft Customer Support Microsoft Community Forums Login with LinkedIN Or Log In Locally Email or Username Password Remember Me Forgot Password?Register ENGINEERING.com Eng-Tips Forums Tek-Tips Forums Search Posts Find A Are you aComputer / IT professional?Join Tek-Tips Forums! I checked the connection AFTER the initial successful refresh and noticed it was changed to this: ODBC;DRIVER={Microsoft ODBC for Oracle};UID=appsr;PWD=appsr; The Server portion is stripped out! Close this window and log in.

If the DisplayAlerts property is False, dialog boxes aren't displayed and the Refresh method fails with the Insufficient Connection Information exception. Yes, my password is: Forgot your password? RE: Run-time error '1004' General ODBC Error SkipVought (Programmer) 9 Sep 10 13:02 oh and one other thing:What VERSION of Excel? You can obtain the completed connection string by examining the value of the Connection property.

All I'm saying is you can specify connection settings using strings: With ActiveSheet.QueryTables.Add(Connection:= "ODBC;DRIVER={Oracle in OraHome92};SERVER=XXXXXX;UID=DT_I;PWD=RO2ACCESS;DBQ=XXXXXXP;DBA=W;APA=T;EXC=F;XSM=Default;FEN=T;QTO=T;FRC=10" etc etc Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Dec If the specified connection string is missing required values, dialog boxes will be displayed to prompt the user for the required information. Also, can you try it on any other PCs? Getting bool from C to C++ and back Appease Your Google Overlords: Draw the "G" Logo What's the difference between /tmp and /run?

If you're having a computer problem, ask on our forum for advice. then put these changes in the non-working PC. The mortgage company is trying to force us to make repairs after an insurance claim maintaining brightness while shooting bright landscapes Meaning of "it's still a land" New tech, old clothes Share it with others Like this thread?

I've started from the beginning again. I feel the error is not the sql but something else. When making the connection to the OLE DB or ODBC data source, Microsoft Excel uses the connection string specified by the Connection property. I am able to run the below macro on my PC; however my colleagues are unable to run the same on their PC's and are getting the ODBC general 1004 error.

When i click on Debug, VB opens and it shows: Object = General Procedure = Get_program_dates and highlighted in Yellow is: .Refresh BackgroundQuery:=False I have searched the internet for the error 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... no problem.