psqlODBC Experimental Enhanced branch

psqlODBC Experimental Enhanced branch

am 22.02.2006 16:45:14 von Dave Page

Some time ago I posted a message to the list pre-announcing the release
of an experimental version of psqlODBC. This release is now available
for testing and evaluation purposes from:

http://pgfoundry.org/frs/?group_id=3D1000125

THIS FILES ARE RELEASED FOR TESTING AND EVALUATION ONLY AND Are NOT
RECOMMENDED FOR PRODUCTION USE!

This release is based on a code branch made at roughly v07.03.0260 of
psqlODBC, and has been enhanced by Hiroshi Inoue and Hiroshi Saito to
include a similar feature set to the 08.01 driver series, specifically
with the addition of Kerberos and SSL support through the use of libpq,
as well as other changes detailed in the release notes.

This branch differs from 08.01 in that the libpq integration has been
approached in a totally different way to that taken by Anoop and Siva at
Pervasive. Of particular note is the this drivers ability to=20

The purpose of this release is to evaluate which libpq driver, 08.01 or
07.03 will make the most suitable basis for future psqlODBC versions.
Please test and evaluate it, examine the source code, benchmark it and
anything else you can think of, and post any opinions to the mailing
list. Bear in mind that this experimental branch has not had anything
like the testing that 08.01 has, and that any resulting bugs need not
necessarily mean that it is not the better driver to continue
development with.

Regards, Dave.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: psqlODBC Experimental Enhanced branch

am 22.02.2006 16:47:00 von Dave Page

=20

> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org=20
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Dave Page
> Sent: 22 February 2006 15:45
> To: pgsql-odbc@postgresql.org
> Subject: [ODBC] psqlODBC Experimental Enhanced branch
>=20
> This branch differs from 08.01 in that the libpq integration has been
> approached in a totally different way to that taken by Anoop=20
> and Siva at
> Pervasive. Of particular note is the this drivers ability to=20

Drat - ignore that last half sentence!!

/D

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: psqlODBC Experimental Enhanced branch

am 28.02.2006 20:29:52 von George Weaver

From: "Dave Page"

>Please test and evaluate it, examine the source code, benchmark it and
>anything else you can think of, and post any opinions to the mailing
>list.

Hi Dave;

I have experienced an inconsistent error with all versions of the 8.1
driver up to an including 8.1.1.1. I don't get any error via ODBC but the
Microsoft "Unfortunately Microsoft has encountered an error and must exit
the application..." dialog box.

I have never experienced this problem with the 7.02 branch up to 7.02.00.05.

I installed 7.02.026 on February 22 and did not encounter any problem until
this morning.

I am running PostgreSQL 8.1.0 on i686-pc-mingw32, compiled by GCC gcc.exe
(GCC) 3.4.2 (mingw-special).

I am running a VB.NET 2003 application accessing the database (obviously)
via ODBC.

I cannot find any error notification in mylog or the psqlodbc log. In the
Windows event viewer the error message is:

Event Type: Error
Event Source: COM+
Event Category: Unknown
Event ID: 4786
Date: 28/02/2006
Time: 10:18:37 AM
User: N/A
Computer: DELL4500
Description:
The system has called a custom component and that component has failed
and generated an exception. This indicates a problem with the custom
component. Notify the developer of this component that a failure has
occurred and provide them with the information below.
Component Prog ID: 0[ODBC][C:\Program
Files\psqlODBC+\bin\psqlodbc35w.dll]
Method Name: IDispenserDriver::CreateResource
Process Name: FormsTest.exe
Exception: C0000005
Address: 0x036F5AFF
Call Stack:
psqlodbc35w!SQLGetDiagFieldW + 0x2AF

The error is totally inconsistent - I can go for days without experiencing
any problem; at other times it occurs frequently.

Any thoughts?

Regards,
George



---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Re: psqlODBC Experimental Enhanced branch

am 01.03.2006 02:18:06 von Hiroshi Inoue

George Weaver wrote:
>
> From: "Dave Page"
>
>> Please test and evaluate it, examine the source code, benchmark it and
>> anything else you can think of, and post any opinions to the mailing
>> list.
>
>
> Hi Dave;
>
> I have experienced an inconsistent error with all versions of the 8.1
> driver up to an including 8.1.1.1. I don't get any error via ODBC but
> the Microsoft "Unfortunately Microsoft has encountered an error and must
> exit the application..." dialog box.
>
> I have never experienced this problem with the 7.02 branch up to
> 7.02.00.05.
>
> I installed 7.02.026 on February 22 and did not encounter any problem
> until this morning.
>
> I am running PostgreSQL 8.1.0 on i686-pc-mingw32, compiled by GCC
> gcc.exe (GCC) 3.4.2 (mingw-special).
>
> I am running a VB.NET 2003 application accessing the database
> (obviously) via ODBC.
>
> I cannot find any error notification in mylog or the psqlodbc log.

Is there nothing in mylog output ? If so, are you turning on the Mylog
option in the "Pre-connection/default logging options" box ?
If thers's something in mylog, please send it to me.

regards,
Hiroshi Inoue


---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Re: psqlODBC Experimental Enhanced branch

am 01.03.2006 04:36:09 von George Weaver

This is a multi-part message in MIME format.

