Thread: ODBC driver for Windows
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
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
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
> > 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
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
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 >
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