Click here to Skip to main content
11,934,389 members (40,616 online)
Rate this:
Please Sign up or sign in to vote.
See more: WebService hosting
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...
Posted 1-Apr-13 5:33am
Edited 1-Apr-13 6:24am
ThePhantomUpvoter 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

Rate this: bad
Please Sign up or sign in to vote.

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

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

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web01 | 2.8.151126.1 | Last Updated 1 Apr 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100