473,320 Members | 1,699 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.

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 1956
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: 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...
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: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
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...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
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: 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....

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.