Skip site navigation (1) Skip section navigation (2)

Re: ColdFusion Remote PostgreSQL

From: Jochem van Dieten <jochemd(at)oli(dot)tudelft(dot)nl>
To: "Summer S(dot) Wilson" <collectonian(at)eclectic-world(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: ColdFusion Remote PostgreSQL
Date: 2001-09-25 21:21:38
Message-ID: 3BB0F562.6080305@oli.tudelft.nl (view raw or flat)
Thread:
Lists: pgsql-novice
Summer S. Wilson wrote:

> 
> Our other server, for the actual web side of things, is running Win2K with
> ColdFusion 5.  I installed the PostgreSQL drivers and was able to add it to
> the system DNS with no problem.  However, the ColdFusion Administrator
> doesn't recognize offer the PostgreSQL driver as an option in the datasource
> area.  Now, when we put in the PostgreSQL datasource it replaced the testing
> one of Access we had been using, so CF can see it as a datasource, lists
> PostgreSQL as its driver, but is unable to connect to the datasource.  How
> can I get ColdFusion to recognize the Postgre DNS connection and properly
> utilize it?  I've searched the net but so far the only answers I've found
> have been for CF Linux on the same server as Postgre.

We are running production with CF 4.5.1 SP2 on Windows NT4 SP6a 
connected to PostgreSQL 7.1 by the 7.06 ODBC driver, and it runs like a 
dream (except for bind variables using <cfqueryparam>, I recommend 
thorough testing of them, we abolished them in the end). We have tested 
quite a bit with CF5 on W2KS, but haven't finalized yet.

What you should do is create entirely new datasources for each 
PostgreSQL database you want to use. I have attached a cfml template 
that works for us to create new datasources. Just fill out everything 
you need in the first section and it should work. If you want a choice 
as to the name of the datasource you need to modify the template, 
currently the name of the datasource will be the same as the name of the 
database.

After creation validation using CF will fail since that doesn't use a 
password. You should test using a real query so you can supply a 
password in the cfquery attributes or set a default attribute in CF.

Let me know if you run into any problems.

Jochem van Dieten
Team Macromedia

Attachment: adddatasource.cfm
Description: text/plain (5.1 KB)

In response to

pgsql-novice by date

Next:From: Yeo Eng HeeDate: 2001-09-26 07:09:38
Subject: Postgresql and OpenSSL 0.9.6x
Previous:From: Summer S. WilsonDate: 2001-09-25 18:17:01
Subject: ColdFusion Remote PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group