Cold Fusion/ODBC

Started by Michelle Murrainabout 25 years ago2 messagesgeneral
Jump to latest
#1Michelle Murrain
mpm@norwottuck.com

Hi folks,

I'm just starting with learning how to use Cold Fusion, and I have a question
for those of you who've used Postgres and CF. First, is there a direct way
that Cold Fusion can connect with postgres other than ODBC?

Example:

<cfquery name="theweather" datasource="rakehell" dbtype="ODBC">
SELECT * FROM weather
</cfquery>

Is there a dbtype command that will directly connect with a pg database, or
do I have to make the connection via ODBC?

Thanks in advance!

Michelle
--
------------
Michelle Murrain, Ph.D.
President
Norwottuck Technology Resources
mpm@norwottuck.com
http://www.norwottuck.com

#2Poul L. Christiansen
poulc@cs.auc.dk
In reply to: Michelle Murrain (#1)
Re: Cold Fusion/ODBC

I'm using Postgres and CF and AFAIK the only way to connect to Postgres is
with ODBC.

I wish there was a native interface, like the oracle interface.

Maybe a Cold Fusion CFX (in C++) tag could be made that allow native
Postgres connections?

Poul L. Christiansen

On Wed, 21 Mar 2001, Michelle Murrain wrote:

Show quoted text

Hi folks,

I'm just starting with learning how to use Cold Fusion, and I have a question
for those of you who've used Postgres and CF. First, is there a direct way
that Cold Fusion can connect with postgres other than ODBC?

Example:

<cfquery name="theweather" datasource="rakehell" dbtype="ODBC">
SELECT * FROM weather
</cfquery>

Is there a dbtype command that will directly connect with a pg database, or
do I have to make the connection via ODBC?

Thanks in advance!

Michelle
--
------------
Michelle Murrain, Ph.D.
President
Norwottuck Technology Resources
mpm@norwottuck.com
http://www.norwottuck.com

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org