locked
Connection String for Access Database using a Web Service RRS feed

  • Question

  • User112400174 posted

    Hi


    I need a connection string to connect the microsoft 2003 database with my ASP.NET webservice

    When just making a website I used to use the following connection statement

    OleDbConnection dbconn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; data source=" +  + Server.MapPath("~/db/SalesCentral.mdb"));


    Now as I am using a webservice the Server.MapPath function is giving an error


    Please suggest an alternative


    Thanks


    Shray

    Friday, July 30, 2010 4:09 PM

Answers

  • User-366246501 posted

    Find this:-

     

    <connectionStrings>
        <
    remove name="LocalSqlServer"
    />
        <
    add name="LocalSqlServer" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient"
    />
        <add name="MainConnStr" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|main.mdf;User Instance=true" providerName="System.Data.SqlClient"/>
    </connectionStrings>

    connectionStrings>
        <
    remove name="LocalSqlServer"
    />
        <
    add name="LocalSqlServer" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient"
    />
        <add name="MainConnStr" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|main.mdf;User Instance=true" providerName="System.Data.SqlClient"/>
    </connectionStrings>

    You can reference this directly from code using:

    [C#]
    string connStr = ConfigurationManager.ConnectionStrings["MainConnStr"].ConnectionString;

    [VB]
    Dim connStr As String = ConfigurationManager.ConnectionStrings("MainConnStr").ConnectionString

    Note that the namespace for this is System.Configuration so for a console application the full namespace is required.


    Or you can reference this declaratively within the ConnectionString property of a SqlDataSource:

    <asp:SqlDataSource ID="SqlDataSource1" runat="server"
      ConnectionString="<%$ ConnectionStrings:MainConnStr %>"
      SelectCommand="SELECT [au_id], [au_lname], [au_fname], [state] FROM [authors]"
    />

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, July 30, 2010 4:39 PM

All replies

  • User-2010311731 posted

    Server.MapPath should work.  Could you post the error you are getting?

    I notice there is an extra + (plus) sign just before the Server.MapPath call.

    Friday, July 30, 2010 4:31 PM
  • User-366246501 posted

    You can create this tab in webconfig of your project then you can use it

    connectionStrings>add name="ConnectionString" connectionString="Data Source=ABCD;Initial Catalog=abc;Persist Security Info=True;User ID=abc;Password=abc" providerName="System.Data.SqlClient"/>connectionStrings>

    then you can use on page

    string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

    hope you are looking for this thing..

    Friday, July 30, 2010 4:34 PM
  • User-366246501 posted

    Find this:-

     

    <connectionStrings>
        <
    remove name="LocalSqlServer"
    />
        <
    add name="LocalSqlServer" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient"
    />
        <add name="MainConnStr" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|main.mdf;User Instance=true" providerName="System.Data.SqlClient"/>
    </connectionStrings>

    connectionStrings>
        <
    remove name="LocalSqlServer"
    />
        <
    add name="LocalSqlServer" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient"
    />
        <add name="MainConnStr" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|main.mdf;User Instance=true" providerName="System.Data.SqlClient"/>
    </connectionStrings>

    You can reference this directly from code using:

    [C#]
    string connStr = ConfigurationManager.ConnectionStrings["MainConnStr"].ConnectionString;

    [VB]
    Dim connStr As String = ConfigurationManager.ConnectionStrings("MainConnStr").ConnectionString

    Note that the namespace for this is System.Configuration so for a console application the full namespace is required.


    Or you can reference this declaratively within the ConnectionString property of a SqlDataSource:

    <asp:SqlDataSource ID="SqlDataSource1" runat="server"
      ConnectionString="<%$ ConnectionStrings:MainConnStr %>"
      SelectCommand="SELECT [au_id], [au_lname], [au_fname], [state] FROM [authors]"
    />

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Friday, July 30, 2010 4:39 PM
  • User-1199946673 posted

     Did you make sure the database cannot directy be downloaded when someone enters

    http://www.yourdomain.com/db/SalesCentral.mdb

    To prevent this, you better place the database in the App_Data folder. If you do, the Connectionstring will be:

    "Provider=Microsoft.Jet.OLEDB.4.0; data source=|DataDirectory|SalesCentral.mdb"

    Friday, July 30, 2010 7:40 PM