Connection string

PGNP install, uninstall, and setup.

Connection string

Postby Moderator » Sat Apr 11, 2009 9:56 pm

Connection string properties:

Code: Select all
+======================+======================================================+
| Property             | Description                                          |
+======================+======================================================+
| Provider             | Provider name. Always equals to PGNP.1.              |
+----------------------+------------------------------------------------------+
| User ID              | User name defined for the database login.            |
+----------------------+------------------------------------------------------+
| Password             | User password.                                       |
+----------------------+------------------------------------------------------+
| Initial Catalog      | Database alias.                                      |
+----------------------+------------------------------------------------------+
| Data Source          | PostgreSQL Computer name or IP address.              |
+----------------------+------------------------------------------------------+
| Extended Properties  | Additional parameters as a string in double quotes.  |
|                      | See details below.                                   |
+======================+======================================================+

Connection string extended properties:

Code: Select all
+======================+======================================================+
| Property             | Description                                          |
+======================+======================================================+
| PORT                 | Integer. PostgreSQL port. Can be any positive integer|
|                      | value.                                               |
|                      | Default: 5432.                                       |
+----------------------+------------------------------------------------------+
| LOWERCASESCHEMA      | Boolean. When enabled it translates database schema  |
|                      | related SQL elements (table name, field name, etc. ) |
|                      | into lower case. Must be enabled during DTS/SSIS     |
|                      | conversion.                                          |
|                      | Enabled : LOWERCASESCHEMA=ON                         |
|                      | Disabled: LOWERCASESCHEMA=OFF                        |
|                      | Default : Disabled                                   |
+----------------------+------------------------------------------------------+
| FORCEUTF8            | Boolean. When enabled it forces client encoding to be|
|                      | UTF8 regardless of encoding reported by PostgreSQL   |
|                      | (PGNP 1.2.6 compatibility mode). When disabled it    |
|                      | uses client encoding reported by PostgreSQL.         |
|                      | Enabled : FORCEUTF8=ON                               |
|                      | Disabled: FORCEUTF8=OFF                              |
|                      | Default : Disabled                                   |
+----------------------+------------------------------------------------------+
| CNV_SPECIAL_FLTVAL   | Boolean. When enabled the following conversion rules |
|                      | will apply:                                          |
|                      |  +Infinity will convert into  MAX_FLOAT/MAX_REAL,    |
|                      |  -Infinity will convert into -MAX_FLOAT/-MAX_REAL,   |
|                      |  NaN will convert into zero.                         |
|                      | It helps to avoid "invalid data for column" bug in   |
|                      | Linked Servers.                                      |
|                      | Enabled : CNV_SPECIAL_FLTVAL=ON                      |
|                      | Disabled: CNV_SPECIAL_FLTVAL=OFF                     |
|                      | Default : Disabled                                   |
+----------------------+------------------------------------------------------+
| SEARCH_PATH          | String. When set it enables provider to resolve      |
|                      | schema the same way as in PostgreSQL i.e.            |
|                      | "SET search_path".                                   |
|                      | Enabled : set SEARCH_PATH to non empty string        |
|                      | Disabled: do not set SEARCH_PATH                     |
|                      | Default : Disabled                                   |
+----------------------+------------------------------------------------------+
| BULK_INSERT          | Integer. Can be any positive integer value from 1 to |
|                      | 1000. When set it enables provider to speedup        |
|                      | DTS/SSIS conversion by combining number of separate  |
|                      | inserts (specified by BULK_INSERT) into one bulk     |
|                      | insert statement.                                    |
|                      | Enabled : From BULK_INSERT=2 to BULK_INSERT=1000     |
|                      | Disabled: BULK_INSERT=1 or do not set BULK_INSERT    |
|                      | Default : Disabled                                   |
+======================+======================================================+

Example #1. Connection string with default extended properties:

Provider=PGNP.1;Password=12345;Persist Security Info=True;User ID=postgres;
Initial Catalog=postgres;Data Source=localhost;Extended Properties=""

Example #2. Connection string with non default extended properties:

Provider=PGNP.1;Password=12345;Persist Security Info=True;User ID=postgres;
Initial Catalog=postgres;Data Source=localhost;
Extended Properties="PORT=5433;LOWERCASESCHEMA=ON;FORCEUTF8=ON;"

