From: | Zlatko Matić <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr> |
---|---|
To: | <pgsql-odbc(at)postgresql(dot)org>, <pgsql-general(at)postgresql(dot)org> |
Subject: | ODBC connection string, MS Access |
Date: | 2005-12-22 08:57:23 |
Message-ID: | 000101c606f2$771142b0$6bff8353@zlatkovyfkpgz6 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-odbc |
Hello.
Could you, please, help me to optimize my connection string (MS Access 2003, PostgreSQL 8.1.1. and psqlodbc-08_01_0102)?
' PG_ODBC_PARAMETER ACCESS_PARAMETER
' *********************************************
' READONLY A0
' PROTOCOL A1
' FAKEOIDINDEX A2 'A2 must be 0 unless A3=1
' SHOWOIDCOLUMN A3
' ROWVERSIONING A4
' SHOWSYSTEMTABLES A5
' CONNSETTINGS A6
' FETCH A7
' SOCKET A8
' UNKNOWNSIZES A9 ' range [0-2]
' MAXVARCHARSIZE B0
' MAXLONGVARCHARSIZE B1
' DEBUG B2
' COMMLOG B3
' OPTIMIZER B4 ' note that 1 = _cancel_ generic optimizer...
' KSQO B5
' USEDECLAREFETCH B6
' TEXTASLONGVARCHAR B7
' UNKNOWNSASLONGVARCHAR B8
' BOOLSASCHAR B9
' PARSE C0
' CANCELASFREESTMT C1
' EXTRASYSTABLEPREFIXES C2
'Connection string
CONNECTIONSTRING:
strConnInfo = "ODBC;Driver=" & Driver & ";Server=" & SERVER & ";Port=" & PORT & ";Database=" & DATABASE & ";"
strConnUserPass = "Uid=" & USERNAME & ";Pwd=" & PASSWORD & ";"
strConnParms = "A0=0;A1=6.4;A2=0;A3=0;A4=1;A5=0;A6=" & A6 & ";A7=100;A8=" & SOCKET & ";A9=1;" & _
"B0=254;B1=8190;B2=0;B3=0;B4=1;B5=1;B6=0;B7=1;B8=0;B9=0;" & _
"C0=0;C1=0;C2=dd_;"
There are some options I don't understand, for example "Parse statements" and "Fetch/Declare" and don't know how would it affect performances...
Also, there is a problem with the limited length of connection string that Access can handle, so I have a problem that I can't input some bigger usernames and passwords. Therefore I would like to remove some unneccessary parameters, if possible. Which parameters could be safely removed?
Thanks in advance,
Zlatko
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2005-12-22 09:36:52 | Re: Is CREATE TYPE an alias for CREATE DOMAIN? |
Previous Message | John Sidney-Woollett | 2005-12-22 08:46:32 | Mem usage/leak - advice needed |
From | Date | Subject | |
---|---|---|---|
Next Message | noreply | 2005-12-22 18:57:19 | [ psqlodbc-Bugs-1000498 ] rollback to savepoint in case of error |
Previous Message | Ludek Finstrle | 2005-12-21 16:59:42 | Re: FW: PostgreSQL ODBC bug |