------=_NextPart_000_00B1_01C63CAE.FD02C0F0
Content-Type: text/plain;
format=flowed;
charset="iso-8859-1";
reply-type=response
Content-Transfer-Encoding: 7bit


----- Original Message -----
From: "Hiroshi Inoue"

> Is there nothing in mylog output ? If so, are you turning on the Mylog
> option in the "Pre-connection/default logging options" box ?
> If thers's something in mylog, please send it to me.

Hi Hiroshi,

Attached is a copy of the last mylog file when the error occurred.

Regards,
George

------=_NextPart_000_00B1_01C63CAE.FD02C0F0
Content-Type: application/octet-stream;
name="mylog_2916.log"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
filename="mylog_2916.log"

[2560]globals.extra_systable_prefixes =3D 'dd_;'=0A=
[2560][[SQLAllocHandle]][2560]**** in PGAPI_AllocEnv ** =
[2560]** exit PGAPI_AllocEnv: phenv =3D 3a13c80 **=0A=
[2560][[SQLSetEnvAttr]] att=3D200,3=0A=
[2560][[SQLAllocHandle]][2560]PGAPI_AllocConnect: entering...=0A=
[2560]**** PGAPI_AllocConnect: henv =3D 3a13c80, conn =3D 3a13cb8=0A=
[2560]EN_add_connection: self =3D 3a13c80, conn =3D 3a13cb8=0A=
[2560] added at i =3D0, conn->henv =3D 3a13c80, conns[i]->henv =3D 3a=
13c80=0A=
[2560][SQLGetInfoW(30)][2560]PGAPI_GetInfo: entering...fInfoType=3D77=0A=
[2560]PGAPI_GetInfo: p=3D'03.51', len=3D0, value=3D0, cbMax=3D12=0A=
[2560][SQLSetConnectAttrW][2560]PGAPI_SetConnectAttr 115 0=0A=
[2560]the application is unicode=0A=
[2560][SQLSetConnectAttrW][2560]PGAPI_SetConnectAttr 103 f=0A=
[2560]PGAPI_SetConnectOption: entering fOption =3D 103 vParam =3D 15=0A=
[2560][SQLDriverConnectW][2560]PGAPI_DriverConnect: entering...=0A=
[2560]**** PGAPI_DriverConnect: fDriverCompletion=3D0, connStrIn=3D'DSN=3Dt=
est703026;'=0A=
[2560]our_connect_string =3D 'DSN=3Dtest703026;'=0A=
[2560]attribute =3D 'DSN', value =3D 'test703026'=0A=
[2560]copyAttributes: DSN=3D'test703026',server=3D'',dbase=3D'',user=3D'',p=
asswd=3D'xxxxx',port=3D'',onlyread=3D'',protocol=3D'',conn_s ettings=3D'',di=
sallow_premature=3D-1)=0A=
[2560]globals.extra_systable_prefixes =3D 'dd_;'=0A=
[2560]globals.extra_systable_prefixes =3D 'dd_;'=0A=
[2560]our_connect_string =3D 'DSN=3Dtest703026;'=0A=
[2560]attribute =3D 'DSN', value =3D 'test703026'=0A=
[2560]CopyCommonAttributes: A7=3D100;A8=3D4096;A9=3D0;B0=3D254;B1=3D8190;B2=
=3D0;B3=3D0;B4=3D1;B5=3D1;B6=3D0;B7=3D1;B8=3D0;B9=3D1;C0=3D0 ;C1=3D0;C2=3Ddd=
_;[2560]PGAPI_Disconnect: about to CC_cleanup=0A=
[2560]in CC_Cleanup, self=3D3a13cb8=0A=
[2560]after CC_abort=0A=
[2560]SOCK_Destructor=0A=
[2560]after SOCK destructor=0A=
[2560]exit CC_Cleanup=0A=
[2560]PGAPI_Disconnect: done CC_cleanup=0A=
[2560]PGAPI_Disconnect: returning...=0A=
[2560][[SQLFreeHandle]][2560]PGAPI_FreeConnect: entering...=0A=
[2560]**** in PGAPI_FreeConnect: hdbc=3D3a13cb8=0A=
[2560]enter CC_Destructor, self=3D3a13cb8=0A=
[2560]in CC_Cleanup, self=3D3a13cb8=0A=
[2560]after SOCK destructor=0A=
[2560]exit CC_Cleanup=0A=
[2560]after CC_Cleanup=0A=
[2560]after free statement holders=0A=
[2560]exit CC_Destructor=0A=
[2560]PGAPI_FreeConnect: returning...=0A=
[2560][[SQLFreeHandle]][2560]**** in PGAPI_FreeEnv: env =3D 3a13c80 **=20=
=0A=
[2560]in EN_Destructor, self=3D3a13c80=0A=
[2560]exit EN_Destructor: rv =3D 1=0A=
[2560] ok=0A=
[2560][[SQLAllocHandle]][2560]**** in PGAPI_AllocEnv ** =
[2560]** exit PGAPI_AllocEnv: phenv =3D 3a120d0 **=0A=
[2560][[SQLSetEnvAttr]] att=3D200,3=0A=
[2560][[SQLAllocHandle]][2560]PGAPI_AllocConnect: entering...=0A=
[2560]**** PGAPI_AllocConnect: henv =3D 3a120d0, conn =3D 3b400a0=0A=
[2560]EN_add_connection: self =3D 3a120d0, conn =3D 3b400a0=0A=
[2560] added at i =3D0, conn->henv =3D 3a120d0, conns[i]->henv =3D 3a=
120d0=0A=
[2560][SQLGetInfoW(30)][2560]PGAPI_GetInfo: entering...fInfoType=3D77=0A=
[2560]PGAPI_GetInfo: p=3D'03.51', len=3D0, value=3D0, cbMax=3D12=0A=
[2560][SQLSetConnectAttrW][2560]PGAPI_SetConnectAttr 115 0=0A=
[2560]the application is unicode=0A=
[2560][SQLSetConnectAttrW][2560]PGAPI_SetConnectAttr 103 f=0A=
[2560]PGAPI_SetConnectOption: entering fOption =3D 103 vParam =3D 15=0A=
[2560][SQLDriverConnectW][2560]PGAPI_DriverConnect: entering...=0A=
[2560]**** PGAPI_DriverConnect: fDriverCompletion=3D0, connStrIn=3D'DSN=3Dt=
est703026;'=0A=
[2560]our_connect_string =3D 'DSN=3Dtest703026;'=0A=
[2560]attribute =3D 'DSN', value =3D 'test703026'=0A=
[2560]copyAttributes: DSN=3D'test703026',server=3D'',dbase=3D'',user=3D'',p=
asswd=3D'xxxxx',port=3D'',onlyread=3D'',protocol=3D'',conn_s ettings=3D'',di=
sallow_premature=3D-1)=0A=
[2560]globals.extra_systable_prefixes =3D 'dd_;'=0A=
[2560]globals.extra_systable_prefixes =3D 'dd_;'=0A=
[2560]our_connect_string =3D 'DSN=3Dtest703026;'=0A=
[2560]attribute =3D 'DSN', value =3D 'test703026'=0A=
[2560]CopyCommonAttributes: A7=3D100;A8=3D4096;A9=3D0;B0=3D254;B1=3D8190;B2=
=3D0;B3=3D0;B4=3D1;B5=3D1;B6=3D0;B7=3D1;B8=3D0;B9=3D1;C0=3D0 ;C1=3D0;C2=3Ddd=
_;[2560]PGAPI_Disconnect: about to CC_cleanup=0A=
[2560]in CC_Cleanup, self=3D3b400a0=0A=
[2560]after CC_abort=0A=
[2560]SOCK_Destructor=0A=
[2560]after SOCK destructor=0A=
[2560]exit CC_Cleanup=0A=
[2560]PGAPI_Disconnect: done CC_cleanup=0A=
[2560]PGAPI_Disconnect: returning...=0A=
[2560][[SQLFreeHandle]][2560]PGAPI_FreeConnect: entering...=0A=
[2560]**** in PGAPI_FreeConnect: hdbc=3D3b400a0=0A=
[2560]enter CC_Destructor, self=3D3b400a0=0A=
[2560]in CC_Cleanup, self=3D3b400a0=0A=
[2560]after SOCK destructor=0A=
[2560]exit CC_Cleanup=0A=
[2560]after CC_Cleanup=0A=
[2560]after free statement holders=0A=
[2560]exit CC_Destructor=0A=
[2560]PGAPI_FreeConnect: returning...=0A=
[2560][[SQLFreeHandle]][2560]**** in PGAPI_FreeEnv: env =3D 3a120d0 **=20=
=0A=
[2560]in EN_Destructor, self=3D3a120d0=0A=
[2560]exit EN_Destructor: rv =3D 1=0A=
[2560] ok=0A=
[2560][[SQLAllocHandle]][2560]**** in PGAPI_AllocEnv ** =
[2560]** exit PGAPI_AllocEnv: phenv =3D 3a1e178 **=0A=
[2560][[SQLSetEnvAttr]] att=3D200,3=0A=
[2560][[SQLAllocHandle]][2560]PGAPI_AllocConnect: entering...=0A=
[2560]**** PGAPI_AllocConnect: henv =3D 3a1e178, conn =3D 3b400a0=0A=
[2560]EN_add_connection: self =3D 3a1e178, conn =3D 3b400a0=0A=
[2560] added at i =3D0, conn->henv =3D 3a1e178, conns[i]->henv =3D 3a=
1e178=0A=
[2560][SQLGetInfoW(30)][2560]PGAPI_GetInfo: entering...fInfoType=3D77=0A=
[2560]PGAPI_GetInfo: p=3D'03.51', len=3D0, value=3D0, cbMax=3D12=0A=
[2560][SQLSetConnectAttrW][2560]PGAPI_SetConnectAttr 115 0=0A=
[2560]the application is unicode=0A=
[2560][SQLSetConnectAttrW][2560]PGAPI_SetConnectAttr 103 f=0A=
[2560]PGAPI_SetConnectOption: entering fOption =3D 103 vParam =3D 15=0A=
[2560][SQLDriverConnectW][2560]PGAPI_DriverConnect: entering...=0A=
[2560]**** PGAPI_DriverConnect: fDriverCompletion=3D0, connStrIn=3D'DSN=3Dt=
est703026;'=0A=
[2560]our_connect_string =3D 'DSN=3Dtest703026;'=0A=
[2560]attribute =3D 'DSN', value =3D 'test703026'=0A=
[2560]copyAttributes: DSN=3D'test703026',server=3D'',dbase=3D'',user=3D'',p=
asswd=3D'xxxxx',port=3D'',onlyread=3D'',protocol=3D'',conn_s ettings=3D'',di=
sallow_premature=3D-1)=0A=
[2560]globals.extra_systable_prefixes =3D 'dd_;'=0A=
[2560]globals.extra_systable_prefixes =3D 'dd_;'=0A=
[2560]our_connect_string =3D 'DSN=3Dtest703026;'=0A=
[2560]attribute =3D 'DSN', value =3D 'test703026'=0A=
[2560]CopyCommonAttributes: A7=3D100;A8=3D4096;A9=3D0;B0=3D254;B1=3D8190;B2=
=3D0;B3=3D0;B4=3D1;B5=3D1;B6=3D0;B7=3D1;B8=3D0;B9=3D1;C0=3D0 ;C1=3D0;C2=3Ddd=
_;[2560]PGAPI_Disconnect: about to CC_cleanup=0A=
[2560]in CC_Cleanup, self=3D3b400a0=0A=
[2560]after CC_abort=0A=
[2560]SOCK_Destructor=0A=
[2560]after SOCK destructor=0A=
[2560]exit CC_Cleanup=0A=
[2560]PGAPI_Disconnect: done CC_cleanup=0A=
[2560]PGAPI_Disconnect: returning...=0A=
[2560][[SQLFreeHandle]][2560]PGAPI_FreeConnect: entering...=0A=
[2560]**** in PGAPI_FreeConnect: hdbc=3D3b400a0=0A=
[2560]enter CC_Destructor, self=3D3b400a0=0A=
[2560]in CC_Cleanup, self=3D3b400a0=0A=
[2560]after SOCK destructor=0A=
[2560]exit CC_Cleanup=0A=
[2560]after CC_Cleanup=0A=
[2560]after free statement holders=0A=
[2560]exit CC_Destructor=0A=
[2560]PGAPI_FreeConnect: returning...=0A=
[2560][[SQLFreeHandle]][2560]**** in PGAPI_FreeEnv: env =3D 3a1e178 **=20=
=0A=
[2560]in EN_Destructor, self=3D3a1e178=0A=
[2560]exit EN_Destructor: rv =3D 1=0A=
[2560] ok=0A=
[2560][[SQLAllocHandle]][2560]**** in PGAPI_AllocEnv ** =
[2560]** exit PGAPI_AllocEnv: phenv =3D 3a1ffd0 **=0A=
[2560][[SQLSetEnvAttr]] att=3D200,3=0A=
[2560][[SQLAllocHandle]][2560]PGAPI_AllocConnect: entering...=0A=
[2560]**** PGAPI_AllocConnect: henv =3D 3a1ffd0, conn =3D 3b400a0=0A=
[2560]EN_add_connection: self =3D 3a1ffd0, conn =3D 3b400a0=0A=
[2560] added at i =3D0, conn->henv =3D 3a1ffd0, conns[i]->henv =3D 3a=
1ffd0=0A=
[2560][SQLGetInfoW(30)][2560]PGAPI_GetInfo: entering...fInfoType=3D77=0A=
[2560]PGAPI_GetInfo: p=3D'03.51', len=3D0, value=3D0, cbMax=3D12=0A=
[2560][SQLSetConnectAttrW][2560]PGAPI_SetConnectAttr 115 0=0A=
[2560]the application is unicode=0A=
[2560][SQLSetConnectAttrW][2560]PGAPI_SetConnectAttr 103 f=0A=
[2560]PGAPI_SetConnectOption: entering fOption =3D 103 vParam =3D 15=0A=
[2560][SQLDriverConnectW][2560]PGAPI_DriverConnect: entering...=0A=
[2560]**** PGAPI_DriverConnect: fDriverCompletion=3D0, connStrIn=3D'DSN=3Dt=
est703026;'=0A=
[2560]our_connect_string =3D 'DSN=3Dtest703026;'=0A=
[2560]attribute =3D 'DSN', value =3D 'test703026'=0A=
[2560]copyAttributes: DSN=3D'test703026',server=3D'',dbase=3D'',user=3D'',p=
asswd=3D'xxxxx',port=3D'',onlyread=3D'',protocol=3D'',conn_s ettings=3D'',di=
sallow_premature=3D-1)=0A=
[2560]globals.extra_systable_prefixes =3D 'dd_;'=0A=
[2560]globals.extra_systable_prefixes =3D 'dd_;'=0A=
[2560]our_connect_string =3D 'DSN=3Dtest703026;'=0A=
[2560]attribute =3D 'DSN', value =3D 'test703026'=0A=
[2560]CopyCommonAttributes: A7=3D100;A8=3D4096;A9=3D0;B0=3D254;B1=3D8190;B2=
=3D0;B3=3D0;B4=3D1;B5=3D1;B6=3D0;B7=3D1;B8=3D0;B9=3D1;C0=3D0 ;C1=3D0;C2=3Ddd=
_;[2560]PGAPI_Disconnect: about to CC_cleanup=0A=
[2560]in CC_Cleanup, self=3D3b400a0=0A=
[2560]after CC_abort=0A=
[2560]SOCK_Destructor=0A=
[2560]after SOCK destructor=0A=
[2560]exit CC_Cleanup=0A=
[2560]PGAPI_Disconnect: done CC_cleanup=0A=
[2560]PGAPI_Disconnect: returning...=0A=
[2560][[SQLFreeHandle]][2560]PGAPI_FreeConnect: entering...=0A=
[2560]**** in PGAPI_FreeConnect: hdbc=3D3b400a0=0A=
[2560]enter CC_Destructor, self=3D3b400a0=0A=
[2560]in CC_Cleanup, self=3D3b400a0=0A=
[2560]after SOCK destructor=0A=
[2560]exit CC_Cleanup=0A=
[2560]after CC_Cleanup=0A=
[2560]after free statement holders=0A=
[2560]exit CC_Destructor=0A=
[2560]PGAPI_FreeConnect: returning...=0A=
[2560][[SQLFreeHandle]][2560]**** in PGAPI_FreeEnv: env =3D 3a1ffd0 **=20=
=0A=
[2560]in EN_Destructor, self=3D3a1ffd0=0A=
[2560]exit EN_Destructor: rv =3D 1=0A=
[2560] ok=0A=
[2560][[SQLAllocHandle]][2560]**** in PGAPI_AllocEnv ** =
[2560]** exit PGAPI_AllocEnv: phenv =3D 3a12188 **=0A=
[2560][[SQLSetEnvAttr]] att=3D200,3=0A=
[2560][[SQLAllocHandle]][2560]PGAPI_AllocConnect: entering...=0A=
[2560]**** PGAPI_AllocConnect: henv =3D 3a12188, conn =3D 3b400a0=0A=
[2560]EN_add_connection: self =3D 3a12188, conn =3D 3b400a0=0A=
[2560] added at i =3D0, conn->henv =3D 3a12188, conns[i]->henv =3D 3a=
12188=0A=
[2560][SQLGetInfoW(30)][2560]PGAPI_GetInfo: entering...fInfoType=3D77=0A=
[2560]PGAPI_GetInfo: p=3D'03.51', len=3D0, value=3D0, cbMax=3D12=0A=
[2560][SQLSetConnectAttrW][2560]PGAPI_SetConnectAttr 115 0=0A=
[2560]the application is unicode=0A=
[2560][SQLSetConnectAttrW][2560]PGAPI_SetConnectAttr 103 f=0A=
[2560]PGAPI_SetConnectOption: entering fOption =3D 103 vParam =3D 15=0A=
[2560][SQLDriverConnectW][2560]PGAPI_DriverConnect: entering...=0A=
[2560]**** PGAPI_DriverConnect: fDriverCompletion=3D0, connStrIn=3D'DSN=3Dt=
est703026;'=0A=
[2560]our_connect_string =3D 'DSN=3Dtest703026;'=0A=
[2560]attribute =3D 'DSN', value =3D 'test703026'=0A=
[2560]copyAttributes: DSN=3D'test703026',server=3D'',dbase=3D'',user=3D'',p=
asswd=3D'xxxxx',port=3D'',onlyread=3D'',protocol=3D'',conn_s ettings=3D'',di=
sallow_premature=3D-1)=0A=
[2560]globals.extra_systable_prefixes =3D 'dd_;'=0A=
[2560]globals.extra_systable_prefixes =3D 'dd_;'=0A=
[2560]our_connect_string =3D 'DSN=3Dtest703026;'=0A=
[2560]attribute =3D 'DSN', value =3D 'test703026'=0A=
[2560]CopyCommonAttributes: A7=3D100;A8=3D4096;A9=3D0;B0=3D254;B1=3D8190;B2=
=3D0;B3=3D0;B4=3D1;B5=3D1;B6=3D0;B7=3D1;B8=3D0;B9=3D1;C0=3D0 ;C1=3D0;C2=3Ddd=
_;[2560]PGAPI_Disconnect: about to CC_cleanup=0A=
[2560]in CC_Cleanup, self=3D3b400a0=0A=
[2560]after CC_abort=0A=
[2560]SOCK_Destructor=0A=
[2560]after SOCK destructor=0A=
[2560]exit CC_Cleanup=0A=
[2560]PGAPI_Disconnect: done CC_cleanup=0A=
[2560]PGAPI_Disconnect: returning...=0A=
[2560][[SQLFreeHandle]][2560]PGAPI_FreeConnect: entering...=0A=
[2560]**** in PGAPI_FreeConnect: hdbc=3D3b400a0=0A=
[2560]enter CC_Destructor, self=3D3b400a0=0A=
[2560]in CC_Cleanup, self=3D3b400a0=0A=
[2560]after SOCK destructor=0A=
[2560]exit CC_Cleanup=0A=
[2560]after CC_Cleanup=0A=
[2560]after free statement holders=0A=
[2560]exit CC_Destructor=0A=
[2560]PGAPI_FreeConnect: returning...=0A=
[2560][[SQLFreeHandle]][2560]**** in PGAPI_FreeEnv: env =3D 3a12188 **=20=
=0A=
[2560]in EN_Destructor, self=3D3a12188=0A=
[2560]exit EN_Destructor: rv =3D 1=0A=
[2560] ok=0A=
[2560][[SQLAllocHandle]][2560]**** in PGAPI_AllocEnv ** =
[2560]** exit PGAPI_AllocEnv: phenv =3D 3a1e048 **=0A=
[2560][[SQLSetEnvAttr]] att=3D200,3=0A=
[2560][[SQLAllocHandle]][2560]PGAPI_AllocConnect: entering...=0A=
[2560]**** PGAPI_AllocConnect: henv =3D 3a1e048, conn =3D 3b400a0=0A=
[2560]EN_add_connection: self =3D 3a1e048, conn =3D 3b400a0=0A=
[2560] added at i =3D0, conn->henv =3D 3a1e048, conns[i]->henv =3D 3a=
1e048=0A=
[2560][SQLGetInfoW(30)][2560]PGAPI_GetInfo: entering...fInfoType=3D77=0A=
[2560]PGAPI_GetInfo: p=3D'03.51', len=3D0, value=3D0, cbMax=3D12=0A=
[2560][SQLSetConnectAttrW][2560]PGAPI_SetConnectAttr 115 0=0A=
[2560]the application is unicode=0A=
[2560][SQLSetConnectAttrW][2560]PGAPI_SetConnectAttr 103 f=0A=
[2560]PGAPI_SetConnectOption: entering fOption =3D 103 vParam =3D 15=0A=
[2560][SQLDriverConnectW][2560]PGAPI_DriverConnect: entering...=0A=
[2560]**** PGAPI_DriverConnect: fDriverCompletion=3D0, connStrIn=3D'DSN=3Dt=
est703026;'=0A=
[2560]our_connect_string =3D 'DSN=3Dtest703026;'=0A=
[2560]attribute =3D 'DSN', value =3D 'test703026'=0A=
[2560]copyAttributes: DSN=3D'test703026',server=3D'',dbase=3D'',user=3D'',p=
asswd=3D'xxxxx',port=3D'',onlyread=3D'',protocol=3D'',conn_s ettings=3D'',di=
sallow_premature=3D-1)=0A=
[2560]globals.extra_systable_prefixes =3D 'dd_;'=0A=
[2560]globals.extra_systable_prefixes =3D 'dd_;'=0A=
[2560]our_connect_string =3D 'DSN=3Dtest703026;'=0A=
[2560]attribute =3D 'DSN', value =3D 'test703026'=0A=
[2560]CopyCommonAttributes: A7=3D100;A8=3D4096;A9=3D0;B0=3D254;B1=3D8190;B2=
=3D0;B3=3D0;B4=3D1;B5=3D1;B6=3D0;B7=3D1;B8=3D0;B9=3D1;C0=3D0 ;C1=3D0;C2=3Ddd=
_;[2560]PGAPI_Disconnect: about to CC_cleanup=0A=
[2560]in CC_Cleanup, self=3D3b400a0=0A=
[2560]after CC_abort=0A=
[2560]SOCK_Destructor=0A=
[2560]after SOCK destructor=0A=
[2560]exit CC_Cleanup=0A=
[2560]PGAPI_Disconnect: done CC_cleanup=0A=
[2560]PGAPI_Disconnect: returning...=0A=
[2560][[SQLFreeHandle]][2560]PGAPI_FreeConnect: entering...=0A=
[2560]**** in PGAPI_FreeConnect: hdbc=3D3b400a0=0A=
[2560]enter CC_Destructor, self=3D3b400a0=0A=
[2560]in CC_Cleanup, self=3D3b400a0=0A=
[2560]after SOCK destructor=0A=
[2560]exit CC_Cleanup=0A=
[2560]after CC_Cleanup=0A=
[2560]after free statement holders=0A=
[2560]exit CC_Destructor=0A=
[2560]PGAPI_FreeConnect: returning...=0A=
[2560][[SQLFreeHandle]][2560]**** in PGAPI_FreeEnv: env =3D 3a1e048 **=20=
=0A=
[2560]in EN_Destructor, self=3D3a1e048=0A=
[2560]exit EN_Destructor: rv =3D 1=0A=
[2560] ok=0A=
[2560][[SQLAllocHandle]][2560]**** in PGAPI_AllocEnv ** =
[2560]** exit PGAPI_AllocEnv: phenv =3D 3b42d50 **=0A=
[2560][[SQLSetEnvAttr]] att=3D200,3=0A=
[2560][[SQLAllocHandle]][2560]PGAPI_AllocConnect: entering...=0A=
[2560]**** PGAPI_AllocConnect: henv =3D 3b42d50, conn =3D 3b400a0=0A=
[2560]EN_add_connection: self =3D 3b42d50, conn =3D 3b400a0=0A=
[2560] added at i =3D0, conn->henv =3D 3b42d50, conns[i]->henv =3D 3b=
42d50=0A=
[2560][SQLGetInfoW(30)][2560]PGAPI_GetInfo: entering...fInfoType=3D77=0A=
[2560]PGAPI_GetInfo: p=3D'03.51', len=3D0, value=3D0, cbMax=3D12=0A=
[2560][SQLSetConnectAttrW][2560]PGAPI_SetConnectAttr 115 0=0A=
[2560]the application is unicode=0A=
[2560][SQLSetConnectAttrW][2560]PGAPI_SetConnectAttr 103 f=0A=
[2560]PGAPI_SetConnectOption: entering fOption =3D 103 vParam =3D 15=0A=
[2560][SQLDriverConnectW][2560]PGAPI_DriverConnect: entering...=0A=
[2560]**** PGAPI_DriverConnect: fDriverCompletion=3D0, connStrIn=3D'DSN=3Dt=
est703026;'=0A=
[2560]our_connect_string =3D 'DSN=3Dtest703026;'=0A=
[2560]attribute =3D 'DSN', value =3D 'test703026'=0A=
[2560]copyAttributes: DSN=3D'test703026',server=3D'',dbase=3D'',user=3D'',p=
asswd=3D'xxxxx',port=3D'',onlyread=3D'',protocol=3D'',conn_s ettings=3D'',di=
sallow_premature=3D-1)=0A=
[2560]globals.extra_systable_prefixes =3D 'dd_;'=0A=
[2560]globals.extra_systable_prefixes =3D 'dd_;'=0A=
[2560]our_connect_string =3D 'DSN=3Dtest703026;'=0A=
[2560]attribute =3D 'DSN', value =3D 'test703026'=0A=
[2560]CopyCommonAttributes: A7=3D100;A8=3D4096;A9=3D0;B0=3D254;B1=3D8190;B2=
=3D0;B3=3D0;B4=3D1;B5=3D1;B6=3D0;B7=3D1;B8=3D0;B9=3D1;C0=3D0 ;C1=3D0;C2=3Ddd=
_;[2560]PGAPI_Disconnect: about to CC_cleanup=0A=
[2560]in CC_Cleanup, self=3D3b400a0=0A=
[2560]after CC_abort=0A=
[2560]SOCK_Destructor=0A=
[2560]after SOCK destructor=0A=
[2560]exit CC_Cleanup=0A=
[2560]PGAPI_Disconnect: done CC_cleanup=0A=
[2560]PGAPI_Disconnect: returning...=0A=
[2560][[SQLFreeHandle]][2560]PGAPI_FreeConnect: entering...=0A=
[2560]**** in PGAPI_FreeConnect: hdbc=3D3b400a0=0A=
[2560]enter CC_Destructor, self=3D3b400a0=0A=
[2560]in CC_Cleanup, self=3D3b400a0=0A=
[2560]after SOCK destructor=0A=
[2560]exit CC_Cleanup=0A=
[2560]after CC_Cleanup=0A=
[2560]after free statement holders=0A=
[2560]exit CC_Destructor=0A=
[2560]PGAPI_FreeConnect: returning...=0A=
[2560][[SQLFreeHandle]][2560]**** in PGAPI_FreeEnv: env =3D 3b42d50 **=20=
=0A=
[2560]in EN_Destructor, self=3D3b42d50=0A=
[2560]exit EN_Destructor: rv =3D 1=0A=
[2560] ok=0A=
[2560][[SQLAllocHandle]][2560]**** in PGAPI_AllocEnv ** =
[2560]** exit PGAPI_AllocEnv: phenv =3D 3a12188 **=0A=
[2560][[SQLSetEnvAttr]] att=3D200,3=0A=
[2560][[SQLAllocHandle]][2560]PGAPI_AllocConnect: entering...=0A=
[2560]**** PGAPI_AllocConnect: henv =3D 3a12188, conn =3D 3b400a0=0A=
[2560]EN_add_connection: self =3D 3a12188, conn =3D 3b400a0=0A=
[2560] added at i =3D0, conn->henv =3D 3a12188, conns[i]->henv =3D 3a=
12188=0A=
[2560][SQLGetInfoW(30)][2560]PGAPI_GetInfo: entering...fInfoType=3D77=0A=
[2560]PGAPI_GetInfo: p=3D'03.51', len=3D0, value=3D0, cbMax=3D12=0A=
[2560][SQLSetConnectAttrW][2560]PGAPI_SetConnectAttr 115 0=0A=
[2560]the application is unicode=0A=
[2560][SQLSetConnectAttrW][2560]PGAPI_SetConnectAttr 103 f=0A=
[2560]PGAPI_SetConnectOption: entering fOption =3D 103 vParam =3D 15=0A=
[2560][SQLDriverConnectW][2560]PGAPI_DriverConnect: entering...=0A=
[2560]**** PGAPI_DriverConnect: fDriverCompletion=3D0, connStrIn=3D'DSN=3Dt=
est703026;'=0A=
[2560]our_connect_string =3D 'DSN=3Dtest703026;'=0A=
[2560]attribute =3D 'DSN', value =3D 'test703026'=0A=
[2560]copyAttributes: DSN=3D'test703026',server=3D'',dbase=3D'',user=3D'',p=
asswd=3D'xxxxx',port=3D'',onlyread=3D'',protocol=3D'',conn_s ettings=3D'',di=
sallow_premature=3D-1)=0A=
[2560]globals.extra_systable_prefixes =3D 'dd_;'=0A=
[2560]globals.extra_systable_prefixes =3D 'dd_;'=0A=
[2560]our_connect_string =3D 'DSN=3Dtest703026;'=0A=
[2560]attribute =3D 'DSN', value =3D 'test703026'=0A=
[2560]CopyCommonAttributes: A7=3D100;A8=3D4096;A9=3D0;B0=3D254;B1=3D8190;B2=
=3D0;B3=3D0;B4=3D1;B5=3D1;B6=3D0;B7=3D1;B8=3D0;B9=3D1;C0=3D0 ;C1=3D0;C2=3Ddd=
_;[2560]PGAPI_Disconnect: about to CC_cleanup=0A=
[2560]in CC_Cleanup, self=3D3b400a0=0A=
[2560]after CC_abort=0A=
[2560]SOCK_Destructor=0A=
[2560]after SOCK destructor=0A=
[2560]exit CC_Cleanup=0A=
[2560]PGAPI_Disconnect: done CC_cleanup=0A=
[2560]PGAPI_Disconnect: returning...=0A=
[2560][[SQLFreeHandle]][2560]PGAPI_FreeConnect: entering...=0A=
[2560]**** in PGAPI_FreeConnect: hdbc=3D3b400a0=0A=
[2560]enter CC_Destructor, self=3D3b400a0=0A=
[2560]in CC_Cleanup, self=3D3b400a0=0A=
[2560]after SOCK destructor=0A=
[2560]exit CC_Cleanup=0A=
[2560]after CC_Cleanup=0A=
[2560]after free statement holders=0A=
[2560]exit CC_Destructor=0A=
[2560]PGAPI_FreeConnect: returning...=0A=
[2560][[SQLFreeHandle]][2560]**** in PGAPI_FreeEnv: env =3D 3a12188 **=20=
=0A=
[2560]in EN_Destructor, self=3D3a12188=0A=
[2560]exit EN_Destructor: rv =3D 1=0A=
[2560] ok=0A=
[2560][[SQLAllocHandle]][2560]**** in PGAPI_AllocEnv ** =
[2560]** exit PGAPI_AllocEnv: phenv =3D 3a120d0 **=0A=
[2560][[SQLSetEnvAttr]] att=3D200,3=0A=
[2560][[SQLAllocHandle]][2560]PGAPI_AllocConnect: entering...=0A=
[2560]**** PGAPI_AllocConnect: henv =3D 3a120d0, conn =3D 3b400a0=0A=
[2560]EN_add_connection: self =3D 3a120d0, conn =3D 3b400a0=0A=
[2560] added at i =3D0, conn->henv =3D 3a120d0, conns[i]->henv =3D 3a=
120d0=0A=
[2560][SQLGetInfoW(30)][2560]PGAPI_GetInfo: entering...fInfoType=3D77=0A=
[2560]PGAPI_GetInfo: p=3D'03.51', len=3D0, value=3D0, cbMax=3D12=0A=
[2560][SQLSetConnectAttrW][2560]PGAPI_SetConnectAttr 115 0=0A=
[2560]the application is unicode=0A=
[2560][SQLSetConnectAttrW][2560]PGAPI_SetConnectAttr 103 f=0A=
[2560]PGAPI_SetConnectOption: entering fOption =3D 103 vParam =3D 15=0A=
[2560][SQLDriverConnectW][2560]PGAPI_DriverConnect: entering...=0A=
[2560]**** PGAPI_DriverConnect: fDriverCompletion=3D0, connStrIn=3D'DSN=3Dt=
est703026;'=0A=
[2560]our_connect_string =3D 'DSN=3Dtest703026;'=0A=
[2560]attribute =3D 'DSN', value =3D 'test703026'=0A=
[2560]copyAttributes: DSN=3D'test703026',server=3D'',dbase=3D'',user=3D'',p=
asswd=3D'xxxxx',port=3D'',onlyread=3D'',protocol=3D'',conn_s ettings=3D'',di=
sallow_premature=3D-1)=0A=
[2560]globals.extra_systable_prefixes =3D 'dd_;'=0A=
[2560]globals.extra_systable_prefixes =3D 'dd_;'=0A=
[2560]our_connect_string =3D 'DSN=3Dtest703026;'=0A=
[2560]attribute =3D 'DSN', value =3D 'test703026'=0A=
[2560]CopyCommonAttributes: A7=3D100;A8=3D4096;A9=3D0;B0=3D254;B1=3D8190;B2=
=3D0;B3=3D0;B4=3D1;B5=3D1;B6=3D0;B7=3D1;B8=3D0;B9=3D1;C0=3D0 ;C1=3D0;C2=3Ddd=
_;=