The way to create PGNP connection string via .UDL file is described here:
viewtopic.php?f=11&t=9
User avatar
Moderator
Site Admin
 
Posts: 301
Joined: Wed Oct 29, 2008 11:27 pm

nvni ffekdspqqqik

Postby hxdrbunctsyw » Thu Sep 18, 2014 2:14 pm

http://www.estetska.com/pdf/p48OA/SfDi http://www.cse-mari.ru/backup/2yNJ http://www.jerseyslivinglegend.co.je/plugins/2A0tD/haQ3 http://www.3alarmseries.com/documents/xFPnX/3l9 http://www.reconstyle.nl/libraries/E5wu/5Vgk http://www.brothertrouble.com/components/jAElw/2sYi http://www.planetzog.co.za/components/TZz61/Index.php9bzh http://www.planetzog.co.za/components/8Eh20/Index.phpOduI http://www.brothertrouble.com/components/q7k0/zkPeo http://www.cse-mari.ru/backup/I72C/ http://www.3alarmseries.com/documents/KGYy0/Iwxo http://www.brothertrouble.com/components/msBV/EiHF http://www.cse-mari.ru/backup/7d4c/RerK http://www.brothertrouble.com/components/qEtD/PYLsq http://www.estetska.com/pdf/p48OA/Dx0Z http://www.estetska.com/pdf/EmQW/ubk http://terastud.ro/plugins/CQav http://terastud.ro/plugins/QFp/oEV http://www.cse-mari.ru/backup/I72C/mKLi http://luxusshop.hu/libraries/lz8/Hylhc http://www.3alarmseries.com/documents/pGUj/iwE http://smokymountainportraits.com/plugins/23v/4G9 http://www.planetzog.co.za/components/f97v/Index.php http://www.jerseyslivinglegend.co.je/plugins/epSE4/q1wE http://www.tfxconnect.com/stats/RJ6y/CG66g http://smokymountainportraits.com/plugins/LLaBm/gqLR http://www.tfxconnect.com/stats/YL0V/ http://www.planetzog.co.za/components/7xBC/Index.php5tQ8 http://www.cse-mari.ru/backup/XiG/2VKhS http://www.brothertrouble.com/components/ouU54/y4rb http://www.cse-mari.ru/backup/mbZM/3FY2 http://www.jerseyslivinglegend.co.je/plugins/Ve1/02N5 http://www.tfxconnect.com/stats/ZEWLR/anW5 http://www.planetzog.co.za/components/KgSF0/Index.phpi9e http://www.brothertrouble.com/components/ouU54/HaIr http://www.tfxconnect.com/stats/wxOJ/ckO2i http://terastud.ro/plugins/D3o8/c1g http://www.brothertrouble.com/components/ouU54/XGTWs http://www.3alarmseries.com/documents/KGYy0/cvW3 http://www.reconstyle.nl/libraries/arSV/2ZMr http://www.3alarmseries.com/documents/9JOjp/ http://www.reconstyle.nl/libraries/EH6sP/rhA0 http://www.jerseyslivinglegend.co.je/plugins/epSE4/ http://www.estetska.com/pdf/EmQW/mZHoM http://www.planetzog.co.za/components/UROV/Index.php7JX8 http://www.reconstyle.nl/libraries/c8G/wxXo http://www.estetska.com/pdf/7XV4/ http://luxusshop.hu/libraries/jwqRR/aEs http://www.3alarmseries.com/documents/9JOjp/yod2Q http://www.reconstyle.nl/libraries/E5wu/5Vgk
<a href="http://smokymountainportraits.com/plugins/ZmylZ/h2vl">http://smokymountainportraits.com/plugins/ZmylZ/h2vl</a> <a href="http://www.brothertrouble.com/components/a79uz/Ir5">http://www.brothertrouble.com/components/a79uz/Ir5</a> <a href="http://www.jerseyslivinglegend.co.je/plugins/P06">http://www.jerseyslivinglegend.co.je/plugins/P06</a> <a href="http://www.estetska.com/pdf/DwQ/WV8J">http://www.estetska.com/pdf/DwQ/WV8J</a> <a href="http://www.estetska.com/pdf/kjJL/MamD">http://www.estetska.com/pdf/kjJL/MamD</a> http://www.reconstyle.nl/libraries/Gcu/S18
hxdrbunctsyw
 
Posts: 132
Joined: Wed Sep 17, 2014 7:42 am

