VB.net express edition 2005 beta and SQL server !!!

[Denis R Charron]

I downloaded VB.net express edition 2005 beta. My problem is when I created
new datasource and open the "Change data Source" dialog box
SQL server doest show as a choice. Only choice i have is Access Database
File et SQL Server Database File.
My SQL server is SQL Server 2005 CTP.

On the other hand everything is working fine with Visual Web Developer 2005
Express Edition.

So is it possible to connect to SQL server using the VB.net express edition
2005 beta. If yes what should I do to have it reconize my SQL server.

Thank's

 

[Ross Presser]

I downloaded VB.net express edition 2005 beta. My problem is when I created
new datasource and open the "Change data Source" dialog box
SQL server doest show as a choice. Only choice i have is Access Database
File et SQL Server Database File.
My SQL server is SQL Server 2005 CTP.

On the other hand everything is working fine with Visual Web Developer 2005
Express Edition.

So is it possible to connect to SQL server using the VB.net express edition
2005 beta. If yes what should I do to have it reconize my SQL server.

Thank's

If it's anything like VB.NET Professional 2003, you can only connect to
access or MSDE in the designer. But your finished app can use any valid
connectionstring. We use a local MSDE for development and then change the
connectionstring to point at the real SQL server about halfway through
development.

 

[Guest]

One question; If I have an application that I developed using OLE classes and
an Access DataBase, can I just change the connection string to connect to an
SQL server database? Note that I use @@Idenity some to get the value for
Autoincrement fields.

 

[Denis R Charron]

Thank for youre answer.
Is there any MSDE for this version of SQL. I guess not because it's a beta
version. I find it bizzare that it work with VWD2005 and not with VB.

 

[Ross Presser]

One question; If I have an application that I developed using OLE classes and
an Access DataBase, can I just change the connection string to connect to an
SQL server database? Note that I use @@Idenity some to get the value for
Autoincrement fields.

Yes. This is exactly the scenario in our shop for many projects. (I didn't
even realize @@IDENTITY worked with Access databases.)

 

[learner]

you may want to take a look at
http://lab.msdn.microsoft.com/express/sql/default.aspx
it may not be MSDE but it is SQL .net: SQL Server Express Edition September
CTP