i'm attempting deploy first website containing database. test local version has following connection strings
<connectionstrings> <add name="applicationservices" connectionstring="data source=.\sqlexpress;integratedsecurity=sspi; attachdbfilename=|datadirectory|\aspnetdb.mdf; user instance=true" providername="system.data.sqlclient" /> <add name="connectionstring" connectionstring="data source=(localdb)\v11.0;attachdbfilename=|datadirectory|\ahdata.mdf;integratedsecurity=true" providername="system.data.sqlclient" /> </connectionstrings> i've setup databases on web hosting company server , give me following connections strings
provider=sqloledb;data source=db479427514.db.1and1.com,1433;initial catalog=db479427514;user id=dbo479427514;password=****; provider=sqloledb;data source=db479427535.db.1and1.com,1433;initial catalog=db479427535;user id=dbo479427535;password=****; when replace local test connection strings new server ones using
<connectionstrings> <add name="applicationservices" connectionstring="provider=sqloledb;data source=db479427535.db.1and1.com,1433;initial catalog=db479427535;user id=dbo479427535;password=**i've used real password!**;" providername="system.data.sqlclient" /> <add name="connectionstring" connectionstring="provider=sqloledb;data source=db479427514.db.1and1.com,1433;initial catalog=db479427514;user id=dbo479427514;password=**i've used real password!**;" providername="system.data.sqlclient" /> </connectionstrings> i following error
keyword not supported: 'provider'.
description: unhandled exception occurred during execution of current web request. please review stack trace more information error , originated in code.
exception details: system.argumentexception: keyword not supported: 'provider'.
source error:
an unhandled exception generated during execution of current web request. information regarding origin , location of exception can identified using exception stack trace below.
[argumentexception: keyword not supported: 'provider'.]
[argumentexception: error occurred while attempting initialize system.data.sqlclient.sqlconnection object. value provided connection string may wrong, or may contain invalid syntax.
parameter name: connectionstring]
can advise wrong here?
try removing 'provider' section of connection string:
<add name="applicationservices" connectionstring="provider=sqloledb;data source=db479427535.db.1and1.com,1433;initial catalog=db479427535; user id=dbo479427535;password=**i've used real password!**;" providername="system.data.sqlclient" /> becomes
<add name="applicationservices" connectionstring="data source=db479427535.db.1and1.com,1433;initial catalog=db479427535;user id=dbo479427535;password=**i've used real password!**;" providername="system.data.sqlclient" /> because provider name specified in it's own name-value pair (providername=) doubt needed in connection string. give crack , report back.
Comments
Post a Comment