Webconfig + SQL Server 2003
-
I tried using the Microsoft help, I am not really a decent programmer, the website we already have, is setup to function under an access database, we hired a SQL guy to bulid us the SQL tables we needed in SQL, trying to update the Webconfig to talk to the SQL server, I have failed at. Is what I have tried to get my website to talk to the sql Line 17: Line 18: Here is our old webconfig file talking to the access database: Can anyone tell me how to setup my webconfig file? So I can work on the SQL server? Using Visual Studio 2003, .NET 1.1
-
I tried using the Microsoft help, I am not really a decent programmer, the website we already have, is setup to function under an access database, we hired a SQL guy to bulid us the SQL tables we needed in SQL, trying to update the Webconfig to talk to the SQL server, I have failed at. Is what I have tried to get my website to talk to the sql Line 17: Line 18: Here is our old webconfig file talking to the access database: Can anyone tell me how to setup my webconfig file? So I can work on the SQL server? Using Visual Studio 2003, .NET 1.1
Ibuprofen wrote:
Webconfig + SQL Server 2003
AFAIK, There is no SQL Server 2003.
Ibuprofen wrote:
Line 17: Line 18:
If you are using .NET 1.1, there is no connectionstrings tag so you should probably use appSetting for connectionstring of SQL Example :
<appSettings> <add key="DIMHRSDataCon" value='Server=HOODNBOTC458827;Database=DIMHRS;Trusted_Connection=Yes;'/> </appSettings>Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net) "Please vote to let me (and others) know if this answer helped you or not. A 5 vote tells people that your question has been answered successfully and that I've pitched it at just the right level. Thanks."
-
Ibuprofen wrote:
Webconfig + SQL Server 2003
AFAIK, There is no SQL Server 2003.
Ibuprofen wrote:
Line 17: Line 18:
If you are using .NET 1.1, there is no connectionstrings tag so you should probably use appSetting for connectionstring of SQL Example :
<appSettings> <add key="DIMHRSDataCon" value='Server=HOODNBOTC458827;Database=DIMHRS;Trusted_Connection=Yes;'/> </appSettings>Thanks and Regards, Michael Sync ( Blog: http://michaelsync.net) "Please vote to let me (and others) know if this answer helped you or not. A 5 vote tells people that your question has been answered successfully and that I've pitched it at just the right level. Thanks."