ASP.Net application developed using SQL Server 2000 can't use SQL Server 2005

Hi,

If an application written in ASP.Net that uses SQL Server 2000 can have certain features that will not work on SQL Server 2005?

There is an application written in ASP.Net with SQL Server 2000 which I need to convert to SQL Server 2005 but the original developer says it uses certain SQL Server 2000 specific features and won't work directly on SQL Server 2005 without modifying code. Are there any such features?

 

Thanks
 

0
TechMan
6/2/2008 6:31:00 AM
asp.net.sql-datasource 29906 articles. 0 followers. Follow

4 Replies
1016 Views

Similar Articles

[PageSpeed] 43

According to the official "Discontinued Database Engine Functionality In SQL Server 2005"-document on MSDN, the only Transact-SQL statement that has been removed is the "*=" and "=*" operators for implicit outer joins.

Please look at the link above to see if there are other functionalities that you use and that are discontinued with SQL Server 2005.


If this answered your question, be sure to mark it as the answer. Then you give credit to people who help you, and others will know that the question is already answered.
My SQL Server blog (swedish): http://www.underlandet.com/SqlServer
0
BlogPortalist
6/2/2008 8:18:31 AM

thanks....i will look into it 

0
TechMan
6/2/2008 8:32:52 AM

If you have "*="-operators in your T-SQL-code, it's an indication that your application is pretty old, probably not developed for SQL Server 2000, as it has been on the deprecation list for quite a while. I think it was in version 6.5 that "*=" was last a "current" feature. If you have it in your T-SQL-code, it's time for a rewrite anyway Smile


If this answered your question, be sure to mark it as the answer. Then you give credit to people who help you, and others will know that the question is already answered.
My SQL Server blog (swedish): http://www.underlandet.com/SqlServer
0
BlogPortalist
6/2/2008 8:44:32 AM

It is so quick and easy to convert from SQL2000 to 2005 that you should just try it and see if it works, assuming you have access to SQL Management Studio.

You could probably just attach the database file and be up and running just like that. If it refuses, well, you know where you stand.

 

Or is it maybe an Access .ADP project, where the front end was Access and the data store was MSDE (SQL2000) instead of Jet?


If a post helps to solve your problem, please click the Answer button on that post.

I'm still confused, but now I'm confused on a higher plane.
0
LockH
6/2/2008 8:06:26 PM
Reply:

Similar Artilces:

This version of Microsoft Sql Server Management Studio can only be used to connect to Sql Server 2000 and Sql Server 2005 servers
When I connect SQL Server 2005 to a remote database i get the error: "This version of Microsoft Sql Server Management Studio can only be used to connect to Sql Server 2000 and Sql Server 2005 servers". Can I confirm it is because: the remote db is of SQL Server 2008? There is a soln mentioned in http://forums.asp.net/t/1324047.aspx Did anybody try this (installing 2008 express: http://www.microsoft.com/express/sql/download/)? I am just checking again, whether it will disturb my existing SQL Server installation, in any means...? Though it is mentioned that it will g...

Can't Connect .Net application from Windows Server 2003 to Database Server (SQL Server 2000)
Hi, I am having a problem connecting my .net applications from the application server to the database server. When I run the application from my windows xp (sp2) box it works fine. When I try to connect via SQL Management Studio to the database server from the application server I get the same error. Here is the error: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider...

Can I use Bugzilla with Sql server 2000 or sql server 2005 as backend Database
I have Just Successfully installed Bugzilla My installation are Bugzilla 2.2 Apachec Webserver ActivePerl 7.8 Mysql 5.0 Now I like That My Database should be Sql server 2000 or sql server 2005 Can I do that [As I also see that I required some Perl module of Mysql as well] ...

