From: Hardeep Sharma <Hardeep.Sharma@macquarie.com>
To: "pgsql-odbc@postgresql.org" <pgsql-odbc@postgresql.org>
Subject: Postgres ODBC 32 bit driver
Thread-Topic: Postgres ODBC 32 bit driver
Thread-Index: AdfKBD0uAdLMkizjQbWv7HhplnE25Q==
Date: Tue, 26 Oct 2021 01:55:09 +0000
Message-ID: 
 <ME3PR01MB5750209B6C1196E4A3E26A9784849@ME3PR01MB5750.ausprd01.prod.outlook.com>
Accept-Language: en-AU, en-US
Content-Language: en-US
msip_labels: MSIP_Label_bff60613-a741-4790-ba46-c6813ca61c58_Enabled=true;
 MSIP_Label_bff60613-a741-4790-ba46-c6813ca61c58_SetDate=2021-10-26T00:55:33Z;
 MSIP_Label_bff60613-a741-4790-ba46-c6813ca61c58_Method=Standard;
 MSIP_Label_bff60613-a741-4790-ba46-c6813ca61c58_Name=Confidential;
 MSIP_Label_bff60613-a741-4790-ba46-c6813ca61c58_SiteId=568a5434-7d3f-4714-b824-fe722e2748c0;
 MSIP_Label_bff60613-a741-4790-ba46-c6813ca61c58_ActionId=00cb8b12-0f1b-48c2-a30d-b81b384ee54e;
 MSIP_Label_bff60613-a741-4790-ba46-c6813ca61c58_ContentBits=0
x-ms-publictraffictype: Email
x-ms-office365-filtering-correlation-id: 59c60572-120e-4157-fcb3-08d99823a44a
x-ms-traffictypediagnostic: MEXPR01MB1269:
x-microsoft-antispam-prvs: 
 <MEXPR01MB126996890B55F81272126DA284849@MEXPR01MB1269.ausprd01.prod.outlook.com>
x-ms-oob-tlc-oobclassifiers: OLM:8882;
x-ms-exchange-senderadcheck: 1
x-ms-exchange-antispam-relay: 0
x-microsoft-antispam: BCL:0;
x-microsoft-antispam-message-info: 
 2BFWYjufhVoqHD+V4hrmB20oNrmW4Oe0h5lFm5Nz6jQzKcMFnpZIce6fmdboE94t2h75OZWX2bRCkLY47rITFsI1fK1ERYsmckLAFlit9DpIaqLWhRnFibIUoyGgBQNZQ1agne7Cb62eRZG1YLdScGAmbJbaaH25V6uDlbAYw8MgHQTqRn6LlKZftuVhpVvGE2s4Gf1B+nVQFx0qFMQVO1Ewzls7kNkBIe/plBYQi0rfi6JYezLdv+GnWc4OeQXUcCvfJ8/Y56DTSHXdp1Whlsd3FTEHZ+CXXLl1cI4V08f/up54e+/h87GKJOubZPPzmpiDpgkfej/gVy59IiCf5yWM+yEZ3KGkQ8xjf083NTk3BzS7pbDL286h8mZGnJu192PfVtxhvMf5fq1hLF1UZ0plr+bEzzxj4c26Sq62it1Is9Q3byI0Y6JIXuIAPu3a+K73crM9e5DKUqariVahl6kbDBnjON76Xv7BWspn3GrNr1Px/xnj9Gu5VXzKxEuKNTxWxh7KRgSWSHvSPM0Ttr4hwv3IZjKHaps5D5BeJUXo7eOSRyzovzWh4qmTNeU8kXb29BudObLa69k9WgIiAsnTIbhgY8mv7W5D/gVDl9rvBRKxtv4WxvvcrR8KXL1rDvpXwKLY8Ed4gdfayzatEixhJcOrBUX57zgo99BSK7WT9JWWhYWiGnHeAH0dUB6Gb0zgDmnvviA4fwlVTNwOeg==
