Click here to Skip to main content
15,848,930 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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
    <add name="DatabaseConnectionString1" connectionstring="Data Source=*****;AttachDbFilename=databasename;Integrated Security=False;User Id=username; Password=password;" providername="System.Data.SqlClient" />

whats the actual error...
Updated 1-Apr-13 6:24am
[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

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
Share this answer

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

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900