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

32 bit ODBC driver for PostgreSQl

From: "Anumula, Rahul" <Rahul(dot)Anumula(at)harpercollins(dot)com(dot)au>
To: <pgsql-odbc(at)postgresql(dot)org>
Subject: 32 bit ODBC driver for PostgreSQl
Date: 2007-08-06 06:35:59
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc


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


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


Can you help in anyway?

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






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.


pgsql-odbc by date

Next:From: lothar.behrens@lollisoft.deDate: 2007-08-07 22:40:37
Subject: Long data and SQLPutData ?
Previous:From: Paul LambertDate: 2007-08-06 01:11:07
Subject: Re: Strange ODBC behavior.

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