excel odbc error 1004 Colonial Heights Virginia

Address 601 Colonial Ave, Colonial Heights, VA 23834
Phone (804) 526-2249
Website Link http://www.computersolutions-va.com

excel odbc error 1004 Colonial Heights, Virginia

My "Error Trapping" setting is "Break on unhandled errors".....if my User's computer has a different setting could that be the reason? (He's tied up right now so I can't check his 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 Please post a thread in the appropriate forum. floppybootstomp posted Oct 14, 2016 at 3:53 PM Toe-tale Taffycat posted Oct 14, 2016 at 11:04 AM WCG Stats Friday 14 October 2016 WCG Stats posted Oct 14, 2016 at 8:00

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 Hopefully this will at least help someone else with the same error as my search turned up very little. I'm getting a Run-time error '1004': General ODBC Error. go to VBA menu Tools - Options - General - > >> > Error > >> > Trapping. > >> > > >> > "CLR" wrote: > >> > > >>

Register Lost Password? It might be useful to know which one is the "exception". You may also re-connect the Excel file with the SQL server database. TH How to mount a disk image from the command line?

Also, can you try it on any other PCs? 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 Last edited by eljefe_cendigit; July 19th, 2013 at 04:03 PM. Determine if a coin system is Canonical Is intelligence the "natural" product of evolution?

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 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 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. 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=,1433")).Sql = Array(reportdate).Refresh BackgroundQuery:=FalseEnd WithI have not had any luck googling the '1004' error, it seems that it could be many

I am using Office 2007 and Windows 7 64 bit. I would remove some unecessary line in the command until you get it to work. Kindly help. The Excel file has multiple macros.

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 And I guess that since the last few months were double digit months (I must have been working on it on double digit days as well) there was no issue because The problem happened when we moved the database to another server. Also, can you try it on any other PCs?

This code previously worked and suddenly it will not refresh the back ground query anymore: Sub LoadFromDb(sDb As String, sSql As String, sTab As String, sPath As String, sRange As String) Close Reply To This Thread Posting in the Tek-Tips forums is a member-only feature. If I ran it manually and went into MS Query to change the query, it was in the 'm-d-yyyy' format. When I held my cursor over 'reportdate' it showed reportdate="exec jpm_tiretrack '12/01/2002', '09/01/2010'"The excel version is 2000 and the server is sql server 2005.Thanks RE: Run-time error '1004' General ODBC Error

go to VBA menu Tools - Options - General - >> > Error >> > Trapping. >> > >> > "CLR" wrote: >> > >> > > Hi All......... >> > I am using a dsn that is set up already and it works, but should I try setting up a new one for this test. These are the codes highlighted in color when I debug the macro back on July. go to VBA menu Tools - Options - General - Error >> Trapping. >> >> "CLR" wrote: >>> On Friday, November 07, 2008 10:36 AM CL wrote: >>> Hi Joel........ >>>

One thing to >> > check is >> > the error option in BA. RE: Run-time error '1004' General ODBC Error Imakeoil (Programmer) (OP) 9 Sep 10 15:51 This is great code. 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 If the query isn't valid, the Refresh method fails with the SQL Syntax Error exception.

You can obtain the completed connection string by examining the value of the Connection property. Vaya con Dios, Chuck, CABGx3 "Joel" wrote: > It would help to know which line of code is failing. 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! Also, i tried running the code post removing DefaultDir and Driver Id as well.

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 How to deal with players rejecting the question premise EvenSt-ring C ode - g ol!f Why does the material for space elevators have to be really strong? Did Sputnik 1 have attitude control? The difference is that on 64 bit systems, all the library files and drivers in the "%SystemRoot%\system32\" directory are 64 bit.

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 checked both ofb these and they are fine. Raiders #1 AKA:Gangsta Yoda™ Posts 60,221 Re: General ODBC error Welcome to the Forums. 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

Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free. Microsoft MVP 2006-2011 Office Development FAQ (C#, VB.NET, VB 6, VBA) Senior Jedi Software Engineer MCP (VB 6 & .NET), BSEE, CET If a post has helped you then Please Rate I'd rather not have to build a macro to keep resetting it. If you right click in the cell you should see the refresh option. –AxGryndr Apr 22 '13 at 16:54 It does in 2010, but not in 2007. –lance Apr

If the DisplayAlerts property is False, dialog boxes aren't displayed and the Refresh method fails with the Insufficient Connection Information exception. Microsoft Customer Support Microsoft Community Forums 418,548 Members | 946 Online Join Now login Ask Question Home Questions Articles Browse Topics Latest Top Members FAQ home > topics > 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)   Skip,Just traded in my old subtlety...for a NUANCE!

As I understand it the ports tend to be standard, but I couldn't figure out how to check the settings on this server. Posting Guidelines Promoting, selling, recruiting, coursework and thesis posting is forbidden.Tek-Tips Posting Policies Jobs Jobs from Indeed What: Where: jobs by Link To This Forum! No, create an account now. Like I said, the code works fine on my computer, just not on his.

Browse other questions tagged sql-server excel vba excel-vba or ask your own question. Thanks to those that responded. ronaksinghwadhwa, Jul 10, 2013 #8 Advertisements Show Ignored Content Want to reply to this thread or ask your own question? Digital Diversity Can an ATCo refuse to give service to an aircraft based on moral grounds?

Browse other questions tagged excel vba odbc runtime or ask your own question.