Webservice connectionstring problem

Question

0.00/5 (No votes)

See more:

WebService Connectionstring Error

am create a webservice(.asmx) used to insert string data to a sql server 2008 database...
am publish webservice and host in to local IIS Server..its perfectly working. but am hosted on internet server(windows sever), getting an error with connectionsring Connection string property could not be initialised...this is the connectionstring

<connectionstrings>
    <add name="DatabaseConnectionString1" connectionstring="Data Source=*****;AttachDbFilename=databasename;Integrated Security=False;User Id=username; Password=password;" providername="System.Data.SqlClient" />
  </connectionstrings>

whats the actual error...

Posted 1-Apr-13 4:33am

Abdul Manaf C J

Updated 1-Apr-13 5:24am

Sandeep Mewara

v2

Add a Solution

Comments

[no name] 1-Apr-13 10:36am

Well obviously because your connection string is blank. That error is most likely not a problem with the connection string but your application cant find it. But that is just a guess since you did not post the code like you were asked to.

Sandeep Mewara 1-Apr-13 11:24am

Data Source=*****
This has valid value, right?

Thomas Morris 1-Apr-13 11:27am

Are you connecting to SQL server or a database file?

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)

Kuthuparakkal · Answer 1 · 2013-04-01T16:06:00

Solution 1

Seems like attachdbfilename issue if you are not using Sql Express.
SQL conn should go like this:

"Data Source=DatabaseServer;Initial Catalog=Northwind;User ID=YourUserID;Password=YourPassword"

Please try in this direction

Posted 1-Apr-13 16:06pm

Kuthuparakkal