Vb.Net Standard Edition and SQL Server

  • Thread starter Thread starter Mike
  • Start date Start date
M

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.
 
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.
 
* "Mike said:
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."
Click to expand...

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