From: Shurmoore on
I am running windows vista ultimate and have .net framework 1.1, 2.0, 3.5
installed on my system. I created a .NET application (site) in DW, but cannot
connect to any database. I tried SQL Server connection with the free version of
SQL Express 2005, but the same results.

Here are the error that i get:

SQL CONNECTION ATTEMPT:

[Here are the connection settings:]

Provider=SQLOLEDB.1;
Integrated Security=SSPI;
Persist Security Info=False;
Initial Catalog=EyelandDB;
Data Source=SHURMOORE-PC\SQLEXPRESS

When I click the test button i get the following message:
Cannot open database "XYZ" requested by the login. The login failed!

Access 2003 Connection Attempt:

[Settings:]

Provider=Microsoft.Jet.OLEDB.4.0;
Data Source=C:\inetpub\wwwroot\EOP.NET\database\LENSESDB.mdb;
Persist Security Info=False

When I click the test button i get the following message:

Unspecified Error!

What must i do to get this to work?

I have this website to create and I need some expert help.

Thanks,