SQL Server & VB 2005 Express

[zuperman]

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...

[Shuja Ali]

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

[zuperman]

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 ?

[Shuja Ali]

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

[zuperman]

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...