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

Re: Deploying ODBC for Postgres

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: "Benjamin Scherrey" <scherrey(at)proteus-tech(dot)com>,<pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Deploying ODBC for Postgres
Date: 2002-11-17 20:48:28
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc
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.





> -----Original Message-----
> From: Benjamin Scherrey [mailto:scherrey(at)proteus-tech(dot)com] 
> Sent: 17 November 2002 20:34
> To: pgsql-odbc(at)postgresql(dot)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

pgsql-odbc by date

Next:From: Robert John ShepherdDate: 2002-11-17 22:15:18
Subject: FATAL 1: Sorry, too many clients already
Previous:From: Benjamin ScherreyDate: 2002-11-17 20:34:19
Subject: Deploying ODBC for Postgres

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