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...;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:
go*********@yahoo.com (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: <f9*************************@posting.google.com>
| 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:
gr**********@google.com
| 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.19 4.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.
|