Thread: ODBC driver for Windows

ODBC driver for Windows

From
David Link
Date:
Hi,

I'm looking through the documentation, I'm trying to figure this out.

How can I get a client up and running, 'psql' and an ODBC driver for
postgreSQL on Windows?  Do I need to install the entire database with
cygwin?

I'm playing around with Macromedia's Dreamweaver and ColdFusion which
can use ODBC to connect to databases. (It can also use JDBC, OLE DB and
has native support for Oracle and others -- not PG though :-)

-David

Re: ODBC driver for Windows

From
"Josh Berkus"
Date:
David,

> I'm looking through the documentation, I'm trying to figure this out.
>
> How can I get a client up and running, 'psql' and an ODBC driver for
> postgreSQL on Windows?  Do I need to install the entire database with
> cygwin?

If you're on Windows, download PgAdminII from:
http://pgadmin.postgresql.org/

This will install the latest ODBC, as well as a nifty GUI admin console.

> I'm playing around with Macromedia's Dreamweaver and ColdFusion which
> can use ODBC to connect to databases. (It can also use JDBC, OLE DB
> and
> has native support for Oracle and others -- not PG though :-)

IMHO, Dreamweaver and Coldfusion leave a lot to be desired as real
production platforms.  For playing around, they've OK.

______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco

Re: ODBC driver for Windows

From
Joel Burton
Date:
On Wed, 17 Oct 2001, David Link wrote:

> I'm looking through the documentation, I'm trying to figure this out.
>
> How can I get a client up and running, 'psql' and an ODBC driver for
> postgreSQL on Windows?  Do I need to install the entire database with
> cygwin?
>
> I'm playing around with Macromedia's Dreamweaver and ColdFusion which
> can use ODBC to connect to databases. (It can also use JDBC, OLE DB and
> has native support for Oracle and others -- not PG though :-)

ODBC driver, instructions & FAQ at odbc.postgresql.org.

Don't need to install cygwin at all; unless you don't have a
Linux/Unix/BSD box to use as the PostgreSQL *server*.

If you want to run psql natively under Windows, you can get a copy with
the excellent pgadmin tool, pgadmin.postgresql.org. Personally, I prefer
to run psql through telnet or ssh on my Linux box, as it's faster & can
use readline.

There's a ML to discuss ODBC+PostgreSQL at pgsql-odbc@postgresql.org.

HTH,

--

Joel BURTON  |  joel@joelburton.com  |  joelburton.com  |  aim: wjoelburton
Independent Knowledge Management Consultant


Web Development with Database

From
David Link
Date:
> > I'm playing around with Macromedia's Dreamweaver and ColdFusion which
> > can use ODBC to connect to databases. (It can also use JDBC, OLE DB
> > and
> > has native support for Oracle and others -- not PG though :-)
>
> IMHO, Dreamweaver and Coldfusion leave a lot to be desired as real
> production platforms.  For playing around, they've OK.

What I have found for Web application development with Database are the
following solutions, in order of desirability:

1. Perl CGI programs using Perl:DBI for Database connectivity.

    This gives you lots of flexibility.  And with Apache Perl Mod you no
longer need to fork a new process for every client request.

2. Java Server Pages (JSP) using JDBC.  It requires some Java Servlet
Engine running along side Apache.

    This gives you lots of flexibility, although development is not as
fast as perl development.  One could start out with Perl CGI and migrate
to JSPs as a project becomes more robust.

3. Macromedia's ColdFusion Server running along side Apache.  It uses
ODBC.  It allows the use of ColdFusion Tags to extend HTML and allow SQL
(among other things).

   This is about as effective as using PHP or ePerl.

4. Active Server Pages (ASP) by Microsoft.  This requires the use of the
IIS web server rather than Apache.  ASPs can use Microsoft's ActiveX
Document Object (ADO) model on top of Microsoft's OLE DB database
connectivity which may rely on ODBC to connect to Databases that do not
support M$'s OLE DB.

   Too proprietary.


What are other people's opinions on this?
What is www.postgresql.org developed on?

Thanks -David

Re: Web Development with Database

From
Jim Caley
Date:
I've been having very good results using Enhydra (see http://www.enhydra.org, or
specifically for the open source version, http://enhydra.enhydra.org).  This
uses JDBC.

Jim
--

