SQL Server & VB 2005 Express

well... a friend of mine is telling me (annoying me :) ) that with vb2005 Express we cant access remote sql server databases... well i made complete applications with vb 2005 express that connects to msde, and its working pretty well... so it must be possible...

i think this is just a matter of IDE binding to SQL Server Express limitation... cause i dont do data binding at all... i do all the database access in code...

well my question is... cant we connect to remote databases using VB 2005 Express or just SQL Server 2005 Express ?

any documentation on this issue ?

thx in addvance...

Ofcourse you can connect to the SQL 2000 databases from VB 2005. Just give the proper connection string.

Quote:

---

Originally Posted by Shuja Ali

Ofcourse you can connect to the SQL 2000 databases from VB 2005. Just give the proper connection string.

---

i know i can...i've been doing that since i have vb 2005 Express... but what about IDE binding, using Database Explorer ?

I don't think that is possible atleast in Express version. But as you know you can definetly do it using the code.

I read the product comparison (http://msdn.microsoft.com/vstudio/products/compare/) ... the only thing that i can see is about "Database design tools (create/modify tables and stored procedures" that only supports local... but many people thinks that you cant access remote databases using VB 2005 express...