Connection string to SQL Server 2008 Express 1

[jacktripper]

I took a database from SQL Server 2005 and restored it onto my local machine running SQL Server 2008 Express. The database appears to have restored just fine. I can open the database engine in Management Stuido and view all the tables (thru Windows Integrated Authentication).

The Classic ASP pages which used to query the original database can't seem to find my new version on 2008. I've tried different variations of connection strings, but nothing seems to be working.

Here is the original connection string:
"DRIVER=SQL Server;SERVER=DD8X13H1;UID=ThisUser;PWD=JumpingJackFlash;DATABASE=Original"

I've trying removing the UID and PWD replacing with Trusted_connection=Yes, but no luck. I also tried a wide variety of other things. SQL Browser is running as a service.

Any thoughts?

The message I am getting is:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

 

[gmmastros]

Try connectionstrings.com
check your firewall

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[foxbox]

Try adding sqlservr.exe to the exception in the LOCAL firewall?

 

[foxbox]

SERVER=DD8X13H1" refers to the default instance on the local computer. I believe SS2008 Express installs as a named instance. Try: "DD8X13H1\SQLExpress" ,
".\SQLExress;" or "localhost\SQLExpress;"....