x-forefront-antispam-report: 
 CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:ME3PR01MB5750.ausprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(366004)(83380400001)(52536014)(7696005)(186003)(86362001)(38070700005)(316002)(26005)(5660300002)(2906002)(76116006)(6506007)(6916009)(8936002)(508600001)(8676002)(38100700002)(66946007)(122000001)(4744005)(33656002)(66476007)(66556008)(71200400001)(9686003)(9326002)(64756008)(66446008)(55016002);DIR:OUT;SFP:1102;
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: 
 =?us-ascii?Q?B7wJ8FagA7chuEJNzkCkEqFwSjyL53BUaiwexegJqwXV8KtzYpOA/WJUVuhO?=
 =?us-ascii?Q?RiSnUzrArxtebhE0ITASN3DbvovPTNcbphHr80NFsFWbWpSMv6Gnxswq+hwu?=
 =?us-ascii?Q?IIdjyivvlaoo8VkrcQxUNuzROuUxekJx1M1ULdoVKEIbyIzf68BbaMY3Cfj5?=
 =?us-ascii?Q?cBuH9YzQWedgjHUGEDqYkEIGMMctfgifM2IZIpAVGYN9y4dBwn2tBYElxLER?=
 =?us-ascii?Q?iXTJRbViJROgY0n1tGUWPT66O7QvH6TCPH26d97gcvp9YAABC6Pulqb3HNnb?=
 =?us-ascii?Q?FN4ZBIScNoAD276f+QauB9wL6VQy8ae2v9IxMWUx/cI0bAFyHrcfzW1An+vx?=
 =?us-ascii?Q?XvinEVCs6+k6UjlOKCaKyTkBD8R13MrJs/pySquuDWBAktEjW4jV7LTeLjoP?=
 =?us-ascii?Q?20OXAmofG72zBLizPzVA7ogDnMXs+JI/RCVV/Uk3qroiRzIcDcWOXxgQX5pK?=
 =?us-ascii?Q?VtMuiwSSUfIsEarVhVmOTVkzegu0kQN59mEiCKrOEOo0uKeZl9lsaBteCMcN?=
 =?us-ascii?Q?CI9iiwft2tFhPS8covuBMg5ZbofwvKdA+T59t2uDnU0l7yWJ+IeQTo0/IeoQ?=
 =?us-ascii?Q?Bu+PHnMslVMWmuoagAisC5dmFhA7ZzhwFmyWGyoXaI3gWk8kX74ypP8k3i54?=
 =?us-ascii?Q?2/vLXCfiVpgoBSbLV0yAezbc3vbN8JL+ZQhSHaGVKsGgp7nNWJlFC7PXz2H+?=
 =?us-ascii?Q?JGsJwO0loOQwGg4SEMSu3J/wDBMaNzpaZIuJUY6ymin7PVQiys9q4sv6eBv4?=
 =?us-ascii?Q?Ec4FRnKnf4S1Kc4dgeKwBrOIQIckb3puWIiJbWPu+RdHSAEzL896+ERdOmTr?=
 =?us-ascii?Q?5MC3bohStD1aBkxocnK1VkgDOdggugaryAU3iovCC6DobCgn7oEr+GeQaka6?=
 =?us-ascii?Q?YSx/C+rfJ0juhhSXkpDkj2VZpjhlG1PDsHA3vZOZvxVLyo3GuvkKE2o1YRyF?=
 =?us-ascii?Q?i+XD0YkQ5XA3NuxDDreq8XT0Oh/eixfQ7dfsLA6osBe5qBd2vKBnh+HZe9Y7?=
 =?us-ascii?Q?mueBkyjRJ6gq1x2jw1iUImbHw/59EyUhW23seH+JHojSEM6SlyARygrNV6G1?=
 =?us-ascii?Q?f2uJJhdJA+P4TDdaM2xq1BxpAn1E6jre94yROeEwUmy1rfytzAHzJLgunyrr?=
 =?us-ascii?Q?34C8//iABvbMOF7GKPBQ0/pt1bfeawy+FyWdDZoxeO89+WYLb+so/fBxQeBH?=
 =?us-ascii?Q?Rb/+Dflc8uQvLDLP4pq6NBRhHIpFgfiLxT058JwqaeSK2DvAM6FWpFiAtZEI?=
 =?us-ascii?Q?afzsYDIHDHy8Q97hrBPTefsWfBqzWwuWFvTjLsE27/WAUKizncHSyP4K/tJe?=
 =?us-ascii?Q?xPxcbkU4IyR2cc5j42TcT9hQz8yqB35H2Kans60QQWfTmUfWBNm6Ao1c4cZB?=
 =?us-ascii?Q?77UXz/CmqF+U7w78as5UUlAcE0IgiQ2yu+uY8w3I2FRNFvIOzi8U/woE5tz9?=
 =?us-ascii?Q?rfo60941ZsA4UDsBXcxJ8WxY1nhNGbWCWm4XpZkR6bMtxkTOs1VVIFLfjAkz?=
 =?us-ascii?Q?Q3kWW+iS9NVieqFnsPLt2gIPyRqYcqhB8IbDDGIUIbDLlsYFmvDI7MueRTR0?=
 =?us-ascii?Q?LLLQtzA+IceulETliO3g70au3QCZlfmd3Cze71wrZkty0ao20ovM8SorHEYs?=
 =?us-ascii?Q?X93UNLmO26mp+feDSEss7LOdt6eD10UAfOH3VXQlYk0yUTl2T47sBAsDLyfC?=
 =?us-ascii?Q?zxUSCg=3D=3D?=
