excel 2010 runtime error 1004 general odbc error Christopher Illinois

Consulting Business Service Company providing Hi-Tech Service in computer and Network areas.Online Database programming (Microsoft, Unix, Android), Network Design and installation with Service and Support

Address 1007 N McLeansboro St, Benton, IL 62812
Phone (618) 438-5005
Website Link http://www.ceillinois.com
Hours

excel 2010 runtime error 1004 general odbc error Christopher, Illinois

Like I said, the code works fine on my computer, just not on his. 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 Go to the regional settings in the control panel and check the date formats Feb 1 '08 #6 reply Message Cancel Changes Post your reply Join Now >> Sign in RE: Run-time error '1004' General ODBC Error Imakeoil (Programmer) (OP) 9 Sep 10 14:22 Here is the SQL.

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 How to create a Silent Uninstaller for Microsoft Visio {Scripting,XML,Automation,} How to disable a single selective administrative share only (such as C$) ? But now, my boss is not able to run the Macro either. The problem happened when we moved the database to another server.

Cancel Red Flag SubmittedThank you for helping keep Tek-Tips Forums free from inappropriate posts.The Tek-Tips staff will check this out and take appropriate action. Feb 1 '08 #5 reply 100+ P: 491 daniel aristidou Just on the date theme, it might be worth checking whether both PCs have the same settings for date format. RE: Run-time error '1004' General ODBC Error Imakeoil (Programmer) (OP) 9 Sep 10 14:50 No go. 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

Which day of the week is today? Recently I have migrated to windows 7 and one Microsoft excel 2010 form  which was working previously stopped working.  and there were two error messages from Microsoft Visual Basic and Microsoft ODBC Raiders #1 AKA:Gangsta Yoda Posts 60,221 Re: General ODBC error Welcome to the Forums. Thanks Reply With Quote Jan 4th, 2011,01:57 PM #2 RobDog888 View Profile View Forum Posts Visit Homepage Super Moderator Join Date Apr 2001 Location LA, Calif.

Even the guy (not myself) who wrote the code can't figure out why it is not working. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Dec 3rd, 2009,01:14 PM #5 John Wood Board Regular Join Date Sep 2008 Location Ontario, Canada Posts 118 Re: One thing to check is > the error option in BA. 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`,

After wasting a whole day in searching internet for the solution, I finally found a solution. I am facing the similar problem (the one shown below by CLR).. I am a VBA noob and have no idea why it isn't working. 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

ODBC error in Excel macro, on one particular PC P: 13 elecooley Baically, myself and the person I sit next to use a shortcut to an Excel file. Sign Up Now! In the Command text one of the lines was: WHERE i.c LIKE NVL(?, '%') Which for some reason worked in Excel 2007 but not in 2010 By changing it to this 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

Please post a thread in the appropriate forum. 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 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) The first time I did I got the above posted string repeated twice.

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 It might be useful to know which one is the "exception". Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Dec 3rd, 2009,01:12 PM #4 ChrisM Board Regular Join Date Jun 2002 Posts 2,127 Re: General ODBC Error - then put these changes in the non-working PC.

it's a modern post apocalyptic magical dystopia with Unicorns and Gryphons Are independent variables really independent? 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 Many, many thanks, my friend, Vaya con Dios, Chuck, CABGx3 "Joel" <> wrote in message news:... > You will never get an error until you get to the Refresh line. One thing to > >> > check is > >> > the error option in BA.

Unless this method is called, the QueryTable object doesn't communicate with the data source. It is the refresh that is causing the problem. –lance Apr 22 '13 at 16:37 Sorry I meant just .Refresh without using the BackgroundQuery:=False. –AxGryndr Apr 22 '13 at The machines with Excel 2007 only have "SQL Server". Can someone please offer some advice?

Run-time error '3011' in select statement in access2002 Browse more Visual Basic 4 / 5 / 6 Questions on Bytes Question stats viewed: 2854 replies: 5 date asked: Jan 31 '08 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 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 have a little macro that queries

After the database connection is made, the SQL query is validated. 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 Please take your time to try the suggestions and let me know the results at your earliest convenience. Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Feb 17th, 2012,03:09 AM #10 sclem1016 New Member Join Date Feb 2012 Posts 2 Re: General ODBC Error -

Here's the code: Private Sub CommandButton1_Click() Dim smpldatea As Date Dim smpldateb As Date Dim fdate1 As String Dim fdate2 As String smpldatea = UserForm1.TextBox1.Text smpldateb = UserForm1.TextBox2.Text fdate1 = Format(smpldatea, Hello and welcome to PC Review. 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 Best Regards, Sally Tang Marked as answer by Sally Tang Wednesday, June 09, 2010 12:47 AM Monday, June 07, 2010 1:25 AM Reply | Quote 0 Sign in to vote

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 I'm sure someone more intelligent than me will come along and give reasoning behind this, but until then, thats what solved it share|improve this answer answered Feb 4 '15 at 10:49 Solution for "The Oracle(tm) client and networking components were not found." Solution was to add Oracle client path to the system path of windows. then put these changes in the > > non-working PC. > > > > Here are things that I think are un-needed > > > > 1) DefaultDir= > > 2)

Friday, July 08, 2016 8:56 AM Reply | Quote Microsoft is conducting an online survey to understand your opinion of the Technet Web site. 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 DécioC posted Oct 13, 2016 at 11:28 AM Ubiquiti vs Homeplugs? go to VBA menu Tools - Options - General - Error Trapping. "CLR" wrote: > Hi All......... > I have a little macro that queries an ACCESS file and returns desired

The time now is 02:34 AM. 418,548 Members | 887 Online Join Now login Ask Question Home Questions Articles Browse Topics Latest Top Members FAQ home > topics > I changed my connection string to be: cn = "ODBC;Driver=SQL Server;Server=serverName;Database=dbName;Trusted_Connection=yes;" and it worked like a charm. This was running just fine the last few weeks, but seems to have stopped on the 1st. Here is the snippet of code: Expand|Select|Wrap|Line Numbers WithActiveSheet.QueryTables.Add(Connection:=_ "ODBC;DSN=ADW;UID=CurUser;APP=MicrosoftOffice2003;WSID=CP040;DATABASE=DataWarehouse;Trusted_Connection=Yes"_ ,Destination:=Range("A1")) .CommandText=Array(_ "SELECTDISTINCTSTRAT_All_View.EvSDate"&Chr(13)&""&Chr(10)&"FROMDataWarehouse.dbo.STRAT_All_ViewSTRAT_All_View"&Chr(13)&""&Chr(10)&"WHERE(STRAT_All_View.EvSDate>{ts'2005-03-0100:00:00'})") '"SELECTDISTINCTSTRAT_All_View.EvSDate"&Chr(13)&""&Chr(10)&"FROMDataWarehouse.dbo.STRAT_All_ViewSTRAT_All_View"&Chr(13)&""&Chr(10)&"ORDERBYSTRAT_All_View.EvSDateDESC") .name="QueryfromADW" .FieldNames=True .RowNumbers=False .FillAdjacentFormulas=False .PreserveFormatting=True .RefreshOnFileOpen=False .BackgroundQuery=True .RefreshStyle=xlInsertDeleteCells .SavePassword=False .SaveData=True .AdjustColumnWidth=True .RefreshPeriod=0 .PreserveColumnInfo=True .RefreshBackgroundQuery:=False Thanks for any

PC Review Home Newsgroups > Microsoft Excel > Microsoft Excel Programming > Home Home Quick Links Search Forums Recent Posts Forums Forums Quick Links Search Forums Recent Posts Articles Articles Quick