Skip site navigation (1) Skip section navigation (2)

ODBC vs. Connect String

From: "Richard Sorensen" <RSorensen(at)seawave(dot)com>
To: <pgsql-interfaces(at)postgresql(dot)org>
Subject: ODBC vs. Connect String
Date: 2004-02-17 01:22:59
Message-ID: B68D193559D9784AA79E7B10003755523B384E@podri.pinoak.ri (view raw or flat)
Thread:
Lists: pgsql-interfaces
Hi,

We have a Postgres database running on a Linux server that needs to be
accessed as part of a Windows-based client application.  For testing, we
are using the psqlODBC tools and creating DSNs on Windows workstations,
but for customer installs I would prefer to avoid the creation of a DSN,
and instead open the database directly with a connect string, as can be
done with other database systems.  In other words, I would like to have
the Windows app install procedure only install and registers the
necessary Postgres dll's, and not have to create any ODBC entries.

1.  Can this be done?  If so:

2.  What would the connect string look like?  and

3.  Which files do I need to install and register for Postgres access?

Rich Sorensen

pgsql-interfaces by date

Next:From: Brett SchwarzDate: 2004-02-17 09:09:38
Subject: Re: Need new project admin for unbundled Tcl interface
Previous:From: Marc G. FournierDate: 2004-02-16 15:07:16
Subject: Re: Need new project admin for unbundled Tcl interface

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group