Connecting to SQL Server

[jrbrady]

I am configuring a SQLDataAdapter using the Data Adapter
Configuration Wizard. I click New Connection. I select my
server name, user name and password, and the database
name. I test the connection. It works. I click Ok and
am asked for the password again. I enter it, and click
ok. I receive the following message:

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

What does this mean?

I'm using Visual Basic .NET Standard and am running SQL
Server 2000.

 

[Jorge Cavalheiro]

Hello J.
Sorry but you will have to upgrade to Visual Studio
Professional. You can't use vb.net standard for that or
you have setup MSDE instead of MSSQL to use it.

Kind Regards
Jorge Cavalheiro

 

[William Ryan]

jr:

You can't use any of the visual tools if you have standard, but you can
still connect to it...just not with visual tools. However, you cna use a
..config file for instance and point to it with a connection and get a very
similar effect...

http://www.knowdotnet.com/articles/configfiles.html