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

Cannot connect to ANY database

Hi,

I am using VS.NET Arch. and I am having problems
connecting to ANY database. I am trying to a either a
SqlConnection or OleDBConnection object to my project.

When I try to define the connection string, it never
succeeds. I try every different naming convention for my
machine that I can in the server name field.

The twist is this: until I enter a valid server name
along with username/password, I cannot browse the database
dropdown (obviously). After doing so, and selecting a
database, I hit the "Test Connection" button and it
succeeds. However, when I hit "Ok" I get the error:

[Server Explorer]
Unable to connect to database.
The connection failed....

I get this with SQL Server, Access mdb's and Oracle
databases. I am supplying the proper user/pass but it
NEVER works.

I am using MDAC 2.8

Any Ideas?
Jul 21 '05 #1
1 1957
can you connect using those connection strings outside VS.NET?
For example if you go with OLEDB sources,
can you connect to the oledb source from a vbscript app (WSH) or
javascriptlet. ?
can you connect from MS Access using the same conn string?

did you check out www.connectionstrings.com ?

-D

"beck4353" <an*******@discussions.microsoft.com> wrote in message
news:01****************************@phx.gbl...
Hi,

I am using VS.NET Arch. and I am having problems
connecting to ANY database. I am trying to a either a
SqlConnection or OleDBConnection object to my project.

When I try to define the connection string, it never
succeeds. I try every different naming convention for my
machine that I can in the server name field.

The twist is this: until I enter a valid server name
along with username/password, I cannot browse the database
dropdown (obviously). After doing so, and selecting a
database, I hit the "Test Connection" button and it
succeeds. However, when I hit "Ok" I get the error:

[Server Explorer]
Unable to connect to database.
The connection failed....

I get this with SQL Server, Access mdb's and Oracle
databases. I am supplying the proper user/pass but it
NEVER works.

I am using MDAC 2.8

Any Ideas?

Jul 21 '05 #2

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

Similar topics

1
by: Krista | last post by:
Hi guys, i have a problem about inserting data into the table. I dont know why the output always said cannot be added to the database! Anyone has idea for me? i check the connect is ok, but dont...
4
by: bettina | last post by:
Hello, My domain: www.coaster.ch My database: coasters User: bettina In the programm I wrote: <?php $db_server = "www.coaster.ch";
6
by: Jeff Sandler | last post by:
I have a database I created in mySQL. I've been entering data every day into the database using a Java application that I wrote. The database and the Java program are on the same Win 98 SE...
2
by: Jay Chan | last post by:
We have just installed a SQL Server 2000 (SP 3A) onto a computer that has Windows-2003 Server on it. Now, we cannot get access to that database server from other computers. Seem like this may be an...
8
by: baustin75 | last post by:
Posted: Mon Oct 03, 2005 1:41 pm Post subject: cannot mail() in ie only when debugging in php designer 2005 -------------------------------------------------------------------------------- ...
10
by: Jean-David Beyer | last post by:
I have some programs running on Red Hat Linux 7.3 working with IBM DB2 V6.1 (with all the FixPacks) on my old machine. I have just installed IBM DB2 V8.1 on this (new) machine running Red Hat...
1
by: beck4353 | last post by:
Hi, I am using VS.NET Arch. and I am having problems connecting to ANY database. I am trying to a either a SqlConnection or OleDBConnection object to my project. When I try to define the...
6
by: antonyliu2002 | last post by:
I was able to view table content easily before, but after I reinstalled everything, I cannot find the option to view table content in MS SQL Server Express. I can define table with no problem. ...
3
by: Raymond Chiu | last post by:
Dear All, I have posted my question as below. But no answers, hope it can found here. ...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

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.