pg.ddx.io pgsql-interfaces@postgresql.org mailing list archivehelp / color / mirror / Atom feed
ODBC on unix? 3+ messages / 2 participants [nested] [flat]
* ODBC on unix? @ 1998-07-01 12:03 Herouth Maoz <herouth@oumail.openu.ac.il> 0 siblings, 0 replies; 3+ messages in thread From: Herouth Maoz @ 1998-07-01 12:03 UTC (permalink / raw) To: pgsql-interfaces Can someone clear something up for me? I was under the impression that ODBC is entirely a Windows proprietary thing. But now that I am reviewing all sorts of RADs for the web, they all seem to insist that their Solaris versions (I use Solaris) can access all databases through ODBC. Does this mean that there's actually an ODBC mechanism/framework for unix? The question that follows is - is PostgreSQL's ODBC driver, which, as I understand, is Win32 based - supposed to work in such an environment? Or is it too much to hope for? It would enable me to use things like ColdFusion and LiveWire. Very useful. I hate reinventing the wheel, and Java-based Web-RADs don't seem to exist. Or am I wrong in this, too? Herouth -- Herouth Maoz, Internet developer. Open University of Israel - Telem project http://telem.openu.ac.il/~herutma ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] ODBC on unix? @ 1998-07-04 15:02 leif@danmos.dk 0 siblings, 1 reply; 3+ messages in thread From: leif@danmos.dk @ 1998-07-04 15:02 UTC (permalink / raw) To: pgsql-interfaces Hi Herouth, > Can someone clear something up for me? > > I was under the impression that ODBC is entirely a Windows proprietary > thing. But now that I am reviewing all sorts of RADs for the web, they all > seem to insist that their Solaris versions (I use Solaris) can access all > databases through ODBC. > > Does this mean that there's actually an ODBC mechanism/framework for unix? I have successfully downloaded and installed the unix pgodbc interface by Sergey E. Levov. Have a look at http://users.ids.net/~bjepson/freeODBC and ftp://ftp.informika.ru/pub/unix/db/postgres. > > The question that follows is - is PostgreSQL's ODBC driver, which, as I > understand, is Win32 based - supposed to work in such an environment? Or is > it too much to hope for? I don't know. Maybe someone else can answer this? > > It would enable me to use things like ColdFusion and LiveWire. Very useful. > I hate reinventing the wheel, and Java-based Web-RADs don't seem to exist. > Or am I wrong in this, too? Just to satisfy my curiosity: What are these two programs? > > Herouth Greetings, ___________________________________________________________________________ / _/ _/_/ / Leif Jensen (leif@danmos.dk) _/ _/ _/ / _/ _/_/ _/_/_/ / _/ _/ _/ _/ _/ / Linux 2.0.33, gcc 2.7.2, wxWin 1.66F _/ _/ _/_/ _/ _/ / _/ _/ _/ _/ _/ / _/_/_/_/ _/_/ _/_/ _/ / (and Windows 95 :-( ___________________________________________________________________________ ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] ODBC on unix? @ 1998-07-05 10:50 Herouth Maoz <herouth@oumail.openu.ac.il> parent: leif@danmos.dk 0 siblings, 0 replies; 3+ messages in thread From: Herouth Maoz @ 1998-07-05 10:50 UTC (permalink / raw) To: leif@danmos.dk; pgsql-interfaces At 18:02 +0300 on 4/7/98, leif@danmos.dk wrote: > I have successfully downloaded and installed the unix pgodbc interface > by Sergey E. Levov. Have a look at http://users.ids.net/~bjepson/freeODBC > and ftp://ftp.informika.ru/pub/unix/db/postgres. Thank you. I wish it was better-documented, but I'm sure you're not the one to address on this... > > It would enable me to use things like ColdFusion and LiveWire. Very useful. > > I hate reinventing the wheel, and Java-based Web-RADs don't seem to exist. > > Or am I wrong in this, too? > > Just to satisfy my curiosity: What are these two programs? Rapid Application Development environments for the web. For example, PHP is such a RAD. It allows you to mix HTML and dynamic contents from databases, files, etc. This is usually done by adding tags to the HTML files, which are parsed by the application server, and replaced with the appropriate contents, such that at the end, a pure HTML output is presented to the user's browser. The high-quality applications have mechanisms which help you in updating the database, not only retrieving. Updating requires maintaining session state, as well as locking between users. This when HTTP doesn't keep a live connection to the system, and thus you don't know when the user went away and how long to maintain locks. High-quality Web-RADs are supposed to help you by giving you pools of database connections which remain persistent from one session to the next, and they are also supposed to take care of all the multiuser overhead. ColdFusion is Allaire's acclaimed rapid-development application server. You can find more, I guess, at http://www.allaire.com/. It requires ODBC. LiveWire is actually the old name for Netscape's Server-Side Javascript and its connection to RDBMS. They have database connection pools, session management and all - but they have some three databases they support, and ODBC as well. I'm currently in search of such a RAD, which will, in addition, allow me toplug in a Java class here and there (on the server side, not an applet). And this RAD has to work with PostgreSQL, of course. One of the important requirements of such a RAD is that it will have support for our web server (Netscape), and will not be CGI-based (because this creates a process for every call. Bad.) If anybody here knows of such a RAD which supports postgreSQL, please drop me a note. Herouth -- Herouth Maoz, Internet developer. Open University of Israel - Telem project http://telem.openu.ac.il/~herutma ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~1998-07-05 10:50 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 1998-07-01 12:03 ODBC on unix? Herouth Maoz <herouth@oumail.openu.ac.il> 1998-07-04 15:02 Re: [INTERFACES] ODBC on unix? leif@danmos.dk 1998-07-05 10:50 ` Herouth Maoz <herouth@oumail.openu.ac.il>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox