SQL Server 2000 & SQL Server 2005 Express

[gbraden]

We are doing some ASPX/NET2 development with an SQL Server 2000 back-end. Our developer is using Visual Basic 6.0 which I understand, installs a copy of Express 2005 server on the PC and uses that to help debug issues with development.

I am told by others, that using VS6 with SQL Server Express 2005 will cause conflicts with some of the coding when we install the web pages with connection to the 2000 SQL Server.

This does not make sense to me, since the back-end is tables and data, and the ASPX pages are forms that both past and retrieve data based on data inputs.

Is there any gotchas that result from developing for SQL 2000 using VS6 and Express 2005?

Thanks in advance.


Glen Braden

 

[vbkris]

>>Is there any gotchas that result from developing for SQL 2000 using VS6 and Express 2005?


not that i am aware of. There are certain features that cannot be used in Express 2005 such as attach and detach databases, caching invalidation of DB records etc.

Other than this i dont see much of gotchas there...

Known is handfull, Unknown is worldfull

 

[nice95gle]

You might want to read the following.

http://msdn2.microsoft.com/en-us/library/bb264566.aspx

Good Luck



Well Done is better than well said
- Ben Franklin