SQL Server Reporting Services for SQL SERVER 2000 AND Visual Studio.NET 2005 .NET 2.0
Hi, Which version of SQl Server Reporting Services will work with SQL SERVER 2000 in pararrel with ASP.NET 2.0 (.NET 2.0 framework)?  Thanks, Azam HighOnCodingWanna get high! Hi, Okay I got the answer. Yes, we can use the SQL SERVER 2005 Reporting Services with SQL SERVER 2000. HighOnCodingWanna get high! ...

Can't seem to install SQL server 2005? Install completes, but where is SQL Server 2005
I went to one of the Microsoft "Ready To Launch" events over a year ago. Microsoft was gracious and gave everyone who attended a free copy of Visual Studio 2005 and SQL Server 2005. I have installed the Visual Studio and use it all of the time. I also installed the SQL server 2005 but I can not find the application on my computer. After the install the only items that appear to have been installed are the following: SQL Server Configuration tools(SQL Server Configuration manager,SQL Server  Error and usage reporting, SQL Server surface area confiuration, Reporting Services configu...

Attach SQL DB to SQL Server 2005 using VB.Net
Is there any way to attach a SQL DB to SQL Server 2005 using VB.Net?  If so can you also set security? Can you rephrase your question? Attach SQL DB from which version of SQL server ? Look up books online for sp_attachdb and sp_detachdb.***********************Dinakar NethiLife is short. Enjoy it.*********************** I have a DB that was created in SQL Server 2005.  I have a website that displays data from systems all over the world.  Each system sends it's data to it's own DB.  The customer can then go to a website and see the data at real time.  What ...

Is Microsoft free* elearning for Sql Server 2005 useful for learning SQL Server 2000?
I'm working towards MCAD and as elective I want to do the SQL Server course. The exam is on SQL Server 2000.  I was just wondering whether the online course that Microsoft currently have a available for free at https://www.microsoftelearning.com/sqlserver2005/default.aspx would be useful and applicable to SQL Server 2000, or whether it is sufficiently different product to make it confusing to use this as a learning resource. Also if anyone can point me toward any webcasts for SQL Server that would be great. I listened to Fritz Onion's 15 part series when I studied  for my ASP...

SQL Server 2005 Installation problems with SQL Server Express & SQL Server 2000
Hi Guys, I have had SQL Server Express and Sql Server Management Studio Express installed on my machine for some time and recently tried to install a trial of SQL Server 2005 as well.  (Yes, I'm migrating from Visual Studio Express to Visual Studio Professional, just as in tended!) Everything went fine except that nothing seemed to be installed.  I searched in all the obvious places - both on the Start/Programs menu and on the hard-drive: nothing. A check under Add/Remove Programs showed that Sql Server 2005 Express was installed, but called SQL Server 2005. So after a number o...

Can I use SQL 2005 Management studio to connect to SQL 2000 server?
Hi,Can I use SQL 2005 Management studio to connect to SQL 2000 server?   You certainly can!I only use SQL 2005 Management Studio for accessing all my 2000/2005 instances/databases. ...

Using Visual Studio 2003 with sql server 2000 and planning to switch to sql server 2005
We have a project already developed iusing VS 2003 Enterprise architect edition using sql server 2000(have lots of table and stored procs etc.) Now planning to switch to Sql server 2005 are there any issues associated with the switch.   I mean front end programming wise asp.net and vb.net front end codes do they work straight away or need to make any changes to all the front end codes, we are using datasets, data readers calling stored procs and also using lot of hash tables and XML object to make bulk loads to sql server via sqlxml3.0 sp3. Please help thank you very much for the in...

SQL Server 2000 and SQL Server 2005 in the same server
Can enyone please send me a link to a white paper explaining how to run both SQL Server 2000 and 2005 in the same machine?Thanks. I don't know about the white paper but I had both running on my machine for a while by making the SQL 2000 a named instance. So for SQL 2005 connection strings my server name was (local) while for SQL 200 using the named instance it was (local)\joesql where joesql was the instance nameHope it helps,Joe http://www.joeaudette.comhttp://www.mojoportal.com...

USER CAN'T CONNECT THE REPORTING SERVER (AD USERNAME) using SQL SERVER MANAGMENT STUDIO 2005
Normal 0 false false false EN-US X-NONE X-NONE ...

can't connect to sql server database with same connection used in visual studio .net 2003
I have the following code that works fine in visual studio .net 2003 but not with VWD.  I have sql server 2000 developer edition installed locally and this connection works fine with visual studio.  With VWD it fails with the exception "System.Data.SqlClient.SqlException: Login failed for user 'DARRELL\ASPNET'".  It fails on the conn.Open line.   any ideas on what the issue is?Dim conn As SqlConnectionDim connstr As Stringconnstr = "Data Source=DARRELL;Initial Catalog=Event;Integrated Security=SSPI;"Dim daEvents As New SqlDataAdapter("select * from events", connstr...

how can associated 'sa' with a trusted SQL Server connection in sql server 2005?
I want to use sa user login sql server 2005 to visit my database "dotnet20" but when I set the user property in User Mapping, It Report when I set it, An Error Occur like followCannot use the special principal 'sa'. (Microsoft SQL Server, Error: 15405)and also when I want to Login sql server use 'sa' user, It Report Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452)how can  associated 'sa' with a trusted SQL Server connection? I'm having this exact same problem. When I login using Windows authent. I can co...

Can I install sql server 2000 and sql server 2005 in the same machine
Hello ,i am an asp.net developer my pc has sql server 2005 already and now my company use sql server 2000I think 2005 is very easy to use but some of 2000 that I don't know so can I install 2000 in the same machine with 2005 ?thanks for your kindness.Kate  You definetely can. Go ahead and have fun. ***********************Dinakar NethiLife is short. Enjoy it.*********************** By the way, if you need to connect to a 2000 DB, you dont need to install 2000 on your local machine. You can still connect to the company DB through your 2005 Management Studio. Just register the server a...

Web resources about - ASP.Net application developed using SQL Server 2000 can't use SQL Server 2005 - asp.net.sql-datasource

Application - Wikipedia, the free encyclopedia
Text is available under the Creative Commons Attribution-ShareAlike License ;additional terms may apply. By using this site, you agree to the ...

Pre-Christmas job application rush hits Australian public service
Speed required for pre-Christmas job window opening for public servants. Check out who is hiring.

Second visa application 'likely' to be approved
The family of a terminally ill Pakistani student can 'hopefully come to Australia sooner rather than later' says Immigration Minister Peter Dutton. ...

Cloud application adoption increases 71 percent in 2015
The adoption of cloud applications is soaring, up by 71 percent in the last year according to the results of a new survey. The latest Cloud ...

Tashfeen Malik's visa application under scrutiny - Business Insider Deutschland
The US government has released the visa application for Tashfeen Malik, who along with her husband killed 14 people in an attack in San Bernardino, ...

MBA: Mortgage Applications Decrease in Latest MBA Weekly Survey, Purchase Applications up 34% YoY
From the MBA: Mortgage Applications Decrease in Latest MBA Weekly Survey Mortgage applications decreased 1.1 percent from one week earlier, ...

Lawmaker: Immigration Officials Didn’t Fully Vet Tashfeen Malik’s Visa Application
"It’s unacceptable that U.S. Citizenship and Immigration Services did not fully vet Malik’s application and instead sloppily approved her visa," ...

German-Based Spirea Promotes Decentralized PV Applications In Uruguay
... Its technical operations specialist, Laurie Lawrence, pointed out that Uruguay [&hellip German-Based Spirea Promotes Decentralized PV Applications ...

Visa application of San Bernardino shooter released
CNN Visa application of San Bernardino shooter released CNN (CNN) The visa application of one of the San Bernardino shooters was released ...

ZTE to develop smartphone application processors in house
ZTE has stepped up its efforts to internally develop smartphone chipset solutions, aiming to re-capture the title as one of the top-three smartphone ...

Resources last updated: 12/24/2015 9:16:44 PM