Re: database connection in CF8b
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.