[Top] [All Lists]

Re: database connection in CF8b

Subject: Re: database connection in CF8b
From: "ksmith"
Date: Tue, 10 Jul 2007 20:01:13 +0000 UTC
Newsgroups: macromedia.coldfusion.advanced_techniques
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.

<Prev in Thread] Current Thread [Next in Thread>