Dreamweaver 8 & SQL Server 2005 Express

Howdy group. Has anyone successfully connected to a SQL Server 2005 Express
database running in Windows XP with Dreamweaver 8?

Every time I try to connect I get the error message:
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified

Now I went through the "Create New" "ASP.NET VB" SQL Server Connection wizard
and it connects fine when I test it. When I copy the connection string and try
to use it in an ASP VBScript based website, the connection string no longer
allows me to connect.

Here's my connection string:
Persist Security Info=False; Data Source=<machine name>\<database>; Initial
Catalog=<test>; User ID=test; Password=test;

Can anyone shed some light on this please?:frown;

Hi, I'm also trying to connect to a SQL Server 2005 Express Edition database. Can anyone help with this please?

Failing that, has anyone had much luck with a full SQL Server 2005 database?