sql 2k5 connection string

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!

Answer 1

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

Answer 2

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.

Answer 3

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

Answer 4

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!

Answer 5

User555306248 posted

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

Answer 6

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

Answer 7

User555306248 posted

There are 2 web.config in Time Tracker Syatem

Have you configure both according your server