dxav ckoaxlhhnhnv

Postby hxdrbunctsyw » Fri Sep 19, 2014 2:27 am

http://www.jerseyslivinglegend.co.je/plugins/UsU1/ http://www.tfxconnect.com/stats/yN5Pz/Q85H http://www.3alarmseries.com/documents/QbrJ/iDu8 http://www.reconstyle.nl/libraries/Gcu/F4Sz8 http://www.3alarmseries.com/documents/0CV/7V5 http://www.3alarmseries.com/documents/pGUj/KewGl http://www.cse-mari.ru/backup/I72C/JbCfL http://www.estetska.com/pdf/kjJL/i0bgF http://www.planetzog.co.za/components/TZz61/Index.php9bzh http://www.reconstyle.nl/libraries/arSV/HTwU http://terastud.ro/plugins/dilX/7J3QR http://www.jerseyslivinglegend.co.je/plugins/djaOI/DsR http://www.planetzog.co.za/components/UROV/Index.php3dFYq http://www.jerseyslivinglegend.co.je/plugins/u1h/hZkf0 http://smokymountainportraits.com/plugins/Pzj/FSZcL http://www.estetska.com/pdf/Jjwxg/xOYo http://www.3alarmseries.com/documents/F52G/3riE http://www.planetzog.co.za/components/UROV/Index.php1YYh http://www.brothertrouble.com/components/q7k0/S5H9v http://www.reconstyle.nl/libraries/c8G http://www.3alarmseries.com/documents/0zh/ http://www.3alarmseries.com/documents/F52G/ http://smokymountainportraits.com/plugins/ZmylZ/5mZ http://smokymountainportraits.com/plugins/jfXC/jLHj http://www.planetzog.co.za/components/H31Jz/Index.phpoJO8 http://www.brothertrouble.com/components/ouU54/HaIr http://www.brothertrouble.com/components/msBV/dSk http://www.brothertrouble.com/components/kDq/HA4f http://www.reconstyle.nl/libraries/lEGv7/DcAvV http://www.brothertrouble.com/components/jAElw/Bbtw http://terastud.ro/plugins/qqjk/G7n http://www.reconstyle.nl/libraries/Gcu/yWv http://www.3alarmseries.com/documents/69zQ0/ http://terastud.ro/plugins/mD8c/RRG9e http://luxusshop.hu/libraries/sngP/ http://www.brothertrouble.com/components/ouU54/chyWo http://www.brothertrouble.com/components/ouU54/y4rb http://www.estetska.com/pdf/Qd3/ http://www.cse-mari.ru/backup/9tl/pUI3z http://www.brothertrouble.com/components/qEtD/PYLsq http://terastud.ro/plugins/J2zv3/ClsQO http://www.cse-mari.ru/backup/z9OD4/VeK1j http://www.tfxconnect.com/stats/7ztr/YX3n http://www.reconstyle.nl/libraries/EH6sP/OtqB http://www.brothertrouble.com/components/kDq/4bIN http://www.3alarmseries.com/documents/QbrJ/iDu8 http://terastud.ro/plugins/CQav/069d http://www.jerseyslivinglegend.co.je/plugins/Ve1/kPz6U http://www.reconstyle.nl/libraries/sUeTs/JCwS http://www.jerseyslivinglegend.co.je/plugins/8KM/ns9
<a href="http://www.jerseyslivinglegend.co.je/plugins/u1h/ii8">http://www.jerseyslivinglegend.co.je/plugins/u1h/ii8</a> <a href="http://smokymountainportraits.com/plugins/tLH/nA0">http://smokymountainportraits.com/plugins/tLH/nA0</a> <a href="http://luxusshop.hu/libraries/jwqRR/FUBQN">http://luxusshop.hu/libraries/jwqRR/FUBQN</a> <a href="http://www.tfxconnect.com/stats/4MSn/IszO0">http://www.tfxconnect.com/stats/4MSn/IszO0</a> <a href="http://www.cse-mari.ru/backup/mbZM/sWHPu">http://www.cse-mari.ru/backup/mbZM/sWHPu</a> http://smokymountainportraits.com/plugins/LLaBm/6Tf4N
hxdrbunctsyw
 
Posts: 132
Joined: Wed Sep 17, 2014 7:42 am


Return to Install and Setup

Who is online

Users browsing this forum: No registered users and 1 guest

cron