Re: Deploying ODBC for Postgres
От | Dave Page |
---|---|
Тема | Re: Deploying ODBC for Postgres |
Дата | |
Msg-id | 03AF4E498C591348A42FC93DEA9661B884D2@mail.vale-housing.co.uk обсуждение исходный текст |
Ответ на | Deploying ODBC for Postgres (Benjamin Scherrey <scherrey@proteus-tech.com>) |
Список | 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@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 >
В списке pgsql-odbc по дате отправления: