Cannot connect to ANY database

  • Thread starter Thread starter beck4353
  • Start date Start date
B

beck4353

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?
 
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
 
Back
Top