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
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
In response to
pgsql-novice by date
|Next:||From: Yeo Eng Hee||Date: 2001-09-26 07:09:38|
|Subject: Postgresql and OpenSSL 0.9.6x|
|Previous:||From: Summer S. Wilson||Date: 2001-09-25 18:17:01|
|Subject: ColdFusion Remote PostgreSQL|