How to connect to an Access database via web.config

Question

0.00/5 (No votes)

See more:

Hi,

Can anybody tell me how to connect to a database using the web.config file. I'm using Access. I want to check for username and password in the database. I'm unable to connect to the database through web.config using VB.NET.

VB.NET

//in vb.net

 Dim connStr As String = ConfigurationManager.ConnectionStrings("MainConnStr").ConnectionString

 sqlcom = New OleDbCommand("select * FROM registered_customers WHERE login_name= '" & userName & "'  AND pword='" & password & "'", connstr)

XML

//in web.config   
<removed name="LocalSqlServer&quot" />
   <removed name="LocalSqlServer" connectionsting="Data Source=E:\Anil\kank.mdb;User Instance=true" providername="Microsoft.Jet.OLEDB.4.0">

Error: value of type string cannot be converted to system.data.oledb.oledbconnection

How should I change the connectionstring to open the connection?

Posted 9-Apr-10 2:17am

Anil Sarda

Updated 9-Apr-10 2:26am

Nish Nishant

v2

Add a Solution

4 solutions

Solution 4

Of course, only the worst possible code would put that in the code behind and not in a seperate data layer.

Posted 25-Apr-10 21:45pm

Christian Graus

Solution 3

yes i got it, Connection To Database: Using Web>config(VB)
just im adding answer as it might help someone

in web.config

XML

<connectionStrings>
   <add name="MainConnStr" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\vana\Anil\kan.mdb;"/>
  </connectionStrings>

and in .aspx.vb

strconnection = New OleDbConnection(ConfigurationManager.ConnectionStrings("MainConnStr").ConnectionString)
strconnection.Open()

Posted 25-Apr-10 21:40pm

Anil Sarda

Updated 25-Apr-10 21:44pm

v3

Solution 1

This might help you to figure it out: ConnectionStrings.com[^].

Posted 9-Apr-10 2:44am

R. Giskard Reventlov

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

9852932254 · Accepted Answer · 2010-04-09T17:43:00

in code behind page
// For C#
OleDbConnection con = new OleDbConnection(ConfigurationManager.ConnectionStrings[sa1].ConnectionString);
con.Open();

in web.config
<connectionStrings>
<add name=sa1 connectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\\a\\Database1.mdb" providerName="System.Data.OleDb">
<connectionStrings>