473,320 Members | 1,910 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

must I upgrade asp.net to 2.0 to access SQL 2005?

HK
I have ASP.NET 1.1 websites. They will need to access a SQL 2005 database.
Do I have to upgrade the whole web projects to ASP.NET 2.0 in order for them
to access SQL 2005? If so, anyone have any good URLs for upgrading 1.1
websites to 2.0? I'm really worried about crashing the current websites if
I do a quick conversion to 2.0, but I don't have much time before needing to
access SQL 2005.
Mar 4 '06 #1
6 1192

"HK" <re**************@notreal.com> wrote in message
news:zX*************@tornado.socal.rr.com...
I have ASP.NET 1.1 websites. They will need to access a SQL 2005 database.
Do I have to upgrade the whole web projects to ASP.NET 2.0 in order for
them
to access SQL 2005? . . .


No. .NET 1.1 Apps of all kinds can access SQL Server 2005.

David


Mar 4 '06 #2
Write a little app in asp.net 1.1 (vs 2003) to test to see if you can log
into the 2005 DB... I do believe I at one point had 1.1 apps accessing
sql2005, but that was for a short time.

Whatever you do, DO NOT convert your web sites to vs2005 in a hurry, MS did
an awful job on asp.net web site updates. Web project conversions need to
be well-planned, and you may need to correct/prepare your projects for
conversion before you even try to convert.

There are some docs that outline the conversion process, you may need to
re-arrange your projects, and there is also an updated conversion tool that
does not come with VS2005 (search for all of these on the web). If you have
things like a web project referencing assemblies on another web project, and
some other stuff like that will break the upgrade. Take your time on
upgrading non-trivial projects.

Your much better off getting your 1.1 web sites logging into sql2005...
"HK" <re**************@notreal.com> wrote in message
news:zX*************@tornado.socal.rr.com...
I have ASP.NET 1.1 websites. They will need to access a SQL 2005 database.
Do I have to upgrade the whole web projects to ASP.NET 2.0 in order for
them
to access SQL 2005? If so, anyone have any good URLs for upgrading 1.1
websites to 2.0? I'm really worried about crashing the current websites
if
I do a quick conversion to 2.0, but I don't have much time before needing
to
access SQL 2005.

Mar 4 '06 #3
JT
ASP.NET doesn't access SQL Server; but rather it interfaces with ADO.NET,
which is a wrapper for the OLEDB Provider, which accesses the database. You
will probably need to download the latest version of MDAC (Microsoft Data
Access Components).
http://www.microsoft.com/downloads/d...displaylang=en
For the most common cases, the DSN will be similar to that for connecting to
SQL Server 2000.
http://www.connectionstrings.com/

"HK" <re**************@notreal.com> wrote in message
news:zX*************@tornado.socal.rr.com...
I have ASP.NET 1.1 websites. They will need to access a SQL 2005 database.
Do I have to upgrade the whole web projects to ASP.NET 2.0 in order for
them
to access SQL 2005? If so, anyone have any good URLs for upgrading 1.1
websites to 2.0? I'm really worried about crashing the current websites
if
I do a quick conversion to 2.0, but I don't have much time before needing
to
access SQL 2005.

Mar 4 '06 #4
Absolutely do not "upgrade" to ASP.Net 2.0 without doing some major level of
reading. MS has completely cocked this up and in some very important
respects ASP.Net 2.0 may as well be from mars.

Lenny
"HK" <re**************@notreal.com> wrote in message
news:zX*************@tornado.socal.rr.com...
I have ASP.NET 1.1 websites. They will need to access a SQL 2005 database.
Do I have to upgrade the whole web projects to ASP.NET 2.0 in order for
them
to access SQL 2005? If so, anyone have any good URLs for upgrading 1.1
websites to 2.0? I'm really worried about crashing the current websites
if
I do a quick conversion to 2.0, but I don't have much time before needing
to
access SQL 2005.

Mar 4 '06 #5

"JT" <so*****@microsoft.com> wrote in message
news:eS**************@TK2MSFTNGP15.phx.gbl...
ASP.NET doesn't access SQL Server; but rather it interfaces with ADO.NET,
which is a wrapper for the OLEDB Provider, which accesses the database.
You will probably need to download the latest version of MDAC (Microsoft
Data Access Components).
http://www.microsoft.com/downloads/d...displaylang=en
For the most common cases, the DSN will be similar to that for connecting
to SQL Server 2000.
http://www.connectionstrings.com/


Although accessing SQL through OleDB is possible, the .NET SqlClient is the
preferred method, and doesn't use any of the MDAC components.

And a DSN is only for ODBC.

David
Mar 4 '06 #6
JT
Meant to say connection string instead of DSN.

"David Browne" <davidbaxterbrowne no potted me**@hotmail.com> wrote in
message news:uX**************@TK2MSFTNGP15.phx.gbl...

"JT" <so*****@microsoft.com> wrote in message
news:eS**************@TK2MSFTNGP15.phx.gbl...
ASP.NET doesn't access SQL Server; but rather it interfaces with ADO.NET,
which is a wrapper for the OLEDB Provider, which accesses the database.
You will probably need to download the latest version of MDAC (Microsoft
Data Access Components).
http://www.microsoft.com/downloads/d...displaylang=en
For the most common cases, the DSN will be similar to that for connecting
to SQL Server 2000.
http://www.connectionstrings.com/


Although accessing SQL through OleDB is possible, the .NET SqlClient is
the preferred method, and doesn't use any of the MDAC components.

And a DSN is only for ODBC.

David

Mar 4 '06 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Paul | last post by:
I have the CDs for version 10.1 Enterprise Edition and have successfully installed them. I want to upgrade to 10.2. When I bought the CDs the people at Oracle said it was just a patch to upgrade to...
2
by: KR | last post by:
Hi, We are running a test upgrade form sql 2000 standard edition to sql 2005 developer edition. Followed through all the steps and specified the account(SA priveleges and currently used by the...
2
by: Paul | last post by:
I have the CDs for version 10.1 Enterprise Edition and have successfully installed them. I want to upgrade to 10.2. When I bought the CDs the people at Oracle said it was just a patch to upgrade to...
24
by: joeldault | last post by:
Question For Microsoft Access Data Base -------------------------------------------------------------------------------- I am Trying to create a single formula that would do the following: If...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.