468,104 Members | 1,316 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,104 developers. It's quick & easy.

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 1669
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 discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Krista | last post: by
4 posts views Thread by bettina | last post: by
1 post views Thread by beck4353 | last post: by
3 posts views Thread by Raymond Chiu | last post: by
1 post views Thread by Solo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.