SQL 64bit Connection Error

[nate]

I am running Windows Vista 64bit - VS2005 - SQL2005

In my app my connection string is

 

Driver=SQL Server;Server=ComputerName\SQLExpress;Database=Mydb

 

everything works great when I run it in Visual Studio, yet if I run it from IE as localhost My connection string gave all kinds of errors. I looked around and found alot of info and came down to this:

 

"Provider=SQLOLEDB;User ID=ComputerName\Username;Password=SQLPassword;Initial Catalog=Mydb;Data Source=ComputerName\SQLExpress;"

 

Now I am getting login failure. Invalid credentials. I am not using any password for this db or SQL at all for that matter. I have set the login type to SQL Server and Windows Authentication. What the heck, IIS 7 is frustrating. What am I missing. Thanks in advance.