SQL connection string

Question

0.00/5 (No votes)

See more:

.NET3.5

Hello all,
In my web application I have to load mdb file into SQL database.For that i used following provider with connection string

con.Open("Provider=SQLOLEDB.1;" & System.Configuration.ConfigurationManager.AppSettings("strConString"))

it works good when i run application with Microsoft Visual Studio 2008 Development Environment.But when i make web setup of an application it gives error on same line.

how to solve this problem???

Posted 9-Apr-12 0:46am

YOGESH DHAGE

Updated 9-Apr-12 0:55am

sravani.v

v2

Add a Solution

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)

OriginalGriff · Answer 1 · 2012-04-09T00:56:00

Solution 1

Did you change the web.config file to reflect the actual location of the file on the web host?
I'd start by checking there.

Posted 9-Apr-12 0:56am

OriginalGriff

Comments

YOGESH DHAGE 9-Apr-12 7:04am

No friend no change in web.config file.I keep its as it is in web application folder

OriginalGriff 9-Apr-12 7:16am

What is the web.config connection string set to?

YOGESH DHAGE 10-Apr-12 5:25am

OriginalGriff 10-Apr-12 5:44am

Yes?