Solved

Need example of web.config ConnectionString for Access mdb

Posted on 2006-06-12
6
1,777 Views
Last Modified: 2008-01-16
Hello - I'm trying to set up an Object Data Source against an Access (2003) mdb; I've tried:
  <connectionStrings>
    <add name="AppConStr1" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\MyProject\App_Data\MyMDB.mdb;" />
  </connectionStrings>

and got an error message about the "Provider" argument.

Could somebody post an example with the right yik-yak words, please?

Thanks

Mark
0
Comment
Question by:mlagrange
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 5

Expert Comment

by:Jojo1771
ID: 16891347
A good site for connection strings. One of my favs.

http://www.connectionstrings.com/
0
 
LVL 27

Assisted Solution

by:Sammy
Sammy earned 166 total points
ID: 16892203
You need to have your DB in App_Data directory

<connectionStrings>
  <add name="MyConnectionString"
    connectionString="Provider=Microsoft.Jet.OLEDB.4.0;
      Data Source=|DataDirectory|MyDB.mdb"
    providerName="System.Data.OleDb" />
</connectionStrings>

to retrieve it
Dim strConnString As String = ConfigurationManager.ConnectionStrings("MyConnectionString").ConnectionString

HTH
0
 
LVL 7

Assisted Solution

by:pradeepsudharsan
pradeepsudharsan earned 166 total points
ID: 16892512
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:mlagrange
ID: 16893578
Thanks jojo1771, but that's essentially what I had before; I got the same error:
Keyword not supported: 'provider'.

Thanks Sammy1971, but that got a different error message:
Format of the initialization string does not conform to specification starting at index 0.

Both of these error messages point to the line:
Dim cmd As SqlCommand = New SqlCommand(sel, New SqlConnection(GetConnectionString))

I took a wild quess and added a line in the class code for "Imports System.Data.OleDb", but no help.

I'm using code examples that are going against a SQL Server database; obviously, something in these examples is not appropriate for going against an Access database. Here's the whole thing...

In my web.config:

<connectionStrings>
      <remove name="AccessFileName"/>
      <add name="AccessFileName" connectionString="~/App_Data/MyMDB.mdb" providerName="System.Data.OleDb"/>
</connectionStrings>
 

In my Object Data Source class code:

Imports Microsoft.VisualBasic
Imports System.ComponentModel
Imports System.Data
Imports System.Data.SqlClient
Imports System.Data.OleDb

Public Class clsCensusData

    <DataObjectMethod(DataObjectMethodType.Select)> _
    Public Shared Function TestCensusDataList() As IEnumerable
        Dim sel As String = "SELECT * FROM tblCensusData ORDER BY EmpName"
        Dim cmd As SqlCommand = New SqlCommand(sel, New SqlConnection(GetConnectionString))
        cmd.Connection.Open()
        Dim rdr As SqlDataReader = cmd.ExecuteReader(CommandBehavior.CloseConnection)
        Return rdr
    End Function

    Private Shared Function GetConnectionString() As String
        Return ConfigurationManager.ConnectionStrings("AccessFileName").ConnectionString
    End Function

End Class

Thanks again for all your responses
0
 
LVL 5

Accepted Solution

by:
Jojo1771 earned 168 total points
ID: 16899411
Are you running 2.0?
 If so I would use admin web site to setup your config stuff. A web based GUI for the web config.

To be honest I only use SQL, so Im not going to be much help. Maybe theres somthing in this doc that can give you some help.

http://www.codeproject.com/cs/database/Connection_Strings.asp
0
 

Author Comment

by:mlagrange
ID: 16929625
Thanks for all your suggestions. I have since realized:

1) The data retrieval command yik-yak would have to be OleDB yik-yak, not SQL yik-yak, and I can't find any examples of that out there (the things you pointed me to might start out with connnection strings for mdb's, but no related command statements for going against an mdb)  

2) I was trying to postpone the inevitable by using an Access mdb "for prototyping"; I need to swim out of the shallow end of Access and into the deep end of SQL Server

Thanks again for your responses  
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
asp.net web application 3 44
exporting html table data 4 38
Please explain purpose of GZIP 4 57
Adding items to a C# list incrementally 5 58
Today is the age of broadband.  More and more people are going this route determined to experience the web and it’s multitude of services as quickly and painlessly as possible. Coupled with the move to broadband, people are experiencing the web via …
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question