Search results for query: *

Tek, I found a site where it takes you thru some steps to get this connection done. And yes, my CF and AccessDB servers are connected. This is the url for the solution: http://oracle.ifsm.umbc.edu/cfdocs/Installing_and_Configuring_ColdFusion_Server/datasources8.html Hope someone else too...

How do I use a coldfusion administrator to connect to a remote Access DB in another server? Im using a dsn connection for my queries and I do not wish to use the physical file name.

Hi lobstah, I resorted to installing the MDAC yesterday right out of the SQL Server 2000 cd. It didnt't work. I went to www.microsoft.com/data and downloaded MDAC 2.6 sp1 and restarted my server and it worked. Spent two days just contemplating whether to install this into my server. But it...

Hi, I have a coldfusion and asp running in the same server. Recently, I reinstalled coldfusion server to rectify a certain problem. The problem has been solved, only now Im totally unable to connect to my SQL DB using asp codes. My .cfm files are running fine. My .asp files give an error...

Oh, my mistake. I was assuming that the sql statement in a particular page would only appear when it is incorrectly written. However, I realised that the sql statement written correctly or not appears anyway once the show information is turned on in CF admin. Thanks again for the help. -a.h.

Hi webron and strantheman, thanks for your prompt help. Both methods worked. Just for future use, not urgent, would you also know how to output a valid sql statement? Just asking :) Thanks, a.h.

Hi, I am writing a search engine based on multiple criteria. The <cfquery></cfquery> tag is written with numerous <cfif> checks in between before the full sql statment is constructed. I need to see the resultant sql statement that is formed in order to debug. How do I output this statement in...