Click here to Skip to main content
Rate this: bad
good
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
<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 5:33am
Edited 1-Apr-13 6:24am
v2
Comments
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
good
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
  Permalink  

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

  Print Answers RSS
0 OriginalGriff 230
1 PIEBALDconsult 150
2 DamithSL 125
3 BillWoodruff 108
4 Garth J Lancaster 90
0 OriginalGriff 5,790
1 DamithSL 4,601
2 Maciej Los 4,012
3 Kornfeld Eliyahu Peter 3,480
4 Sergey Alexandrovich Kryukov 3,195


Advertise | Privacy | Mobile
Web01 | 2.8.141220.1 | Last Updated 1 Apr 2013
Copyright © CodeProject, 1999-2014
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