473,322 Members | 1,494 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Accessing SQL Database

TS
I am very new to .Net. I have good experience with VB, but I'm still in an
early stage of learning .Net plattform. Anyway, I don't know if I'm asking
this in the correct newsgroup, but if I'm not, please direct me to the
correct one.

My problem is: I am trying to connect to a SQL database from Visual Studio
2003, I noticed that under the tool menu there is a Connect To Database
option. I clicked on this option and specified the database I want to connect
to (I have admin role to the SQL server and db owner rights to the database),
but I got an error message:
"It is only possible to connect to SQL Server Desktop engine databases and
MS Access databases with this version of Visual Studio"
Does this mean that I am using the wrong Visual Studio version to perform
this? What do I need to do to connect to the SQL database? Shall I go ahead
and configure an OLEDB driver for SQL on the machine and use ADO to connect
to that database? Or there is another way to do that from Visual Studio?

Please advise

Regards
--
TS
Jul 21 '05 #1
3 1311
use server explorer window, you will see everything there

Tony
"TS" <TS@discussions.microsoft.com> wrote in message
news:81**********************************@microsof t.com...
I am very new to .Net. I have good experience with VB, but I'm still in an
early stage of learning .Net plattform. Anyway, I don't know if I'm asking
this in the correct newsgroup, but if I'm not, please direct me to the
correct one.

My problem is: I am trying to connect to a SQL database from Visual Studio
2003, I noticed that under the tool menu there is a Connect To Database
option. I clicked on this option and specified the database I want to connect to (I have admin role to the SQL server and db owner rights to the database), but I got an error message:
"It is only possible to connect to SQL Server Desktop engine databases and
MS Access databases with this version of Visual Studio"
Does this mean that I am using the wrong Visual Studio version to perform
this? What do I need to do to connect to the SQL database? Shall I go ahead and configure an OLEDB driver for SQL on the machine and use ADO to connect to that database? Or there is another way to do that from Visual Studio?

Please advise

Regards
--
TS

Jul 21 '05 #2
It sounds as if you have the VB standard version. That error just
means that you will not be able to use the wizards to connect to the
database. You can still use ADO.Net to connect to SQL server through
code.

A better group to ask questions of this sort is:
microsoft.public.dotnet.framework.aspnet

Jul 21 '05 #3
>> "It is only possible to connect to SQL Server Desktop engine databases
and
MS Access databases with this version of Visual Studio"

It's possible you have Visual Studio Pro instead of Enterprise. You need
Enterprise to admin your SQL Server from VS IDE. I ran into that myself
actually. :< I know your pain. But if you're doing dev on your own, then
you can probably easily wheel your chair over to your sql box anyways. :>

Good luck.
Jul 21 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Scott Castillo | last post by:
Is it possible to access an SQL Server database from a Javascript client? I know you can transfer variables from middleware to Javascript client, but was wondering if you can directly access...
2
by: Douglas Harber | last post by:
If I have DB2 8.1 (FP5, I believe, but not relevant to my question...I hope) installed on my desktop, do I have what I need to connect to a remote DB2 server (also running 8.1 FP5) from my desktop...
3
by: prodirect | last post by:
Hi all, I hope someone can help me. I've recently created a database and wanted to put it up on an ftp sight so that multiple people could access the same tables at the same time from different...
2
by: DanB | last post by:
I am using VB DotNet Std Edition and am writing a web application that needs to read and write to an password protected database. The mdb files reside in a folder (fpdb) under the localhost...
3
by: mark.jerrom | last post by:
I'm fairly new to this Web Service game so please feel free to suggest something different if it looks like i'm completely off track! I'm trying to write an application that runs on a Pocket PC...
3
by: Pakna | last post by:
Hello, I have what may be a beginner's question regarding DB2. How does one access a remote table on a remote database via SQL? What is the command string, is there an equivalent of Oracle...
5
by: samadams_2006 | last post by:
I'm having a problem in accessing a Microsoft Access Database in a VB.NET Web Application. It's so straight forward, I thought I'd walk you through all the details here: 1) I have a .NET Web...
4
by: scout3014 | last post by:
Hi I am using WAMP5 to create web applications. I have a problem as far as accessing the database is concerned. This following code is used to access database: $con =...
4
by: Noy B | last post by:
Hi, I have developed a small application that is using a MSAccess DB. the problem is that it was developed on a machine where the application and the DB are both located. now it needs to be...
2
by: brendan_gallagher_2001 | last post by:
HI I am developog an ASP.net site (using vb.net 1.1) which will be accessed by a number of different office locations, where certain users will be assigned a authoriser profile, and others will...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.