Thread: ODBC vs. Connect String

ODBC vs. Connect String

From
"Richard Sorensen"
Date:
<p><font face="Arial" size="2">Hi,</font><p><font face="Arial" size="2">We have a Postgres database running on a Linux
serverthat needs to be accessed as part of a Windows-based client application.  For testing, we are using the psqlODBC
toolsand 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,
andnot have to create any ODBC entries.</font><p><font face="Arial" size="2">1.  Can this be done?  If
so:</font><p><fontface="Arial" size="2">2.  What would the connect string look like?  and</font><p><font face="Arial"
size="2">3. Which files do I need to install and register for Postgres access?</font><p><font face="Arial"
size="2">RichSorensen</font>