Can't open a SqlConnection

[Mark]

Hello again....

I have just started with .net and ado.net and am tryng to get a
SqlConnection working.

I know my MSDE is working as I am able to retrieve data from it using an ado
connection and an ado recordset.

When I try to use a SqlConnection I get the following error on the cn.Open
line

"Unhandled exception: system.data.sqlclient.sqlexception: SQL Server does
not exist or access denied"

I am using the same connection details in both methods (string formats are
different ofcourse ) but the SqlConnection method fails every time. I even
went so far as to join all the user accounts on my test box to the
administrators group. Still no joy (

Any help greatly appreciated

Mark

 

[Michael McCarthy]

Hello again....

I have just started with .net and ado.net and am tryng to get a
SqlConnection working.

Any code examples, it seems pretty straight forward that something isn't
right, in that whatever it thinks it is connecting to is not actually
the correct path to the database.

 

[Mark]

Any code examples, it seems pretty straight forward that something isn't

right, in that whatever it thinks it is connecting to is not actually the
correct path to the database.

Michael... You are I suspect, correct ) I'm not sure what was wrong or how
I fixed it but it sort of works now...

Thanks

Mark

 

[TC]

It will be authentication. When you access the data via vis studio you are
using your credentials. When you do it via the running app you are using
ASPNET user credentials unless you are impersonating.

TC