Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SQL server 2000/2005 compatibility

Author  Topic 

avtuvy
Starting Member

9 Posts

Posted - 2008-04-27 : 16:34:41
I am developing an application which includes a server written in C# which interfaces with a database running on SQL 2000 server. My C# code uses stored procedures and ADO, what are the chances that this code is fully compatible with SQL 2005 server or with other database servers, is there a way to make it compatible?

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-27 : 17:59:34
Check ado version, sps should be ok if only use t-sql there. To work with other rdbms, may need make many changes. Each rdbms has its own sql syntex.
Go to Top of Page
   

- Advertisement -