32 bit ODBC driver for PostgreSQl

This is a multi-part message in MIME format.

------_=_NextPart_001_01C7D7F4.0D77FE8E
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Hi,

=20

I'm looking for a 32-bit PostgreSQL driver to be installed on a Windows
Server 2003 Standard x64 Edition.

I have already installed PostgreSQL driver version 8.00.01.01.

=20

Basically I'm trying to connect to (using SQL Server Integration
Services) PostgreSQL on Linux machine from Windows Server 2003 Standard
x64 Edition.

It connects and works perfectly fine when I run the package in design
mode. But its failing when I'm trying to execute it as a job.

=20

It fails with the error=20

"ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not
found and no default driver specified"

eventhough there is a DSN.

=20

What I understood from all my trials is that when run as a service (or a
job) package is looking for a 32 bit driver and it is unable to find
one.

=20

Can you help in anyway?

Where can I get 32 bit driver to be installed alongside the 64 bit
driver.

=20

Regards,

Rahul.

=20

=20



CONFIDENTIALITY NOTICE: This e-mail and any attachments are for the =
named person's use only and may contain information that is confidential =
or legally privileged. If this e-mail has been sent to you by mistake or =
you are not the intended recipient, you are not entitled to use it in =
any way and must permanently delete it and any attachments from your =
computer. Thank you.
------_=_NextPart_001_01C7D7F4.0D77FE8E
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

xmlns:o=3D"urn:schemas-microsoft-com:office:office" =
xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns:x=3D"urn:schemas-microsoft-com:office:excel" =
xmlns:p=3D"urn:schemas-microsoft-com:office:powerpoint" =
xmlns:a=3D"urn:schemas-microsoft-com:office:access" =
xmlns:dt=3D"uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" =
xmlns:s=3D"uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" =
xmlns:rs=3D"urn:schemas-microsoft-com:rowset" xmlns:z=3D"#RowsetSchema" =
xmlns:b=3D"urn:schemas-microsoft-com:office:publisher" =
xmlns:ss=3D"urn:schemas-microsoft-com:office:spreadsheet" =
xmlns:c=3D"urn:schemas-microsoft-com:office:component:spread sheet" =
xmlns:oa=3D"urn:schemas-microsoft-com:office:activation" =
xmlns:html=3D"http://www.w3.org/TR/REC-html40" =
xmlns:q=3D"http://schemas.xmlsoap.org/soap/envelope/" xmlns:D=3D"DAV:" =
xmlns:x2=3D"http://schemas.microsoft.com/office/excel/2003/x ml" =
xmlns:ois=3D"http://schemas.microsoft.com/sharepoint/soap/oi s/" =
xmlns:dir=3D"http://schemas.microsoft.com/sharepoint/soap/di rectory/" =
xmlns:ds=3D"http://www.w3.org/2000/09/xmldsig#" =
xmlns:dsp=3D"http://schemas.microsoft.com/sharepoint/dsp" =
xmlns:udc=3D"http://schemas.microsoft.com/data/udc" =
xmlns:xsd=3D"http://www.w3.org/2001/XMLSchema" =
xmlns:sps=3D"http://schemas.microsoft.com/sharepoint/soap/" =
xmlns:xsi=3D"http://www.w3.org/2001/XMLSchema-instance" =
xmlns:udcxf=3D"http://schemas.microsoft.com/data/udc/xmlfile " =
xmlns=3D"http://www.w3.org/TR/REC-html40">


charset=3Dus-ascii">

CONFIDENTIALITY =
NOTICE: This e-mail and any attachments are for the named person's use =
only and may contain information that is confidential or legally =
privileged. If this e-mail has been sent to you by mistake or you are =
not the intended recipient, you are not entitled to use it in any way =
and must permanently delete it and any attachments from your computer. =
Thank you.

Re: 32 bit ODBC driver for PostgreSQl

Hi.

Since an ODBC administrator is 64 bits, the data sauce for 32bit cannot be created.
In this case, it is necessary to write direct data sauce in a registry.
However, psqlODBC is support 64bit environment now. but, It is necessary to
compile it by myself. It is win64.mak. and libpq of PostgreSQL needs to be built by
64bits again.

Please, only AMD64 has an examination version here.
http://www.geocities.jp/inocchichichi/psqlodbc/index.html

Regards,
Hiroshi Saito

----- Original Message -----
From: Anumula, Rahul
To: pgsql-odbc@postgresql.org
Sent: Monday, August 06, 2007 3:35 PM
Subject: [ODBC] 32 bit ODBC driver for PostgreSQl


Hi,

I'm looking for a 32-bit PostgreSQL driver to be installed on a Windows Server 2003 Standard
x64 Edition.
I have already installed PostgreSQL driver version 8.00.01.01.

Basically I'm trying to connect to (using SQL Server Integration Services) PostgreSQL on
Linux machine from Windows Server 2003 Standard x64 Edition.
It connects and works perfectly fine when I run the package in design mode. But its failing
when I'm trying to execute it as a job.

It fails with the error
"ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified"
eventhough there is a DSN.

What I understood from all my trials is that when run as a service (or a job) package is
looking for a 32 bit driver and it is unable to find one.

Can you help in anyway?
Where can I get 32 bit driver to be installed alongside the 64 bit driver.

Regards,
Rahul.





Please consider the environment before printing this e-mail
CONFIDENTIALITY NOTICE: This e-mail and any attachments are for the named person's use only
and may contain information that is confidential or legally privileged. If this e-mail has
been sent to you by mistake or you are not the intended recipient, you are not entitled to
use it in any way and must permanently delete it and any attachments from your computer.
Thank you.


---------------------------(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