Thread: Cold Fusion/ODBC

Cold Fusion/ODBC

From
Michelle Murrain
Date:
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

Re: Cold Fusion/ODBC

From
"Poul L. Christiansen"
Date:
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:

> 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
>