>>>
>>>So, I'll post another thread in SQL Server forum in a sec., but just in case, how can I use two connection strings to switch between development/local?
>>>
>>>The connection string is in web.config
>>>
>>
>>
>>I just have them all in config.web and comment out the ones I'm not using like this...
>>
>>
>> <!-- TEST - SQL2005
<add key="SqlConnectionString" value="MyConnectionStringTEST"/>
-->
>>
>> <!-- DEBUG - SQL2005
<add key="SqlConnectionString" value="MyConnectionStringDEBUG"/>
-->
>>
>> <!-- DEV - SQL2005
<add key="SqlConnectionString" value="MyConnectionStringDEV"/>
-->
>>
>> <!-- Local DB SQL 2K
<add key="SqlConnectionString" value="MyConnectionStringLOCAL2K"/>
-->
>>
>> <!-- Local DB SQL 2005 -->
>> <add key="SqlConnectionString" value="MyConnectionStringTESTLOCAL2005"/>
>>
>>
>>
>>Bruce
>
>Thanks a lot. Since I'm so dumb that I can not even add a user, I specified Windows Authentication for now for my local tests and got pass the first stage. Now at least I can start testing...
You are welcome. It is frustrating when there is so much new to learn. I told a co-worker yesterday, "I am learning so much new stuff, I'm amazed that my head just doesn't explode!". I have the advantage of doing maintenance on an existing app, but I am afraid I am learning many NOT best-practices. We are re-writing it one piece at a time and doing a lot of refactoring.