excel runtime error 1004 odbc Conroe Texas

Address 2700 Technology Forest Blvd Ste 250, Spring, TX 77381
Phone (281) 419-4262
Website Link http://www.intellicure.com
Hours

excel runtime error 1004 odbc Conroe, Texas

asked 1 year ago viewed 1476 times active 1 year ago Get the weekly newsletter! it's setting the variable once vs setting it 11x and reading it 10x with growing length every time. RE: Run-time error '1004' General ODBC Error SkipVought (Programmer) 9 Sep 10 14:56 OK.In a new sheet, start a new database query, format an SQL and return data to Excel.With this 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:

asked 3 years ago viewed 19814 times active 1 year ago Get the weekly newsletter! Moved by kleinmaMVP Wednesday, August 10, 2011 8:11 PM (From:Visual Basic General) Wednesday, August 10, 2011 8:09 PM Reply | Quote All replies 0 Sign in to vote Rather than debug This is the error we have got: Run-Time Error 1004, General ODBC error. If it makes any difference the connection is to SQL Server Management Studio.

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. me = nerd here.. –peege Nov 27 '14 at 17:01 add a comment| up vote 0 down vote The error went away after a computer reset. How can I get it to keep from being changed? then put these changes in the >>>> non-working PC. >>>> >>>> Here are things that I think are un-needed >>>> >>>> 1) DefaultDir= >>>> 2) DriverId=281 >>>> >>>> Also make sure

Thanks –Matthew Hopkins Nov 27 '14 at 16:54 I wish I could help you more on the SQL connection. When I click on the debug it points to .Refresh BackgroundQuery:=False. Run Time Error '1004' General ODBC Error Obviously some difference between the two machines, but who knows what to do to fix it? The content you requested has been removed.

You are absolutely correct, well spotted ☺. then put these changes in the > non-working PC. > > Here are things that I think are un-needed > > 1) DefaultDir= > 2) DriverId=281 > > Also make sure go to VBA menu Tools - Options - General - > >> > Error > >> > Trapping. > >> > > >> > "CLR" wrote: > >> > > >> All rights reserved.Unauthorized reproduction or linking forbidden without expressed written permission.

Advertisements Latest Threads WCG Stats Saturday 15 October 2016 WCG Stats posted Oct 15, 2016 at 8:00 AM Review round up - 14 October 2016 Becky posted Oct 14, 2016 at When making the connection to the OLE DB or ODBC data source, Microsoft Excel uses the connection string specified by the Connection property. 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. After the database connection is made, the SQL query is validated.

Need book id. RE: Run-time error '1004' General ODBC Error SkipVought (Programmer) 9 Sep 10 16:05 Here is the returned stringODBC;DSN=dsn201;Description=JPdb;UID=minedata;PWD=1xx$F;APP=Microsoft® Query;WSID=CAL-L-97076;DATABASE=PowerYou did NOT return the entire string.Get rid of the Array() functions also! The machines with Excel 2007 only have "SQL Server". PaulO View Public Profile Find More Posts by PaulO

« Previous Thread | Next Thread » Thread Tools Show Printable Version Email this Page Display Modes

Not sure why. Why would a password requirement prohibit a number in the last character? then put these changes in the non-working PC. How do computers remember where they store things?

But it's shown in "refresh" line because there is when excel connects with the data base. Which option did Harry Potter pick for the knight bus? 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 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

Join Us! *Tek-Tips's functionality depends on members receiving e-mail. Your name or email address: Do you already have an account? Skip,Just traded in my old subtlety...for a NUANCE! 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 the following > >

After Microsoft Excel makes a successful connection, it stores the completed connection string so that prompts won't be displayed for subsequent calls to the Refresh method during the same editing session. Original Code: This does a nice job of lining up the characters to read the statement, but is redundant by defining the value of strSQL for every line item. With ODBC, the best thing is to start as simply (a simple read) as you can, and add pieces until it breaks. then put these changes in the > > non-working PC. > > > > Here are things that I think are un-needed > > > > 1) DefaultDir= > > 2)

Can an ATCo refuse to give service to an aircraft based on moral grounds? Also, can you try it on any other PCs? Click Here to join Tek-Tips and talk with other members! Here's Why Members Love Tek-Tips Forums: Talk To Other Members Notification Of Responses To Questions Favorite Forums One Click Access Keyword Search Of All Posts, And More...

What emergency gear and tools should I keep in my vehicle? Sign Up Now! 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 the following > error. > 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

If anything is unclear or if there is anything I can do for you, please feel free to let me know. Developing web applications for long lifespan (20+ years) UPDATE heap table -> Deadlocks on RID Appease Your Google Overlords: Draw the "G" Logo The mortgage company is trying to force us The error you are getting indicates an error with the query connection. Please take your time to try the suggestions and let me know the results at your earliest convenience.

Join your peers on the Internet's largest technical computer professional community.It's easy to join and it's free. Selection.QueryTable.Refresh BackgroundQuery:=False Does this tell you something? If so nothing more than to keep it easy to read through for colleaques etc. I almost have this working but I'm getting stuck on this ...

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 Jan 31 '08 #2 reply P: 13 elecooley Since he said it might be date...which is possible have you checked you computer date an sync to get correct time + Date.... Browse other questions tagged excel vba odbc runtime or ask your own question.