Click here to Skip to main content
11,790,816 members (58,583 online)
Rate this: bad
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 4:33am
Edited 1-Apr-13 5:24am
ThePhantomUpvoter at 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 at 1-Apr-13 11:24am
Data Source=*****
This has valid value, right?
Thomas Morris at 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
0 OriginalGriff 385
1 ppolymorphe 339
2 Richard MacCutchan 118
3 Maciej Los 70
4 George Swan 70
0 OriginalGriff 1,154
1 Maciej Los 825
2 KrunalRohit 686
3 ppolymorphe 660
4 CPallini 621

Advertise | Privacy | Mobile
Web01 | 2.8.1509028.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