general odbc error vba West Wareham Massachusetts

Address 63 Metzler Rd, East Bridgewater, MA 02333
Phone (508) 350-0101
Website Link

general odbc error vba West Wareham, Massachusetts

Run Time Error '1004' General ODBC Error Obviously some difference between the two machines, but who knows what to do to fix it? It doesn't look like the connection string contains the login credentials. 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 Here's the code: Sub ConnectSQL() Dim connstring As String Dim sLogin As String Dim qt As QueryTable sLogon = "Uid=*;Pwd=*;" sqlstringFirma = "select * from gi_kunden.tbl_Firma" sqlstringPerson = "select * from

excel vba odbc runtime share|improve this question edited May 6 '13 at 22:06 Undo♦ 18.4k157399 asked Apr 22 '13 at 16:03 lance 26115 Error 1004 is generic error but Now the actual problem may be that this microsoft query doesn't have the UNICODE-library and I don't know where I could put them so that the microsoft query would read/get them. share|improve this answer edited Feb 3 at 12:38 answered Feb 3 at 12:31 Nile 2,2861525 Before I'll test your codes, some more information: No ADODB is not supported. If it does then you must have some offending data which is creating the odbc errors VB/Office Guru™ (AKA: Gangsta Yoda™ ®) I dont answer coding questions via PM.

To use the 32 bit manager, you must specifically run %SystemRoot%\syswow64\odbcad32.exe. 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 If the DisplayAlerts property is False, dialog boxes aren't displayed and the Refresh method fails with the Insufficient Connection Information exception. Results 1 to 6 of 6 Thread: [RESOLVED] General ODBC error Tweet Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded

All times are GMT -5. When I click on the debug it points to .Refresh BackgroundQuery:=False. go to VBA menu Tools - Options - General - >> > Error >> > Trapping. >> > >> > "CLR" wrote: >> > >> > > Hi All......... >> > Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free.

facebook google twitter rss Free Web Developer Tools Advanced Search  Forum Programming Languages - More Visual Basic Programming Excel VBA General ODBC Error Thread: Excel VBA General ODBC Error Share Hello. Thank you for your help. > On Friday, November 07, 2008 9:38 AM CL wrote: > Hi All......... > I have a little macro that queries an ACCESS file and returns If you're having a computer problem, ask on our forum for advice.

Nothing has changed from 2007 to 2010 in regards to this so if changing the property does not fix the issue there is something else going on such as part of 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. Skip,Just traded in my old subtlety...for a NUANCE! 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.

I am able to run the below macro on my PC; however my colleagues are unable to run the same on their PC's and are getting the ODBC general 1004 error. Reason: Added more information Faq July 19th, 2013,05:39 PM #2 No Profile Picture couttsj View Profile View Forum Posts  Contributing User Devshed Newbie (0 - 499 posts)   MikeH posted Oct 16, 2016 at 11:56 PM WCG Stats Sunday 16 October 2016 WCG Stats posted Oct 16, 2016 at 8:01 AM Happy Birthday Captain Zed! Sadly, the first code you wrote throws an active-x error because of adodb...

I have exactly the same problem with "QueryTable(1).Refresh", which is throwing the error: "Variable not defined" even though it's listed and declared in the object-browser ("Class QueryTable Member of Excel"). date: invalid date '2016-10-16' What do I do when two squares are equally valid? 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) If I ran it manually and went into MS Query to change the query, it was in the 'm-d-yyyy' format.

No, create an account now. When you run 32 bit software, you are automatically directed to the "%SystemRoot%\syswow64\" directory. The program works fine on my computer, but when my user > >> > > tries to run > >> > > it on his computer, (same versoion of Excel, 2000), Is there a Korean word for 'Syllable Block'?

How should I interpret "English is poor" review when I used a language check service before submission? 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... 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 But now, my boss is not able to run the Macro either.

then put these changes in the > > non-working PC. > > > > Here are things that I think are un-needed > > > > 1) DefaultDir= > > 2) Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework. Are there any rules or guidelines about designing a flag? Why is water evaporated from the ocean not salty?

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 Last edited by eljefe_cendigit; July 19th, 2013 at 04:03 PM. Close Reply To This Thread Posting in the Tek-Tips forums is a member-only feature. 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

Close Box Join Tek-Tips Today! 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 The difference is that on 64 bit systems, all the library files and drivers in the "%SystemRoot%\system32\" directory are 64 bit. Resources Join | Indeed Jobs | Advertise Copyright © 1998-2016, Inc.

Skip,Just traded in my old subtlety...for a NUANCE! If it ran fine until the 1st of the new year then perhaps its a data issue. RE: Run-time error '1004' General ODBC Error Imakeoil (Programmer) (OP) 9 Sep 10 14:50 No go. EDIT This throws the same "General ODBC error" on the line ActiveWorkbook.RefreshAll: Dim strConn As String Dim strLoginData As String Dim QT As QueryTable Dim strFirmSQL As String Dim strPersSQL As

arrays: A string is just text encased in quotes, "hello there". Forum Board FAQ Forum Rules Guidelines for Forum Use FAQ Forum Actions Mark Forums Read Quick Links Today's Posts Search New Posts Zero Reply Posts Subscribed Threads MrExcel Consulting Advanced Search If it fails to work, go back to the ConnectionTest code and run the command text against the conADO connection object: conADO.Execute strCommandText ...And interrogate the errors collection again. 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

I believe I would get these kind of errors for all the things that are connected 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 About Us PC Review is a computing review website with helpful tech support forums staffed by PC experts. I am facing the similar problem (the one shown below by CLR)..

Type: Print Worksheets("yoursheetname").Querytables(0).Connection This assumes that the query is the first one on that particular sheet, you may need to go up to (1) or (2) if you have multiple queries. The app makes a connection to an Oracle database and retrieves certain data based on specific user input. 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