excel 2007 runtime error 1004 general odbc error Christopher Illinois

Address 1712 N 14th St, Herrin, IL 62948
Phone (618) 942-9306
Website Link http://gts4c.com

excel 2007 runtime error 1004 general odbc error Christopher, Illinois

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 - 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 If the query isn't valid, the Refresh method fails with the SQL Syntax Error exception. I changed the background query to True and then I get the error "Conversion failed when converting datetime from character string." Nothing has changed when it comes to handling the date

About an hour ago, before I got ticked and tried more solutions I was able to see that the query itself was present in the cells on Sheet1. 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 I'd rather not have to build a macro to keep resetting it. The Home of Simple Software Solutions.

I almost have this working but I'm getting stuck on this ... Call AllWorksheetPivots Unload Userform1 Application.DisplayStatusBar = True End Sub Once I get to 20% complete or 77% complete, it crashes at the query refresh at line 32. When I click on the debug it points to .Refresh BackgroundQuery:=False. 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

Your name or email address: Do you already have an account? Does anyone know what I may be doing wrong here? Forum New Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links Today's Posts View Site Leaders What's New? Should say something like Runtime error 1004: followed by more description - that will help narrow down the problem. –AxGryndr Apr 22 '13 at 16:20 Run-time error '1004': General

Password Register FAQ Community Top Posters Today's Posts Search Community Links Social Groups Pictures & Albums Members List Calendar Search Forums Show Threads Show Posts Tag Search Advanced Search Find You’ll be auto redirected in 1 second. 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 First try on the working computer to eliminate as many unecessary items as possible and check to make sure it still works.

Here are things that I think are un-needed 1) DefaultDir= 2) DriverId=281 Also make sure all your variables are references the correct path names like newfile2. "CLR" wrote: > Hi Joel........ Sign Up Now! because i'm having the same issue and can't find the reason why it doesn't store the "SERVER" parameter.. I ran some tests and adding those two characters fixed it all.

Yes, my password is: Forgot your password? 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 You may want to make some attempt to refresh the table manually to see if that functions properly. Hello and welcome to PC Review.

I am facing the similar problem (the one shown below by CLR).. 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 Register Privacy Policy Terms and Rules Help Popular Sections Tech Support Forums Articles Archives Connect With Us Twitter Log-in Register Contact Us Forum software by XenForo™ ©2010-2016 XenForo Ltd. Reply With Quote Jan 4th, 2011,03:58 PM #5 RobDog888 View Profile View Forum Posts Visit Homepage Super Moderator Join Date Apr 2001 Location LA, Calif.

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 The time now is 02:34 AM. then put these changes in the > > non-working PC. > > > > Here are things that I think are un-needed > > > > 1) DefaultDir= > > 2) UpdateProgressBar PctDone Next qt 'Next r 'The task is finished, so unload the UserForm.

If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.Would you like to participate? The time now is 03:34 AM. go to VBA menu Tools - Options - General - > >> > Error > >> > Trapping. > >> > > >> > "CLR" wrote: > >> > > >> All of the individual suite applications are supported here, so please post your question in the relevant section for help.

One thing to > >> > check is > >> > the error option in BA. I think I have it figured out. Daniel posted Oct 6, 2016 Mail Merge Document Type J Craig posted Oct 3, 2016 Would like to input 3 letters into a cell, each having a different numerical value jdoon5261 Register Help Remember Me?

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 To start viewing messages, select the forum that you want to visit from the selection below. When I right click and try to refresh, excel prompts me for Server. All times are GMT -5.

I have set up the file DNS and put it in a shared directory - which I have then pointed to in the VBA code. One thing to check is > > the error option in BA. The Home of Simple Software Solutions. VB/Office Guru™ (AKA: Gangsta Yoda™ ®) I dont answer coding questions via PM.

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 One thing to check is the error option in BA. If the DisplayAlerts property is False, dialog boxes aren't displayed and the Refresh method fails with the Insufficient Connection Information exception. 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 19814 times active 1 year ago Get the weekly newsletter! Banana Queries 12 07-01-2008 08:48 PM Beginner's Guide to managing ODBC Datasources. 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 I'd hoped it was a coding error on my part that involved the year change, but if it is, I can't see it.

Developer Network Developer Network Developer :CreateViewProfileText: Sign in MSDN subscriptions Get tools Downloads Visual Studio MSDN subscription access SDKs Trial software Free downloads Office resources SharePoint Server 2013 resources SQL Server 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 The problem is the way I'm putting the date variable into the array.