Thread: Deploying ODBC for Postgres

I'm now deploying my Postgresql backend for Access solution to the customer. The customer has
twenty-something odd workstations that may run clients but they are dispersed around the campus
and would prefer not to have to physically send a support person to each workstation. The driver
installation program is simple enough for me to just put it up on the network for users to click/run on
their workstations. My question is how to get the system DSN installed on each workstation for my
backend Postgres database connection? Can I write some script or something to make this happen
automagically?

    thanx & later,

        Ben Scherrey

Hi Ben,

You can do this through a login script and/or regedit. Copy the
psqlodbc.dll to the windows system directory on each PC, then insert the
appropriate registry settings. You will need to install those for the
driver and the DSN - some sample registry entries are shown below. One
thing to watch out for, non-admins cannot usually write these entries on
w2k/xp due to the default permissions on HKEY_LOCAL_MACHINE.

Another option is to use msiexec.exe from the command line/login script
to automatically run the psqlodbc installer, in silent mode. Check the
Microsoft documentation for the msiexec command line options.

Regards, Dave.

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\MyDSN]
"Driver"="C:\\WINDOWS\\System32\\psqlodbc.dll"
"Description"=""
"Database"="template1"
"Servername"="postgresql"
"Port"="5432"
"Username"=""
"Password"=""
"ReadOnly"="0"
"ShowOidColumn"="0"
"FakeOidIndex"="0"
"RowVersioning"="0"
"ShowSystemTables"="0"
"Protocol"="6.4"
"ConnSettings"=""
"DisallowPremature"="0"
"UpdatableCursors"="0"
"LFConversion"="1"
"TrueIsMinus1"="0"
"Fetch"="100"
"CommLog"="1"
"Debug"="0"
"Optimizer"="1"
"Ksqo"="1"
"UniqueIndex"="1"
"UseDeclareFetch"="0"
"UnknownSizes"="0"
"TextAsLongVarchar"="1"
"UnknownsAsLongVarchar"="0"
"BoolsAsChar"="1"
"Parse"="0"
"CancelAsFreeStmt"="0"
"MaxVarcharSize"="254"
"MaxLongVarcharSize"="8190"
"ExtraSysTablePrefixes"="dd_;"
"BI"="0"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources]
"MyDSN"="PostgreSQL"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers]
"PostgreSQL"="Installed"

[HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\PostgreSQL]
"UsageCount"=dword:00000001
"Driver"="C:\\WINDOWS\\System32\\psqlodbc.dll"
"Setup"="C:\\WINDOWS\\System32\\psqlodbc.dll"
"SQLLevel"="1"
"DriverODBCVer"="02.50"
"FileUsage"="0"
"APILevel"="1"
"ConnectFunctions"="YYN"

> -----Original Message-----
> From: Benjamin Scherrey [mailto:scherrey@proteus-tech.com]
> Sent: 17 November 2002 20:34
> To: pgsql-odbc@postgresql.org
> Subject: [ODBC] Deploying ODBC for Postgres
>
>
> I'm now deploying my Postgresql backend for Access solution
> to the customer. The customer has
> twenty-something odd workstations that may run clients but
> they are dispersed around the campus
> and would prefer not to have to physically send a support
> person to each workstation. The driver
> installation program is simple enough for me to just put it
> up on the network for users to click/run on
> their workstations. My question is how to get the system DSN
> installed on each workstation for my
> backend Postgres database connection? Can I write some script
> or something to make this happen
> automagically?
>
>     thanx & later,
>
>         Ben Scherrey
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>