473,320 Members | 1,853 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,320 software developers and data experts.

Connecting to SQL Server

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.
Nov 20 '05 #1
2 1102
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
-----Original Message-----
I am configuring a SQLDataAdapter using the Data Adapter
Configuration Wizard. I click New Connection. I select myserver 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 thisversion of Visual Studio."

What does this mean?

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

Nov 20 '05 #2
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
"jrbrady" <jr*****@senior-direct.com> wrote in message
news:07****************************@phx.gbl...
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.

Nov 20 '05 #3

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

Similar topics

0
by: Google Mike | last post by:
After a lot of thought and research, and playing with FreeTDS and InlineTDS, as well as various ODBC connections, I have determined that the fastest and cheapest way to get up and going with PHP on...
12
by: Ann Marinas | last post by:
Hi all, I would like to ask for some help regarding separating the asp.net webserver and the sql server. I have created an asp.net application for a certain company. Initially, we installed...
3
by: Ann Marinas | last post by:
Hi there, I am currently developing an ASP.NET program that connects to a SQL Server 2000 database. I also have SQL Server 2005 Express installed on the same local machine. Prior to...
0
by: cj.snead | last post by:
Hello, I am having trouble connecting to a remote named instance of SQL Server via Pocket PC. I have had absolutely no luck connecting with VS 2005 (even to a default instance), so I wen't back...
3
by: Vinod R.Shenoy | last post by:
Hi All, Came across a post wherin you had helped somebody with a similar problem and was wondering if you could help us out with it. Our problem is , We have a development SQL Server 2000...
6
by: Todd Brewer | last post by:
Windows Server 2000 ASP.NET 2.0 SQL Server 2000 (on a physically seperate server) I moved an ASP.NET 2.0 application from a development server to production, and am getting the following error:...
10
by: mairhtin o'feannag | last post by:
Hello, I'm having problems connecting to my new v9 db box. The pertinent information is below: DB2_db2inst1 60000/tcp DB2_db2inst1_1 60001/tcp DB2_db2inst1_2 60002/tcp DB2_db2inst1_END...
2
by: samadams_2006 | last post by:
Hello, I have a problem that I'm hoping someone will be able to help me resolve. 1) I have a C# Web Site in which I connect to the database: "Install Microsoft SQL Server 2005 Express...
2
by: orandov | last post by:
Hi, I am having a problem connecting my .net applications from the application server to the database server. When I run the application from my windows xp (sp2) box it works fine. When I try to...
0
by: aboutjav.com | last post by:
Hi, I need some help. I am getting this error after I complete the asp.net register control and click on the continue button. It crashed when it tries to get it calls this Profile property ...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
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...
0
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...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
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: 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...

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.