Re: database connection in CF8b

["ksmith"]

The server is the machinename itself.  So connecting to a local MSSQL server 
and a database named breeze, I use:
 Database - breeze
 Server - localhost
 And it works.
 Simplest way to start debugging a datasource issue is to create the 
datasource.  Even if it fails to verify continue by creating a test cfm with 
any query using that DSN.  Do a simple "select * from foo".  Run the template 
with debugging and verbose error info on.  Come back with the error if you 
cannot figure the problem out from there.