 |  |  |  |  |  |  |  |
DB Provider
Please support our C# advertiser: Intel Parallel Studio Home
 |
•
•
Join Date: Mar 2007
Posts: 68
Reputation: 
Solved Threads: 0
Junior Poster in Training
I am trying to use an existing access db file with my c# app. When I try to connect, it says that:
"The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine."
How do I register it/install it/whatever it is I need to do to make it work?
Thanks.
I have Visual Studio 2008 with SQL Server 2005 Express installed if that helps.
"The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine."
How do I register it/install it/whatever it is I need to do to make it work?
Thanks.
I have Visual Studio 2008 with SQL Server 2005 Express installed if that helps.
•
•
Join Date: Mar 2007
Posts: 68
Reputation:
Solved Threads: 0
Junior Poster in Training
You realize that the connection string format is not the issue right? I know how to format the string, it just can't find the provider.
Um...
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
Or in the case of one system I work on:
Data Source=HQNVSQL07;Initial Catalog=dxBugsDb;User Id=******;Password=******;
This is of course using System.Data.SqlClient.SqlConnection objects.
example:
As you can see, if it's SQL Server then you don't need a Provider.
Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;
Or in the case of one system I work on:
Data Source=HQNVSQL07;Initial Catalog=dxBugsDb;User Id=******;Password=******;
This is of course using System.Data.SqlClient.SqlConnection objects.
example:
C# Syntax (Toggle Plain Text)
As you can see, if it's SQL Server then you don't need a Provider.
Last edited by nvmobius; Aug 12th, 2008 at 3:41 am. Reason: Added sample code
|
Similar Threads
- Problem with Provider Management in ASP.NET 2.0 (ASP.NET)
- Looking for sub domain provider! (Site Layout and Usability)
- Error Type:Provider (0x80004005) (ASP)
- The 'Migrosoft.Jet.OLEDB.4.0' provider is not registered on the local machine (VB.NET)
- Microsoft OLE DB Provider for ODBC Drivers error '80040e14' (ASP)
- List Of Free PHP,MYSQL Webhosting Provider (PHP)
Other Threads in the C# Forum
- Previous Thread: SpliterContainer + C#
- Next Thread: Inserting multiple records using DataGridView using C#
Views: 793 | Replies: 3
| Thread Tools | Search this Thread |
Latest C# Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for C#
.net access ado.net algorithm array bitmap box broadcast buttons c# chat check checkbox class client color combobox control conversion csharp custom database datagrid datagridview dataset datetime degrees development draganddrop drawing encryption enum event excel file files form format forms function gdi+ httpwebrequest image index input install java label list listbox listener login mandelbrot math mouseclick mysql networking object operator oracle path photoshop picturebox pixelinversion post prime programming radians regex remote remoting resource richtextbox save saving serialization server sleep socket sql statistics stream string table tcp text textbox thread time timer treeview update usercontrol validation visualstudio webbrowser windows winforms wpf xml