Content-Type: multipart/alternative;
	boundary="_000_ME3PR01MB5750209B6C1196E4A3E26A9784849ME3PR01MB5750ausp_"
MIME-Version: 1.0
X-OriginatorOrg: macquarie.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: ME3PR01MB5750.ausprd01.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 
 59c60572-120e-4157-fcb3-08d99823a44a
X-MS-Exchange-CrossTenant-originalarrivaltime: 26 Oct 2021 01:55:09.5090
 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 568a5434-7d3f-4714-b824-fe722e2748c0
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: 
 ROKA06eEFqUfN8VIOqkA7jqhkf5FTlMwJO/4Kc6ydH8nqhYMiv+GXq7jUoU0l6yMIygns0AE/Qg6A7RN7aZpN7XcnYGNbMGGvnVP/xic7pI=
X-MS-Exchange-Transport-CrossTenantHeadersStamped: MEXPR01MB1269
List-Id: <pgsql-odbc.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-odbc@lists.postgresql.org>
List-Owner: <mailto:pgsql-odbc-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-odbc>
Archived-At: 
 <https://www.postgresql.org/message-id/ME3PR01MB5750209B6C1196E4A3E26A9784849%40ME3PR01MB5750.ausprd01.prod.outlook.com>
Precedence: bulk

--_000_ME3PR01MB5750209B6C1196E4A3E26A9784849ME3PR01MB5750ausp_
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi Team,

I am working in Macquarie database team, and we are planning to migrate Sy=
base database to Postgres.

We are using a SAP ECDA product that allows data access within the heterog=
eneous database environment, but this product uses 32-bit architecture/lib=
s.

When I try to establish a connection from Sybase to Postgres using ECDA it=
 complains about  ELF  and  Driver's SQLAllocHandle on SQL_HANDLE_HENV fai=
led error.

                             Driver installed from postgresql-odbc.x86_64 =
-  /usr/lib64/psqlodbcw.so  ( 64 bit )

Would you let me know if there is any 32- bit driver for postgresql-odbc t=
hat I can use for my environment.

Appreciate your help.


Thanks,
Hardeep


This email and any attachment is confidential. If you are not the intended=
 recipient, please delete this message. Macquarie does not guarantee the i=
