locked
Connection String issue: Keyword not supported: 'data source'. RRS feed

  • Question

  • User-342393172 posted

    Hi

    could someone please help me with this issue,

    I have loaded my database to my web server, whenever i use a page with the database, it gives me this error message

    Connection String issue: Keyword not supported: 'data source'.

    this is the connection string in my web.cong file

    <connectionStrings>

    <clear /> 

     

     

    <remove name="ApplicationServices"/>

    <add name="ApplicationServices"

    connectionString="Data Source=tcp:serverName;

    Initial Catalog=databaseName;

    User ID=userName;Password=****;" providerName="System.Data.SqlClient"/>

     

     

     <remove name="SchoolEntities" />

     

     

    <add name="SchoolEntities"connectionString="DataSource=tcp:serverName;

    Initial Catalog=databaseName;ID=databaseLogin;Password=****;

    "providerName="System.Data.EntityClient"/> 

     

    </connectionStrings>

    Thursday, March 17, 2011 11:13 PM

All replies

  • User-1971614856 posted

    You are using wrong format for Connection String.

    Please follow the following format

     

    <connectionStrings>
        <add name="connString" connectionString="Data Source=tcp:serverName;database=databaseName;User Id=userid; PWD=password;"/>
      </connectionStrings>

    Friday, March 18, 2011 2:02 AM
  • User-342393172 posted

    thank you for your help, but that didn't solve the problem.

    Tuesday, March 22, 2011 11:26 PM