Thread: Connecting to Postgresql from PowerBuilder 9.0 using ODBC

Connecting to Postgresql from PowerBuilder 9.0 using ODBC

From
victor@maintstar.com
Date:
Hi,
I did this from WIndows XP:
 
Start, Control Panel, Administrative Tools, Data Sources (ODBC), click "Add" to create a new User DSN, click "PostgreSQL ANSI", and click "Finish".
 
This message appears:
 
"odbad32.exe - Bad Image"
"The application or DLL C:\Program Files\psqlODBC\0901\bin\libpq.dll is not a valid Windows image.  Please check this against your installation diskette."
 
What can I do?  Is this expected?
 
After this, the window titled "PostgreSQL ANSI ODBC Driver (psqlODBC) Setup" appears.
 
I set it up, and click "Test", and get "Connection successful".
 
I can see the data in PowerBuilder, but there are many errors when running the Pipeline Painter.  I will provide details later.
 
Sincerely,
Victor Reinhart

Re: Connecting to Postgresql from PowerBuilder 9.0 using ODBC

From
victor@maintstar.com
Date:
Hi Michael,
I tried with "PostgreSQL UNICODE".
 
The same message appears:
 
Start, Control Panel, Administrative Tools, Data Sources (ODBC), click "Add" to create a new User DSN, click "PostgreSQL ANSI", and click "Finish".
 
This message appears:
 
"odbad32.exe - Bad Image"
"The application or DLL C:\Program Files\psqlODBC\0901\bin\libpq.dll is not a valid Windows image.  Please check this against your installation diskette."
Sincerely,
Victor Reinhart
 

Re: Connecting to Postgresql from PowerBuilder 9.0 using ODBC

From
Adrian Klaver
Date:
On 01/18/2014 01:40 PM, victor@maintstar.com wrote:
> Hi Michael,
> I tried with "PostgreSQL UNICODE".
> The same message appears:
> Start, Control Panel, Administrative Tools, Data Sources (ODBC), click
> "Add" to create a new User DSN, click "PostgreSQL ANSI", and click "Finish".
> This message appears:
> "odbad32.exe - Bad Image"
> "The application or DLL C:\Program Files\psqlODBC\0901\bin\libpq.dll is
> not a valid Windows image.  Please check this against your installation
> diskette."

You did not say what the 32/64 bit status of  your version of Windows is
or the 32/64 status of the psqlodbc driver you are using. This can be
confusing when installing.

See the FAQ item below for more information:

http://psqlodbc.projects.pgfoundry.org/faq.html#6.8

> Sincerely,
> Victor Reinhart


--
Adrian Klaver
adrian.klaver@gmail.com


Re: Connecting to Postgresql from PowerBuilder 9.0 using ODBC

From
"Inoue, Hiroshi"
Date:
Hi Victor,

Please try the latest driver.

regrads,
Hiroshi Inoue

(2014/01/18 10:58), victor@maintstar.com wrote:
> Hi,
> I did this from WIndows XP:
> Start, Control Panel, Administrative Tools, Data Sources (ODBC), click
> "Add" to create a new User DSN, click "PostgreSQL ANSI", and click "Finish".
> This message appears:
> "odbad32.exe - Bad Image"
> "The application or DLL C:\Program Files\psqlODBC\0901\bin\libpq.dll is
> not a valid Windows image.  Please check this against your installation
> diskette."
> What can I do?  Is this expected?
> After this, the window titled "PostgreSQL ANSI ODBC Driver (psqlODBC)
> Setup" appears.
> I set it up, and click "Test", and get "Connection successful".
> I can see the data in PowerBuilder, but there are many errors when
> running the Pipeline Painter.  I will provide details later.
> Sincerely,
> Victor Reinhart


--
I am using the free version of SPAMfighter.
SPAMfighter has removed 3035 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len

Do you have a slow PC? Try a Free scan
http://www.spamfighter.com/SLOW-PCfighter?cid=sigen