locked
sql 2k5 connection string RRS feed

  • Question

  • User1851275999 posted
    Is there anywhere other than the web.config that needs to be updated for the connection string? I want to attach the time tracker mdf to sql 2k5 instead of using mysql. I will have sql on the same server as the host for time tracker if anyone has any other info that may help. Thanks!
    Thursday, March 5, 2009 11:18 PM

All replies

  • User97111691 posted

    you can use web.config for any kind f connection string, provided you give the right kind of conenction string with the driver details,server name etc

    Friday, March 6, 2009 2:07 AM
  • User-23948518 posted

    No, Webconfig is the only place that ConnectionString needs to be defined in the Timetracker starter kit.

     I know this because I have just done a search through all the sourcecode for a working version.

    There is some logic in the DAL layer that links it to this line as well:

    <add key="aspnet_starterKits_TimeTracker_DataAccessLayerType" value= "ASPNET.StarterKit.DataAccessLayer.SQLDataAccess" />

    so if you get that line wrong, then that would cause the application to not connect with the database also. (guessing).

    HTH.

    Saturday, March 7, 2009 12:02 AM
  • User555306248 posted

    No, there is not other place

    It you set/update the connection string in web.config it will automatically reflect all application. Because application read it from web.config itself

    Sunday, March 8, 2009 11:23 PM
  • User1851275999 posted

    Updating just that line worked great for me...

    I was having trouble with the connection string but i just added the database to sql and then to my project and the connection string was in the properties menu.

     

    Thanks!

    Wednesday, March 11, 2009 12:49 PM
  • User555306248 posted

    Please mark the answer that helps you, so it will help for other people

    Thursday, March 12, 2009 11:18 PM
  • User-315290001 posted

    i thought it was working but guess not, here is my problem

    ////////////////////////////////////

    HELP ME PLEASE SOME ONE FOR GODSAKES!

     Error message

    ConnectionString configuration is missing from you web.config. It should contain  <connectionStrings> <add key="aspnet_staterKits_TimeTracker" value="Server=(local);Integrated Security=True;Database=Issue_Tracker" </connectionStrings> from the \App_Code\DAL\DataAccess.vb line 24

     

     //////////////////////////////////////////

     I know i am close but something is a miss HELP!

            <add name="MyConnectionString" connectionString="Server= web ; Database=web9; User ID=w09; Password=Reggi; trusted_connection=False"
            providerName="System.Data.SqlClient"/>
            <remove name="LocalSqlServer" />
            <add name="LocalSqlServer" connectionString="Server= web ; Database=web9; User ID=w09; Password=Reggi; trusted_connection=False"
            providerName="System.Data.SqlClient"/>
      

    //////////////////////


    I have no idea what to do with this code

     web config doesnt like "key"

    "<add key="aspnet_starterKits_TimeTracker_DataAccessLayerType" value= "ASPNET.StarterKit.DataAccessLayer.SQLDataAccess" /> "

     

    can anyone help

    Friday, March 20, 2009 12:48 AM
  • User555306248 posted

    There are 2 web.config in Time Tracker Syatem

    Have you configure both according your server

    Sunday, March 22, 2009 11:27 PM