David Link wrote:
>
> > > I'm playing around with Macromedia's Dreamweaver and ColdFusion which
> > > can use ODBC to connect to databases. (It can also use JDBC, OLE DB
> > > and
> > > has native support for Oracle and others -- not PG though :-)
> >
> > IMHO, Dreamweaver and Coldfusion leave a lot to be desired as real
> > production platforms.  For playing around, they've OK.
>
> What I have found for Web application development with Database are the
> following solutions, in order of desirability:
>
> 1. Perl CGI programs using Perl:DBI for Database connectivity.
>
>     This gives you lots of flexibility.  And with Apache Perl Mod you no
> longer need to fork a new process for every client request.
>
> 2. Java Server Pages (JSP) using JDBC.  It requires some Java Servlet
> Engine running along side Apache.
>
>     This gives you lots of flexibility, although development is not as
> fast as perl development.  One could start out with Perl CGI and migrate
> to JSPs as a project becomes more robust.
>
> 3. Macromedia's ColdFusion Server running along side Apache.  It uses
> ODBC.  It allows the use of ColdFusion Tags to extend HTML and allow SQL
> (among other things).
>
>    This is about as effective as using PHP or ePerl.
>
> 4. Active Server Pages (ASP) by Microsoft.  This requires the use of the
> IIS web server rather than Apache.  ASPs can use Microsoft's ActiveX
> Document Object (ADO) model on top of Microsoft's OLE DB database
> connectivity which may rely on ODBC to connect to Databases that do not
> support M$'s OLE DB.
>
>    Too proprietary.
>
> What are other people's opinions on this?
> What is www.postgresql.org developed on?
>
> Thanks -David
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

Re: Web Development with Database

From
"Mark G. Franz"
Date:
Jakarta::Tomcat can run as a service under IIS too, I forget the procedure
to set it up, but you can get more info at
http://jakarta.apache.org/tomcat/tomcat-3.3-doc/tomcat-iis-howto.html  This
way you can use the JDBC to make your connections... ;-)

And I agree, DreamSleazer and FireWorst is not a development platform, IMO
it's a WYSIWYG.  ColdFusion is better, but no more than a copycat to me...
[no flames please.]

Mark
----- Original Message -----
From: "Jim Caley" <caley@chesco.com>
To: "David Link" <dlink@soundscan.com>
Cc: "Josh Berkus" <josh@agliodbs.com>; <pgsql-novice@postgresql.org>
Sent: 17 October, 2001 1:18 PM
Subject: Re: [NOVICE] Web Development with Database


> I've been having very good results using Enhydra (see
http://www.enhydra.org, or
> specifically for the open source version, http://enhydra.enhydra.org).
This
> uses JDBC.
>
> Jim
> --
>
> David Link wrote:
> >
> > > > I'm playing around with Macromedia's Dreamweaver and ColdFusion
which
> > > > can use ODBC to connect to databases. (It can also use JDBC, OLE DB
> > > > and
> > > > has native support for Oracle and others -- not PG though :-)
> > >
> > > IMHO, Dreamweaver and Coldfusion leave a lot to be desired as real
> > > production platforms.  For playing around, they've OK.
> >
> > What I have found for Web application development with Database are the
> > following solutions, in order of desirability:
> >
> > 1. Perl CGI programs using Perl:DBI for Database connectivity.
> >
> >     This gives you lots of flexibility.  And with Apache Perl Mod you no
> > longer need to fork a new process for every client request.
> >
> > 2. Java Server Pages (JSP) using JDBC.  It requires some Java Servlet
> > Engine running along side Apache.
> >
> >     This gives you lots of flexibility, although development is not as
> > fast as perl development.  One could start out with Perl CGI and migrate
> > to JSPs as a project becomes more robust.
> >
> > 3. Macromedia's ColdFusion Server running along side Apache.  It uses
> > ODBC.  It allows the use of ColdFusion Tags to extend HTML and allow SQL
> > (among other things).
> >
> >    This is about as effective as using PHP or ePerl.
> >
> > 4. Active Server Pages (ASP) by Microsoft.  This requires the use of the
> > IIS web server rather than Apache.  ASPs can use Microsoft's ActiveX
> > Document Object (ADO) model on top of Microsoft's OLE DB database
> > connectivity which may rely on ODBC to connect to Databases that do not
> > support M$'s OLE DB.
> >
> >    Too proprietary.
> >
> > What are other people's opinions on this?
> > What is www.postgresql.org developed on?
> >
> > Thanks -David
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>


Re: Web Development with Database

From
Joel Burton
Date:
On Wed, 17 Oct 2001, David Link wrote:

> What are other people's opinions on this?
> What is www.postgresql.org developed on?

Don't want to steer everyone too off-topic, but I'll be happy to plug
another Open Source project: I use Zope for several sites I run, all
using PostgreSQL as the backend database, and I'm very happy. There are
large Zope sites (though there are much larger Perl sites and ASP sites);
but Zope has a nice Open Source feel, a good learning curve, and very fast
dev time. Been drafting a technical document for the PG + Zope communities
on lessons learned in using both products together; if anyone has anything
they'd like to add to this, please email me.

OpenACS is also an excellent web app dev environment that uses PostgreSQL.
It's the PG version of Ars Digita's ACS. (tcl isn't my cup of tea,
personally, but it is a nice setup).

--

Joel BURTON  |  joel@joelburton.com  |  joelburton.com  |  aim: wjoelburton
Independent Knowledge Management Consultant