ntegrity of any emails or attachments. For important disclosures and infor=
mation about the incorporation and regulated status of Macquarie Group ent=
ities please see: www.macquarie.com/disclosures
--_000_ME3PR01MB5750209B6C1196E4A3E26A9784849ME3PR01MB5750ausp_
Content-Type: text/html; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html xmlns:v=3D"urn:schemas-microsoft-com:vml" xmlns:o=3D"urn:schemas-mic=
rosoft-com:office:office" xmlns:w=3D"urn:schemas-microsoft-com:office:word=
" xmlns:m=3D"http://schemas.microsoft.com/office/2004/12/omml" xmlns=3D"ht=
tp://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii=
">
<meta name=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
=09{font-family:"Cambria Math";
=09panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
=09{font-family:Calibri;
=09panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
=09{font-family:Cambria;
=09panose-1:2 4 5 3 5 4 6 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
=09{margin:0cm;
=09font-size:11.0pt;
=09font-family:"Calibri",sans-serif;
=09mso-fareast-language:EN-US;}
span.EmailStyle17
=09{mso-style-type:personal-compose;
=09font-family:"Cambria",serif;
=09color:windowtext;
=09font-weight:normal;
=09font-style:normal;}
.MsoChpDefault
=09{mso-style-type:export-only;
=09font-family:"Calibri",sans-serif;
=09mso-fareast-language:EN-US;}
@page WordSection1
=09{size:612.0pt 792.0pt;
=09margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
=09{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=3D"EN-AU" link=3D"#0563C1" vlink=3D"#954F72" style=3D"word-wrap=
:break-word">
<div class=3D"WordSection1">
<p class=3D"MsoNormal"><span style=3D"font-family:&quot;Cambria&quot;,seri=
f">Hi Team,<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-family:&quot;Cambria&quot;,seri=
f"><o:p>&nbsp;</o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-family:&quot;Cambria&quot;,seri=
f">I am working in Macquarie database team, and we are planning to migrate=
 Sybase database to Postgres.&nbsp;
<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-family:&quot;Cambria&quot;,seri=
f"><o:p>&nbsp;</o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-family:&quot;Cambria&quot;,seri=
f">We are using a SAP ECDA product that allows data access within the hete=
rogeneous database environment, but this product uses 32-bit architecture/=
libs.
<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-family:&quot;Cambria&quot;,seri=
f">&nbsp;<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-family:&quot;Cambria&quot;,seri=
f">When I try to establish a connection from Sybase to Postgres using ECDA=
 it complains about&nbsp; ELF&nbsp; and &nbsp;Driver's SQLAllocHandle on S=
QL_HANDLE_HENV failed error.<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-family:&quot;Cambria&quot;,seri=
f"><o:p>&nbsp;</o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-family:&quot;Cambria&quot;,seri=
f">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp; Driver installed from postgresql-odbc.x86_64 -&nbs=
p; /usr/lib64/psqlodbcw.so &nbsp;( 64 bit )
<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-family:&quot;Cambria&quot;,seri=
f"><o:p>&nbsp;</o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-family:&quot;Cambria&quot;,seri=
f">Would you let me know if there is any 32- bit driver for postgresql-odb=
c that I can use for my environment.
<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-family:&quot;Cambria&quot;,seri=
f"><o:p>&nbsp;</o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-family:&quot;Cambria&quot;,seri=
f">Appreciate your help.<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-family:&quot;Cambria&quot;,seri=
f;mso-fareast-language:EN-AU"><o:p>&nbsp;</o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-family:&quot;Cambria&quot;,seri=
f;mso-fareast-language:EN-AU"><o:p>&nbsp;</o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-family:&quot;Cambria&quot;,seri=
f;mso-fareast-language:EN-AU">Thanks,<o:p></o:p></span></p>
<p class=3D"MsoNormal"><span style=3D"font-family:&quot;Cambria&quot;,seri=
f;mso-fareast-language:EN-AU">Hardeep
<o:p></o:p></span></p>
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p>
</div>
<br clear=3D"both">
This email and any attachment is confidential. If you are not the intended=
 recipient, please delete this message. Macquarie does not guarantee the i=
ntegrity of any emails or attachments. For important disclosures and infor=
mation about the incorporation and regulated status of Macquarie Group ent=
ities please see: www.macquarie.com/disclosures<BR>
</body>
</html>

--_000_ME3PR01MB5750209B6C1196E4A3E26A9784849ME3PR01MB5750ausp_--