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: 03AF4E498C591348A42FC93DEA9661B884D2@mail.vale-housing.co.uk (view raw or flat)
Thread:
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.

[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(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-2014 The PostgreSQL Global Development Group