------=_NextPart_000_00B1_01C63CAE.FD02C0F0
Content-Type: text/plain
Content-Disposition: inline
MIME-Version: 1.0
Content-Transfer-Encoding: quoted-printable


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

------=_NextPart_000_00B1_01C63CAE.FD02C0F0--

Re: psqlODBC Experimental Enhanced branch

am 01.03.2006 14:31:43 von George Weaver

----- Original Message -----
From: "Hiroshi Inoue"

>
> Are you turning on the mylog option per DataSource ?
>

No, the log I forwarded was from the Global mylog setting. I have now set
to DataSource, but I'll have to wait until the error recurs before I can
forward a copy of the log....

Am I correct that only one of the sources should be set? I have unchecked
the mylog setting for Global.

Regards,
George



---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Re: psqlODBC Experimental Enhanced branch

am 01.03.2006 14:37:51 von Hiroshi Inoue

George Weaver wrote:

>
> ----- Original Message ----- From: "Hiroshi Inoue"
>
>>
>> Are you turning on the mylog option per DataSource ?
>>
>
> No, the log I forwarded was from the Global mylog setting. I have now
> set to DataSource, but I'll have to wait until the error recurs before
> I can forward a copy of the log....
>
> Am I correct that only one of the sources should be set? I have
> unchecked the mylog setting for Global.


Please check both for debugging.

regards,
Hiroshi Inoue

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings