general odbc error 1004 excel 2010 Wheeling West Virginia

Address 120 Poplar Ave, Moundsville, WV 26041
Phone (304) 810-4190
Website Link
Hours

general odbc error 1004 excel 2010 Wheeling, West Virginia

Faq July 23rd, 2013,09:47 AM #4 No Profile Picture eljefe_cendigit View Profile View Forum Posts  Registered User Devshed Newbie (0 - 499 posts)  Facebook Google + Join Date I am stumped. With the debugger still pointing to the .Refresh BackgroundQuery line. asked 3 years ago viewed 19820 times active 1 year ago Get the weekly newsletter!

Thanks –Matthew Hopkins Nov 27 '14 at 16:54 I wish I could help you more on the SQL connection. On the code above: I think it is less demanding, not that a few characters are hard to deal with, but it doesn't have to read the previous value every time I would truly appreciate the help. Monday, June 13, 2016 1:37 PM Reply | Quote 0 Sign in to vote I just had this problem and found I needed tospecifiy .CommandType = xlCmdSql before I specified the

Are you aComputer / IT professional?Join Tek-Tips Forums! 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. Strings? Browse other questions tagged excel vba odbc runtime or ask your own question.

Browse other questions tagged excel excel-vba excel-2010 or ask your own question. The time now is 10:17 PM. Does this make sense to anyone and how do I proceed. Similar topics Copying Worksheet to another Workbook - ERROR ODBC Connection Error read/write excel using odbc ODBC has error but no error message displayed Excel Automation Getting Excel worksheet names with

Do I need to change the connection string structure for 2007, or is there another issue at work? because i'm having the same issue and can't find the reason why it doesn't store the "SERVER" parameter.. If the DisplayAlerts property is False, dialog boxes aren't displayed and the Refresh method fails with the Insufficient Connection Information exception. When you run 32 bit software, you are automatically directed to the "%SystemRoot%\syswow64\" directory.

Resources Join | Indeed Jobs | Advertise Copyright © 1998-2016 ENGINEERING.com, Inc. Reply With Quote Jan 4th, 2011,03:11 PM #4 Baconator View Profile View Forum Posts Thread Starter New Member Join Date Nov 2010 Posts 4 Re: General ODBC error Oh brother! The "from" and "to" date fields I added ( I think I'm correct). How can I get it to keep from being changed?

I've tried both the 32bit (oraclient11g_home1_32) and the 64bit (oraclient11g_home1) however with no luck. 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 Forum New Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links Today's Posts View Site Leaders What's New? 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

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. Apparently the date needs to be 'yyyy-mm-dd' even though the Microsoft Query editor show it as 'm-d'. As I understand it the ports tend to be standard, but I couldn't figure out how to check the settings on this server. Registration on or use of this site constitutes acceptance of our Privacy Policy.

To use the 32 bit manager, you must specifically run %SystemRoot%\syswow64\odbcad32.exe. 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 - Can cats leave scratch marks on cars? 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:

But it's shown in "refresh" line because there is when excel connects with the data base. Join UsClose Register Help Remember Me? Changing to your solution (or removing the BackgroundQuery altogether), have no affect. If the DisplayAlerts property is False, dialog boxes aren't displayed and the Refresh method fails with the Insufficient Connection Information exception.

What kind of distribution is this? Skip,Just traded in my old subtlety...for a NUANCE! Karger's Algorithm question Why does this execution plan have Compute Scalars? How does NumPy solve least squares for underdetermined systems?

Is it plausible for my creature to have similar IQ as humans? share|improve this answer edited Apr 22 '13 at 17:53 answered Apr 22 '13 at 16:17 AxGryndr 1,1981729 Thanks for the suggestion, but it's not the .BackgroundQuery property causing the more hot questions question feed default about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation Why microcontroller takes many clock cycles to start up with PLL clock source?

it's setting the variable once vs setting it 11x and reading it 10x with growing length every time. But why does it work on his and not mine? Thanks Matt share|improve this answer answered Dec 1 '14 at 10:26 Matthew Hopkins 105 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up 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

Close Box Join Tek-Tips Today! This was running just fine the last few weeks, but seems to have stopped on the 1st. Excel - Tips and Solutions for Excel Privacy Statement Terms of Service Top All times are GMT -4. RE: Run-time error '1004' General ODBC Error Imakeoil (Programmer) (OP) 9 Sep 10 14:50 No go.

All contents Copyright 1998-2016 by MrExcel Consulting. If the query isn't valid, the Refresh method fails with the SQL Syntax Error exception. Here is a summary of the code: cn = "ODBC;Driver={SQL Server Native Client 10.0};Server=serverName;Database=dbName;Trusted_Connection=yes;" sql = "select top 10 * from tableName" Dim S As Worksheet Set S = ActiveWorkbook.Sheets("Medical") With How exactly does mining software work?

Radius of Convergence of Infinite Series Is it illegal for regular US citizens to possess or read documents published by Wikileaks? 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 As each line adds, it gets exponentially more demanding. When i click on the shortcut, I get an error pop up: Run time error 1004' General ODBC error.

I have literally copied and pasted the sql bit into sql and it works perfectly fine. Thanks to those that responded. 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. 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.

Skip,Just traded in my old subtlety...for a NUANCE! In it, you'll get: The week's top questions and answers Important community announcements Questions that need answers see an example newsletter By subscribing, you agree to the privacy policy and terms RE: Run-time error '1004' General ODBC Error Imakeoil (Programmer) (OP) 9 Sep 10 14:22 Here is the SQL. Please post a thread in the appropriate forum.