Add Connection Unspecified Error
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company
Unspecified Error While Connecting To Access Database
Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs unspecified error connecting ms access database Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers,
Adodb.connection Open Unspecified Error
just like you, helping each other. Join them; it only takes a minute: Sign up Unspecified error when trying to connect to an MS Access database on Visual Studio 2010 up vote 0 down vote favorite I've unspecified error while opening oledb connection both Visual Studio 2010 (Premium) and MS Access 2010 installed. I'm just trying to connect to a .mdb database file from the server explorer and it doesn't work. I get the following message: "Unspecified error". If I try to add a database on the App_Data folder and open it, I get the same error. I've tried with .accdb and .mdb files but both give the same problem. I have also Visual Studio 2005 installed adodb recordset unspecified error on the same machine. And it works without any problems. Anyone has any thoughts about it? Thank you visual-studio-2010 ms-access share|improve this question asked Dec 28 '10 at 14:10 Luiz 11 Migrate your Access database to SQL 2008 R2 Express if feasible. It would probably save lots of time and heartache into the future. –JcMaltaDev Dec 28 '10 at 14:28 Hello. Thank you for you answer! Unfortunatelly it's not possible. I would like to mainly to take advantage of the EF 4. But this project has as a technical requirement that requires the use of the Jet database. –Luiz Dec 28 '10 at 14:31 Code? It might be that you've got an inappropriate connect string. If it's an MDB, it shouldn't matter that A2010 is installed, as you can use Jet 4 (a part of the OS) and not worry about the ACE. –David-W-Fenton Dec 29 '10 at 1:48 add a comment| 2 Answers 2 active oldest votes up vote 0 down vote Make sure you have the appropriate references in you VS2010 project for Access databases. share|improve this answer answered Dec 28 '10 at 23:26 JeffO 6,19722948 add a comment| up vote 0 down vote Not sure this counts as an answer but, the issue is with Visual Studio 2010. I too need
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn
Oledbconnection Open Unspecified Error
more about Stack Overflow the company Business Learn more about hiring developers or posting system data oledb oledbexception unspecified error ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up “Unspecified error” while opening an ADODB connection up vote 4 down http://stackoverflow.com/questions/4546655/unspecified-error-when-trying-to-connect-to-an-ms-access-database-on-visual-stud vote favorite I am facing "Unspecified error" in only one PC of my users. Run-time error '-2147467259 (80004005)': Unspecified error I am running the below VBA code to open a connection to Access database located in network shared drive. But the code throws the error whenever it is trying to run the .Open statement. I thought it is a driver issue and installed Access 2007 Database engine in http://stackoverflow.com/questions/31958994/unspecified-error-while-opening-an-adodb-connection the user's PC and replaced Provider with "Microsoft.ACE.OLEDB.12.0" but it doesn't work. Code: Dim cn As ADODB.Connection Dim rs As ADODB.Recordset Dim retVal As Boolean Dim strSQL As String retVal = False On Error GoTo CatchError Set cn = New ADODB.Connection With cn .Provider = "Microsoft.Jet.OLEDB.4.0" .Properties("Jet OLEDB:Database Password") = Initialize.GetDBPwd 'returns pass .Open Initialize.GetDbConnectionString 'returns the network DB path End With vba excel-vba access-vba adodb oledbconnection share|improve this question edited Dec 22 '15 at 2:21 ZygD 3,03991933 asked Aug 12 '15 at 7:43 tawfiq 212 Is the "network share drive" mapped in Windows? Is the share a Windows / SAMBA share? Do you have the proper permissions on this share and these permissions were entered when you mapped the share? Did you try to open it whith the Access Database on the local machine (for example C:\tmp)? –Ralph Aug 12 '15 at 9:26 3 What does Initialize.GetDbConnectionString return? –Excel Developers Aug 12 '15 at 9:54 What happens when you manually try and open that file from the users PC? It could be that the windows user doesn't have access. Is the path a UNC or a drive letter? –Nick.McDermaid Dec 22 '15 at 3:23 If it'
Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close https://www.experts-exchange.com/questions/24738100/Unspecified-error-when-performing-Add-Connection-for-MS-Access-in-Visual-Studio-2008.html Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Unspecified error when performing Add Connection for MS Access in Visual Studio 2008 Want to Advertise Here? Solved Unspecified error when performing Add Connection for MS Access in Visual Studio 2008 Posted on 2009-09-16 .NET Programming Editors IDEs MS Access 1 Verified Solution 5 Comments 1,034 Views Last Modified: 2013-11-26 When I try to unspecified error do an "Add Connection" to the Data Connections tree in Server Explorer to a MS Access database file (.mdb), I get a dialog box that displays "Unspecified error". This occurs when I click the Test Connection button and the OK button on the Add Connection dialog. The .mdb file was created using MS Access 2003 (11.8166.8221) SP3 on XP SP3. The development machine has MDAC 2.8 SP1 on Windows XP SP3 installed. VS.NET 2008 is unspecified error while version 9.0.21022.8 RTM with .NET Framework version 3.5 SP1 0 Question by:crickard62 Facebook Twitter LinkedIn Google Best Solution bycrickard62 I did a reinstall of VS.NET 2008 and that seems to have fixed it. Go to Solution 5 Comments LVL 27 Overall: Level 27 .NET Programming 19 Editors IDEs 6 MS Access 3 Message Expert Comment by:VBRocks2009-09-17 You know, I don't know the answer to that question, however, what provider are you using? OleDb or ODBC? You may try using OleDb. 0 Message Author Comment by:crickard622009-09-17 I tried both the .NET Framework Data Provider for ODBC as well as the .NET Framework Data Provider for OleDB. I'm going to try a reinstall. 0 LVL 27 Overall: Level 27 .NET Programming 19 Editors IDEs 6 MS Access 3 Message Expert Comment by:VBRocks2009-09-17 Well, before you do that, can you try connecting to it programatically? 0 Message Author Comment by:crickard622009-09-17 I can connect programatically. It just seem to want to connect in Visual Studio 2008. I'm stumped. 0 Message Accepted Solution by:crickard622009-09-21 I did a reinstall of VS.NET 2008 and that seems to have fixed it. 0 Write Comment First Name Please enter a first name Last Name Please enter a last name Email We will never share this with anyone. Comment Submit Your Comment By clicking you are agreeing to