Problem connecting a classic asp project to SQLserver 2008 express with this query strings:

conn = "Driver={SQL Server Native Client 10.0}; Server=.\SQLEXPRESS; Database= database; Trusted_Connection=yes"
conn = "Provider=SQLOLEDB;Data Source=.\SQLEXPRESS;Initial Catalog=database;UserID=sa;Password=123"
conn = "Driver={SQL Server}; Server=.\SQLEXPRESS; Initial Catalog= database;Integrated Security=True;Network Library =dbmssocn"
conn = "Provider=SQLNCLI10.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=database;Data Source=(local);"
_______________________
RETURNED ERROR:
Classic ASP return this error: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
_______________________
SQL Server: Authentication: SQL Server and windows authentication mode
I’m using IIS7 in a win 64bit
Do I need a DB user and password in sql DB and querystring? is the iis7? win7 64bit?
______________________
Note:
VB.NET can access with this conn String:
"Data Source=.\SQLEXPRESS;Initial Catalog=nData;Integrated Security=True"

I already saw the 12254 post:sql-server-does-not-exist-access-denied

and did not resolved the problem

Thanks

Well thats 4 connection strings all being assigned to the same variable, so only the 4th one will actually get used.

Here's the kind of connection string I'm using right now on a 64 bit windows 2008 machine with sql express and classic asp:

ConnString = "Provider=SQLOLEDB.1;Persist Security Info=False;Data Source=192.168.1.1\SQLEXPRESS;Initial Catalog=MyDatabaseName;Trusted_Connection=No;UID=U serName;Password=UserPassword"

-ClassicASP.com

Thanks for your reply classicasp
Well, as I wrote, I'm having problem with those conn strings, not all of them at the same time.
My client and server are in the same machine, so no need for ip.

Your connString did work with some adaptations

Thanks