Re: Need help with Visual Basic 6 and PostgreSQL - Mailing list pgsql-odbc
From | Richard Broersma Jr |
---|---|
Subject | Re: Need help with Visual Basic 6 and PostgreSQL |
Date | |
Msg-id | 225115.96835.qm@web31807.mail.mud.yahoo.com Whole thread Raw |
In response to | Re: Need help with Visual Basic 6 and PostgreSQL (Richard Broersma Jr <rabroersma@yahoo.com>) |
List | pgsql-odbc |
<table border="0" cellpadding="0" cellspacing="0"><tr><td style="font: inherit;"><p>--- On Fri, 11/23/07, Richard BroersmaJr <rabroersma@yahoo.com> wrote:<p>From the ODBC driver documentation, <p>here is the list of parameters thatyou can pass to the driver.<br /><p style="MARGIN-BOTTOM: 0cm"><font face="Times New Roman, serif"><font size="5"><b>Howto specify as a connection option </b></font></font><table border="1" cellpadding="4" cellspacing="3" style="page-break-inside:avoid" width="100%"><colgroup><col width="96" /><col width="80" /><col width="79" /><tbody><tr><tdwidth="38%"><b><font size="4">Definition</font></b></td><td width="31%"><b><font size="4">Keyword</font></b></td><tdwidth="31%"><font size="4"><b>Abbreviation</b></font></td></tr><tr><td width="38%">Datasource description </td><td width="31%">Description </td><td width="31%">Nothing </td></tr><tr><td width="38%">Nameof Server </td><td width="31%">Servername </td><td width="31%">Nothing </td></tr><tr><td width="38%">Postmasterlistening port </td><td width="31%">Port </td><td width="31%">Nothing </td></tr><tr><td width="38%">UserName </td><td width="31%">Username </td><td width="31%">Nothing </td></tr><tr><td width="38%">Password </td><tdwidth="31%">Password </td><td width="31%">Nothing </td></tr><tr><td width="38%">Debug flag </td><td width="31%">Debug</td><td width="31%">B2 </td></tr><tr><td width="38%">Fetch Max Count </td><td width="31%">Fetch </td><tdwidth="31%">A7 </td></tr><tr><td width="38%">Socket buffer size </td><td width="31%">Socket </td><td width="31%">A8</td></tr><tr><td width="38%">Database is read only </td><td width="31%">ReadOnly </td><td width="31%">A0 </td></tr><tr><tdwidth="38%">Communication to backend logging </td><td width="31%">CommLog </td><td width="31%">B3 </td></tr><tr><tdwidth="38%">PostgreSQL backend protocol </td><td width="31%">Protocol </td><td width="31%">A1 </td></tr><tr><tdwidth="38%">Backend enetic optimizer </td><td width="31%">Optimizer </td><td width="31%">B4 </td></tr><tr><tdwidth="38%">Keyset query optimization </td><td width="31%">Ksqo </td><td width="31%">B5 </td></tr><tr><tdwidth="38%">Send tobackend on connection </td><td width="31%">ConnSettings </td><td width="31%">A6 </td></tr><tr><tdwidth="38%">Recognize unique indexes </td><td width="31%">UniqueIndex </td><td width="31%">Nothing </td></tr><tr><tdwidth="38%">Unknownresult set sizes </td><td width="31%">UnknownSizes </td><td width="31%">A9 </td></tr><tr><tdwidth="38%">Cancel as FreeStmt </td><td width="31%">CancelAsFreeStmt </td><td width="31%">C1 </td></tr><tr><tdwidth="38%">Use Declare/Fetch cursors </td><td width="31%">UseDeclareFetch </td><td width="31%">B6 </td></tr><tr><tdwidth="38%">Text as LongVarchar </td><td width="31%">TextAsLongVarchar </td><td width="31%">B7 </td></tr><tr><tdwidth="38%">Unknowns as LongVarchar </td><td width="31%">UnknownsAsLongVarchar </td><td width="31%">B8 </td></tr><tr><tdwidth="38%">Bools as Char </td><td width="31%">BoolsAsChar </td><td width="31%">B9 </td></tr><tr><td width="38%">MaxVarchar size </td><td width="31%">MaxVarcharSize </td><td width="31%">B0 </td></tr><tr><td width="38%">MaxLongVarchar size </td><td width="31%">MaxLongVarcharSize </td><td width="31%">B1 </td></tr><tr><td width="38%">Fakesa unique index on OID </td><td width="31%">FakeOidIndex </td><td width="31%">A2 </td></tr><tr><td width="38%">Includesthe OID in SQLColumns </td><td width="31%">ShowOidColumn </td><td width="31%">A3 </td></tr><tr><td width="38%">RowVersioning </td><td width="31%">RowVersioning </td><td width="31%">A4 </td></tr><tr><td width="38%">Show SystemTables</td><td width="31%">ShowSystemTables </td><td width="31%">A5 </td></tr><tr><td width="38%">Parse Statements</td><td width="31%">Parse </td><td width="31%">C0 </td></tr><tr><td width="38%">SysTable Prefixes </td><td width="31%">ExtraSysTablePrefixes</td><td width="31%">C2 </td></tr><tr><td width="38%">Disallow Premature </td><td width="31%">DisallowPremature</td><td width="31%">C3 </td></tr><tr><td width="38%">Updateable Cursors </td><td width="31%">UpdatableCursors</td><td width="31%">C4 </td></tr><tr><td width="38%">LF <-> CR/LF conversion </td><tdwidth="31%">LFConversion </td><td width="31%">C5 </td></tr><tr><td width="38%">True is -1 </td><td width="31%">TrueIsMinus1</td><td width="31%">C6 </td></tr><tr><td width="38%">Datatype to report int8 columns as </td><tdwidth="31%">BI </td><td width="31%">Nothing </td></tr><tr><td width="38%">Bytea as LongVarBinary </td><td width="31%">ByteaAsLongVarBinary</td><td width="31%">C7 </td></tr><tr><td width="38%">Use serverside prepare </td><td width="31%">UseServerSidePrepare</td><td width="31%">C8 </td></tr><tr><td width="38%">Lower case identifier </td><td width="31%">LowerCaseIdentifier</td><td width="31%">C9 </td></tr><tr><td width="38%">SSL mode </td><td width="31%">SSLmode</td><td width="31%">CA </td></tr><tr><td width="38%">Extra options </td><td width="31%">AB </td><td width="31%">Nothing</td></tr><tr><td width="38%">Abbreviate(simple setup of a recommendation value) </td><td width="31%">CX</td><td width="31%">Nothing </td></tr></tbody></colgroup></table><br /></td></tr></table>
pgsql-odbc by date: