Connecting to Postgresql from PowerBuilder 9.0 using OLE-DB

From: victor(at)maintstar(dot)com
To: pgsql-odbc(at)postgresql(dot)org
Subject: Connecting to Postgresql from PowerBuilder 9.0 using OLE-DB
Date: 2014-01-18 01:47:32
Message-ID: 20140117184732.e414af8249702a63b8c67915d37132ae.b487f3a602.mailapi@email02.secureserver.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi,
I need to connect to Postgresql using PowerBuilder 9.0.

Using OLE-DB:
On Windows XP, in PowerBuilder 9.0, use the Database Painter and try to connect as follows:
// Profile PGOLEDB
SQLCA.DBMS = "OLE DB"
SQLCA.LogPass = <******>
SQLCA.LogId = "sierra"
SQLCA.AutoCommit = False
SQLCA.DBParm = "PROVIDER='PostgreSQL Native Provider (BI Alias)',DATASOURCE='localhost',PROVIDERSTRING='InitialCatalog='SierraOne''"
On the Preview tab, click the "Test Connection" button.
It blows up with:
"pb90.exe - Entry Point Not Found"
"The procedure entry point InitializeCriticalSectionEx could not be located in the dynamic link library KERNEL32.dll."
Any suggestions? All my users are on Windows XP.
I did a Google search, and found there was a bug in Visual Studio 2012 which caused this issue.
I am using pgAdmin 1.16.1 and PostgreSQL 9.2
Sincerely,
Victor Reinhart

Browse pgsql-odbc by date

  From Date Subject
Next Message victor 2014-01-18 01:58:41 Connecting to Postgresql from PowerBuilder 9.0 using ODBC
Previous Message Inoue, Hiroshi 2014-01-15 00:20:41 Re: support for keep alive option