Skip site navigation (1) Skip section navigation (2)

Re: ODBC connection string, MS Access

From: Zlatko Matić <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr>
To: "Campbell, Greg" <greg(dot)campbell(at)us(dot)michelin(dot)com>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: ODBC connection string, MS Access
Date: 2005-12-26 18:05:18
Message-ID: 000101c60ace$0e993460$52bffea9@zlatkovyfkpgz6 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-odbc
Thanks. I removed most options, except some really important (strConnParms = 
"A0=0;A4=1;B7=1;B9=0;")

----- Original Message ----- 
From: "Campbell, Greg" <greg(dot)campbell(at)us(dot)michelin(dot)com>
To: "Zlatko Matić" <zlatko(dot)matic1(at)sb(dot)t-com(dot)hr>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Sent: Saturday, December 24, 2005 1:17 AM
Subject: Re: [ODBC] ODBC connection string, MS Access


Have you tried not specifying anything other than Driver, Server, Database, 
UID, PWD?

Most items have a default like PORT defaults to 5432.



Zlatko Matić wrote:
> 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
>
>



--------------------------------------------------------------------------------



---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster


In response to

pgsql-odbc by date

Next:From: noreplyDate: 2005-12-26 21:47:05
Subject: [ psqlodbc-Bugs-1000506 ] Not all ODBC-Standard-Calls work correctly
Previous:From: Zlatko MatićDate: 2005-12-26 18:03:14
Subject: Re: ODBC connection string, MS Access

pgsql-general by date

Next:From: Benjamin AraiDate: 2005-12-26 18:19:33
Subject: Restoring 64 to x86
Previous:From: Zlatko MatićDate: 2005-12-26 18:03:14
Subject: Re: ODBC connection string, MS Access

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group