Vb.Net Standard Edition and SQL Server

[Mike]

I am using the standard edition of VB.net. I am trying
to connect to a SQL database on our server using the
built in Sqlconnection object in the Data toolbox. When
set up the connection and test it, it tests OK. But then
I get the following error:

"Unable to connect to database. It is only possible to
connect to SQL Server Desktop Engine Databases and
Microsoft Access Databases with this version of Visual
Studio."

I have Enterprise Manager so I don't need to build or
modify SQL databases using VB.net, only connect to them.
Did I not install VB.net properly, or do I need to
upgrade to Visual Studio? I have no need for C or Java.

 

[William Ryan]

If you have standard, you can't use the Visual Tools to connect to SQL
Server, BUT, you can still connect to it. Many shops don't use the visual
tools very often so they may not need to spend the money for the upgraded
version b/c they can still write apps that can connect to SQL Server.

 

[Herfried K. Wagner [MVP]]

I am using the standard edition of VB.net. I am trying
to connect to a SQL database on our server using the
built in Sqlconnection object in the Data toolbox. When
set up the connection and test it, it tests OK. But then
I get the following error:

"Unable to connect to database. It is only possible to
connect to SQL Server Desktop Engine Databases and
Microsoft Access Databases with this version of Visual
Studio."

You cannot connect to a SQL Server database using the IDE.
Nevertheless, you can set up connection objects in your code and
establish a connection.

 

[Cor]

Hi Mike,

I checked the first database samples of the resource kit.
The connections are made by hand and not with the wizard.

http://msdn.microsoft.com/vbasic/vbrkit/default.aspx

And if you have problems installing it

http://msdn.microsoft.com/vbasic/vbrkit/faq/#installvdir
I hope this helps a little bit?

Cor