Home > Unspecified Error > Unspecified Error Adodb Connection

Unspecified Error Adodb Connection

The connection to dataserver is succesfull. All times are GMT -5. Thread Tools Display Modes

#1 (permalink) April 8th, 2005, 11:23 AM werD420 Authorized User Join Date: Jan 2005 Location: , , . I thought it is a driver issue and installed Access 2007 Database engine in the user's PC and replaced Provider with "Microsoft.ACE.OLEDB.12.0" but it doesn't work. his comment is here

Probably you will know what the problem is right away as reason for error is likely clearly stated in error collection: http://msdn2.microsoft.com/en-us/library/system.data.odbc.odbcexception.errors.aspx Sunday, July 09, 2006 5:26 PM Reply | Quote 0 Sign In order to become a pilot, should an individual have an above average mathematical ability? Suggested Solutions Title # Comments Views Activity VBA to format 3 67 99d VB6 convert MSHFlexgrid1 cells no2 2 36 95d Access 2003, my txt file export is running backwards 4 Reply from jmcdermott | Oct 23, 2001 Popular White Paper On This Topic A Beginner's Guide to VoIP All Replies (3) Best Answer 0 Mark this reply as the best answer?(Choose

Even the ASP page would still run as long as I click on Terminal03 then press the back button. Reason: insert vba tags CreganTur10-27-2009, 05:28 AMHow is value being passed into the dbpath variable? MZTools (free upgrade for the VB6/VBA Editor) Reply With Quote Jun 7th, 2012,08:05 PM #7 patchirajan View Profile View Forum Posts New Member Join Date Jun 2012 Posts 1 Re: "Unspecified You HAVE to try to understand WHAT fails: : [b][italic]Philip Patrick[/italic][/b]: [b]Home page[/b]: http://www.stpworks.com: [size=1][italic]"Two beer or not two beer?"[/italic] [b]Shakesbeer[/b][/size]: : 0 · Share on Facebook pridi Member Posts: 1

Results 1 to 4 of 4 Thread: Unspecified error - opening ADODB.Recordset Tweet Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to I wrote some test macros, in the same file which has the original macros, that open DB connection to local DB file and remote DB file. Registration is fast, simple and absolutely free . The code:oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & filePath is where the error would appear.: right, it is somewhere in setting, but the CODE gives an error, so you have to look up in

Open the terminal03 home page, and then look for links to the information you want--------------------I would click on the terminal03(terminal03 is my computer name) and the Windows 2000 Internet Service welcome Unknown User replied Oct 24, 2001 Try opening the recordset specifying read only aswell: bdRS.Open QueryString, dbConn, 1, 4 Top This thread has been closed due to inactivity. Hitchhiker's Guide to Getting Help at VBForums Classic VB FAQs (updated Oct 2010) ...Database Development FAQs/Tutorials (updated May 2011) (includes fixing common VB errors) .......... (includes fixing common DB related errors, SQL Server downloads ..

That's where the error would appear. But I still wasn't able to solve the problem. In my case the constants weren't needed. Sign In Register Categories Recent Discussions Unanswered Best Of...

All the rest of the fields are number and varchar2. I think the problem is on my computer settings but I don't know which causes this problem. Here are the things I've done but didn't solve the problem: 1.) Uninstall the MS Office and then installed it back. 2.) Uninstall the IIS and then install it back. 3.) On trying to incorporate a save in the error handler and calling in the main function again did not work.

Join our community for more solutions or to ask questions. this content The error is just at the objRecordset. Subscribed! So I think the problem is in my computer settings.

To start viewing messages, select the forum that you want to visit from the selection below. First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone. You are currently viewing the Classic ASP Databases section of the Wrox Programmer to Programmer discussions. weblink I am connecting to an AS/400 using the Client Access ODBC Driver installed on my machine.

Using automation, an Access applic… MS Access Outlook Visual Basic Classic Creating and Using an Access Class Module Video by: TechMommy Get people started with the utilization of class modules. Contact Us - Wrox - Privacy Statement - Top Powered by vBulletin Copyright ©2000 - 2016, Jelsoft Enterprises Ltd. 2013 John Wiley & Sons, Inc. Posts: 21 Thanks: 0 Thanked 0 Times in 0 Posts Unspecified Error???

Monday, July 10, 2006 5:55 AM Reply | Quote 0 Sign in to vote I 've found the reason why it does not work. !!

The error that is raised is a generic error number. MDAC/Jet/ACE downloads .. thanks, Ajay 0 Question by:ajayshm Facebook Twitter LinkedIn Google LVL 15 Best Solution bynamasi_navaretnam Check this out: http://support.microsoft.com/?kbid=234218 Go to Solution 5 Comments LVL 44 Overall: Level 44 Visual Basic My connection function: Sub SetConReadOnly(ByRef con1 As Object, ByRef rst1 As Object, sFile As String) If con1 Is Nothing Then Set con1 = CreateObject("ADODB.Connection") If rst1 Is Nothing Then Set rst1

Convert colour number to colour name .. If you open a connection and then close it without doing nothing it will work? If the exe is... check over here The time now is 01:57 AM.

SQL 'Select' statement formatter/checker .. Always respect the original author. We are thinking whether this might be cause of the problem, and using the retry logic seems to be working. The error I get randomly is the following.

I see many places that can lead to error. I think it must not be on the code but on the computer settings. Search Forums Show Threads Show Posts Advanced Search Find All Thanked Posts Go to Page... The connection is created using: Set mDBConn = New ADODB.Connection mDBConn.Provider = "MSDataShape" mDBConn.ConnectionString = "Data Provider=MSDASQL;uid=" & sUID & ";Pwd=" & sPWD & ";DSN="

in the following call: rs.Open sSQL, myConnection(), adOpenStatic, adLockReadOnly where myConnection() function returns the ADODB.Connection that we create during application start up. Reply With Quote May 13th, 2008,03:41 PM #2 si_the_geek View Profile View Forum Posts Super Moderator Join Date Jul 2002 Location Bristol, UK Posts 38,335 Re: "Unspecified error" when I try If you want to get involved, click one of these buttons! I got an error "Unspecified error" when I try to open a recordset.

For more information, see the article What do the parameters of the recordset.Open method mean? FlexGrid: AutoSize columns .. You could write or overwrite a query in the target Access database whenever parameters change in one method, and then create your recordset in a separate method. Can't do it.