By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,905 Members | 894 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,905 IT Pros & Developers. It's quick & easy.

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

P: n/a
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.
Jul 21 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.
|

Jul 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.