Cannot connect to db

[Jon Yates]

Hello mate.

In your connection string you may need to supply the
Username and Password to the Database. I've pasted in the
connection sring that I use from within a Windows App to
connection to a SQLServer 2000 DB.

Hope it helps,

Jon

"Provider=sqloledb;data source=SUNWL19655\NetSDK;initial
catalog=Portal; user id=sa; password="

 

[John Giblin]

I just forgot that in that try. No affect. Still cannot connect. It seems
like a configuration on my mchine since it worked for someone else with the
same code

John

 

[dj Bass]

if it's taken from another machine, then the things you need to check out
are the domains for the database boxes you're trying to access... does the
network machine exist with the same mappings as on the original PC? if it's
a different database instance, then you should probably start the connection
from scratch again.

i still say try the design view, you see more happening there in front of
you without worry about strings of info...

Dan.

 

[John Giblin]

Like I said. I used the VS.net to create the connection string and I was
able to view the databases. I also used the test connection, which worked

What I need to know, is what the differences are between, the vs.net env and
asp. I have intergrated security on that server and in the webinfo file,
impersonate is set to false ( I have played with that either way)

Do I need the latest mdac? and why would the console program not work.

John