DSN in connection string

Question

0.00/5 (No votes)

See more:

my DSN name is PCG

i have created DSN but dont know how to use it in code:

C#

OleDbConnection con = new OleDbConnection(ConfigurationManager.ConnectionStrings["dbconnection"].ToString());

and in web config

XML

<connectionStrings>
        <add name="dbconnection" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\Amir\Desktop\aaaa\aftrsachinchange\amirPCG29-4-2013\App_Data\DatabasePCG03.mdb;Persist Security Info=True" providerName="System.Data.OleDb"/>

Posted 4-May-13 0:50am

Amirsalgar1

Updated 4-May-13 0:53am

v3

Add a Solution

Comments

Sandeep Mewara 4-May-13 6:53am

created DSN but dont know how to use it in
I see you are using defined connection string. What is the issue?

Amirsalgar1 4-May-13 6:57am

should i host it now?

Amirsalgar1 4-May-13 6:57am

is their any need to use the dsn path ?

Amirsalgar1 4-May-13 6:59am

sir ,
i am hosting website first .. please suggest me thanks in adv :)

[no name] 4-May-13 7:28am

First thing you need to do is figure out what it is that you want to do. I do not see any DSN anywhere in the code that you have written.
"should i host it now?", what is it that you think you are hosting? Where?
"i am hosting website first", if you are hosting the website then why are you asking if you should host it?
"please suggest me", suggest what? You have not asked a question or described any kind of a problem.

Amirsalgar1 4-May-13 8:13am

sir ,i have created dsn from control panel -admin tool - Data Sources (ODBC)- i had created DSN as PCG
but is it sufficient ?
or should i to write the DSN name in connection string?
my connection string as above

1 solution

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)

Thanks7872 · Answer 1 · 2013-05-04T01:25:00

Solution 1

Refer to this link.You can have some idea how to do that.

Posted 4-May-13 1:25am

Thanks7872