excel general odbc error Coeburn Virginia

Address 4021 Happy Hollow Rd, Coeburn, VA 24230
Phone (276) 395-8177
Website Link http://pcdocpro.com

excel general odbc error Coeburn, Virginia

What typically would give this error? Unless this method is called, the QueryTable object doesn't communicate with the data source. RE: Run-time error '1004' General ODBC Error Imakeoil (Programmer) (OP) 9 Sep 10 14:50 No go. Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free.

I can't seem to find the correct place to make a connection to the driver, do I need to put the full path in my code? Jan 31 '08 #3 reply Expert 100+ P: 1,295 kadghar I think the error comes from the Connection. Why are so many metros underground? 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

Close this window and log in. Powered by vBulletin Version 4.2.3 Copyright © 2016 vBulletin Solutions, Inc. Results 1 to 4 of 4 General ODBC Error on QueryTable.Refresh - potential causes?This is a discussion on General ODBC Error on QueryTable.Refresh - potential causes? I put your Array code back in and saved it this time.

share|improve this answer answered Jul 2 '15 at 13:09 pkk 1 Could you please elaborate on where this should go and what it does? –SuperBiasedMan Jul 2 '15 at To start viewing messages, select the forum that you want to visit from the selection below. Is there a role with more responsibility? Are there any rules or guidelines about designing a flag?

Registration on or use of this site constitutes acceptance of our Privacy Policy. but you never know =P. 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 Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Sep 10th, 2003,10:48 AM #3 JKFEagle New Member Join Date Apr 2002 Location Lexington, SC Posts 48 Re: General

I have copied the excel sheet from a working copy and am trying to point it at a different server. You may want to make some attempt to refresh the table manually to see if that functions properly. 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 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 All replies 1 Sign in

RE: Run-time error '1004' General ODBC Error Imakeoil (Programmer) (OP) 9 Sep 10 18:11 I am not sure what you mean by 'You did not return the entire string.' I even After the database connection is made, the SQL query is validated. About Us PC Review is a computing review website with helpful tech support forums staffed by PC experts. no problem.

Please take your time to try the suggestions and let me know the results at your earliest convenience. Well, you saved the day, or week, or several weeks that I've been working on that problem........just as you suggested, I removed everything from the macro that I could and have 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 How to deal with players rejecting the question premise Why did it take 10,000 years to discover the Bajoran wormhole?

Louis, MO Posts 1 Excel Driver Used One of the issues that I encountered with using Excel to build a report from a database was due to driver versioning differences. What is the most expensive item I could buy with £50? One thing to check is >> the error option in BA. One thing to check is > > the error option in BA.

share|improve this answer answered Apr 23 '13 at 1:44 lance 26115 add a comment| up vote 0 down vote Change your property .Refresh BackgroundQuery:=False to be .Refresh. When we were on XP we were using Oracle 10g, and upgraded with the Windows upgrade. Share it with others Twitter Linked In Google Reddit StumbleUpon Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not 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

Each worksheet had its own attached MS Query which connected to an Oracle database view. By joining you are opting in to receive e-mail. We're a friendly computing community, bustling with knowledgeable members to help solve your tech questions. 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

We have checked that we have the same connections (Data Sources). J.A Coutts When I go to change the shortcut in Data Sources (ODBC). Howeverm unable to achieve the sucess. 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

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 Raiders #1 AKA:Gangsta Yoda™ Posts 60,221 Re: [RESOLVED] General ODBC error Thanks for the update but I thought nothing had changed so this would mean you were running it with different Excel - Tips and Solutions for Excel Privacy Statement Terms of Service Top All times are GMT -4. You can obtain the completed connection string by examining the value of the Connection property.

The refresh commands prior to that one seem to work (different worksheets). Please take your time to try the suggestions and let me know the results at your earliest convenience. All rights reserved Home Forums Articles Badges Privacy Policy Support Sitemap Newsletter Signup Free Web Developer Tools

418,548 Members | 916 Online Join Now login Ask Question Why is it a bad idea for management to have constant access to every employee's inbox Players stopping other player actions "all empires will suffer the same fate should the lessons

If the specified connection string is missing required values, dialog boxes will be displayed to prompt the user for the required information. 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. Please post a thread in the appropriate forum. Thanks for the help Daniel.

My CEO wants permanent access to every employee's emails. Truth in numbers Is it appropriate to tell my coworker my mom passed away? go to VBA menu Tools - Options - General - >> > Error >> > Trapping. >> > >> > "CLR" wrote: >> > >> > > Hi All......... >> > I was hoping someone could help me out so I can zero in on the problem without having to trace out the entire code logic.

If you're having a computer problem, ask on our forum for advice. It seems to be a conversion issue between what it takes successfully in the CommandText line and what MS Query shows and uses. Just click the sign up button to choose a username and then you can ask your own questions on the forum. Excel gets the data via FileDSN which I updated but the still I get the “ 1004 run error” General ODBC error “ and VB editor points at the row: