Using VWD with SQL 2000

[=?Utf-8?B?Smlt?=]

I currently have three new websites under development and all need ASP.NET
2.0 type functionality such as Membership and data access. I currently use
FrontPage 2003 as my preferred website development tool and am attempting to
use VWD Express 2005 to add ASP.NET 2.0 functions to these sites.
This has been an unqualified success in my development environment that
includes both SQL Server 2005 and SQL Server Express 2005 , but when I
attempt to deploy these websites to a production hosting environment that has
SQL Server 2000, none of the ASP.NET 2.0 functions work. I am being told that
this is because the default connection string generated by VWD supports SQL
server 2005 and SSE 2005 and not SQL Server 2000.
How do I override this default connection string and add a SQL Server 2000
connection string in the web.config file?
As you can obviously see, I am a novice at this and if I have asked the
above question incorrectly or you need more specifics, please just let me
know.
Thanks in advance.
Jim

[Juan T. Llibre]

re:
!How do I override this default connection string and add a SQL Server 2000
!connection string in the web.config file?

There's complete instructions on how to do that in this blog entry by Scott Guthrie:

http://weblogs.asp.net/scottgu/archi...25/423703.aspx


Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
===================================
"Jim" <Ji*@discussions.microsoft.comwrote in message
news:64**********************************@microsof t.com...

>I currently have three new websites under development and all need ASP.NET
2.0 type functionality such as Membership and data access. I currently use
FrontPage 2003 as my preferred website development tool and am attempting to
use VWD Express 2005 to add ASP.NET 2.0 functions to these sites.
This has been an unqualified success in my development environment that
includes both SQL Server 2005 and SQL Server Express 2005 , but when I
attempt to deploy these websites to a production hosting environment that has
SQL Server 2000, none of the ASP.NET 2.0 functions work. I am being told that
this is because the default connection string generated by VWD supports SQL
server 2005 and SSE 2005 and not SQL Server 2000.
How do I override this default connection string and add a SQL Server 2000
connection string in the web.config file?
As you can obviously see, I am a novice at this and if I have asked the
above question incorrectly or you need more specifics, please just let me
know.
Thanks in advance.
Jim

[=?Utf-8?B?Smlt?=]

Juan,
Thanks. This appears to be exactly what I was looking for.
Jim
--
FrontPage Web Developer
"Juan T. Llibre" wrote:

re:
!How do I override this default connection string and add a SQL Server 2000
!connection string in the web.config file?

There's complete instructions on how to do that in this blog entry by Scott Guthrie:

http://weblogs.asp.net/scottgu/archi...25/423703.aspx


Juan T. Llibre, asp.net MVP
asp.net faq : http://asp.net.do/faq/
foros de asp.net, en español : http://asp.net.do/foros/
===================================
"Jim" <Ji*@discussions.microsoft.comwrote in message
news:64**********************************@microsof t.com...

I currently have three new websites under development and all need ASP.NET
2.0 type functionality such as Membership and data access. I currently use
FrontPage 2003 as my preferred website development tool and am attempting to
use VWD Express 2005 to add ASP.NET 2.0 functions to these sites.
This has been an unqualified success in my development environment that
includes both SQL Server 2005 and SQL Server Express 2005 , but when I
attempt to deploy these websites to a production hosting environment that has
SQL Server 2000, none of the ASP.NET 2.0 functions work. I am being told that
this is because the default connection string generated by VWD supports SQL
server 2005 and SSE 2005 and not SQL Server 2000.
How do I override this default connection string and add a SQL Server 2000
connection string in the web.config file?
As you can obviously see, I am a novice at this and if I have asked the
above question incorrectly or you need more specifics, please just let me
know.
Thanks in advance.
Jim