How to connect VB .NET 2003 STANDARD to SQL Server Desktop engine

[Linda Lee]

I purchased Visual Basic .NET version 2003 Standard

I first try to connect Visual Basic .NET 2003 Standard to SQL Server
2000 Personal edition. When I go into Visual Basic .NET under Server
Explorer and try to add the connection, I received 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."

Then I download the SQL Server Desktop Engine and install it. I think
the installation is ok because osql commend works under DOS. Now, I
can not find it in the Server Explorer. How can I connect Visual Basic
..NET 2003 Standard to SQL Server Desktop Engiee?

Very very confusion. Please help.

 

[Stephen Provine [MSFT]]

Hi Linda,

You say "Now, I can not find it in the Server Explorer" below. After you
have installed the SQL Server Desktop Engine, you still need to add a
connection to it in Server Explorer just like any other connection. In
order to connect to the desktop engine, you normally need to provide a
server name (the name of your local machine) and an instance name.

The following knowledge base article contains a pointer to a document that
describes how to view the configuration of the desktop engine, and contains
a section on connection troubleshooting.

http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q301413

Hope this helps,
VSData Team
Please post to our newsgroup: microsoft.public.dotnet.datatools
This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
| From: (e-mail address removed) (Linda Lee)
| Newsgroups: microsoft.public.dotnet.general
| Subject: How to connect VB .NET 2003 STANDARD to SQL Server Desktop engine
| Date: 25 Sep 2003 21:40:56 -0700
| Organization: http://groups.google.com/
| Lines: 15
| Message-ID: <[email protected]>
| NNTP-Posting-Host: 68.98.235.202
| Content-Type: text/plain; charset=ISO-8859-1
| Content-Transfer-Encoding: 8bit
| X-Trace: posting.google.com 1064551258 14377 127.0.0.1 (26 Sep 2003
04:40:58 GMT)
| X-Complaints-To: (e-mail address removed)
| NNTP-Posting-Date: 26 Sep 2003 04:40:58 GMT
| Path:
cpmsftngxa06.phx.gbl!TK2MSFTNGP08.phx.gbl!news-out.cwix.com!newsfeed.cwix.co
m!newsfeed.frii.net!newsfeed.frii.net!140.99.99.194.MISMATCH!newsfeed1.easyn
ews.com!easynews.com!easynews!sn-xit-02!sn-xit-06!sn-xit-09!supernews.com!po
stnews1.google.com!not-for-mail
| Xref: cpmsftngxa06.phx.gbl microsoft.public.dotnet.general:109977
| X-Tomcat-NG: microsoft.public.dotnet.general
|
| I purchased Visual Basic .NET version 2003 Standard
|
| I first try to connect Visual Basic .NET 2003 Standard to SQL Server
| 2000 Personal edition. When I go into Visual Basic .NET under Server
| Explorer and try to add the connection, I received 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."
|
| Then I download the SQL Server Desktop Engine and install it. I think
| the installation is ok because osql commend works under DOS. Now, I
| can not find it in the Server Explorer. How can I connect Visual Basic
| .NET 2003 Standard to SQL Server Desktop Engiee?
|
| Very very confusion. Please help.
|