Accessing Postgresql from Natural

, , ,
1

Hi people, I’m trying to access a PostgreSQL 8.1.23 database on a x86_64-redhat-linux.
Step done are:

  • Postgresql installation
  • Postgresql odbc driver installation
  • Odbc manager installation.
  • Natural 6.3.12 installation
  • Entire Access 6.2.11 installation

Using isql test connection is fine. So I can access postgresql database using odbc driver and a DSN name that I called ‘test’.
Postgres database and Natural are both on the same machine, so it’s a local connection.
So, i linked natural with osx ( make natural osx=yes ) and added on natparm configuration
DB TYPE PARAMETER
103 SQL ODBCINT:test
Connection doesn’t works.
My question is about Entire Access and Natural configuration.
What are the missing step in order to access postgresql from natural?
Anyone have expertise on this topic?
Thanks a lot.

2

Hi Axt,

Have you tried tracing? Perhaps it can reveal what is going on.

[url]http://techcommunity.softwareag.com/ecosystem/documentation/natural/osx621unw/osx/error_diagnosis.htm[/url]

Best regards,
Mogens

3

One thing to always watch out for is the following note in the requirements section of the OSX documentation

Just in case :wink:

4

Trace show:

*** ENTIRE ACCESS trace file

*** Version : V 6.3.12 PL 0 Software AG 2012
*** BuildDate : Feb 29 2012
*** BuildOS : Linux x86_64

*** SQL_TRACE : 6418 (3)
*** OSXVERS : v6211
*** OSXAPI : /opt/softwareag/osx/v6211/bin/OSXAPI

*** User : SAGP
*** Date : 31/10/2012 11:13:12 92/100

==========================================================================
================ VTXINIT (1: 31/10/2012 11:13:12 92/100) ================

SQL-CA: code: 0
warnings: --------
Max. cursor : 512
Max. columns : 256
Max. DB cursor : 64
Fetch buffer size : 4096
Version number : 332

Timestamp : 11:13:12 92/100

==========================================================================
================ VTXCONN (2: 31/10/2012 11:13:12 92/100) ================

SQL-CA: code: -1
VTXGEEM: “DLLLOAD: ODBCINT, /opt/softwareag/osx/v6211/bin/ODBC”
“INT.so: undefined symbol: SQLParamData” (90)

Connect “ODBCINT:postgres/…/test” (30)

Timestamp : 11:13:12 92/100

==========================================================================
================ VTXGEEM (3: 31/10/2012 11:13:12 92/100) ================

Error Message “DLLLOAD: ODBCINT, /opt/softwareag/osx/v6211/bin/ODBC”
“INT.so: undefined symbol: SQLParamData” (90)

Timestamp : 11:13:12 92/100

Any ideas?

5

There is an issue re. that message in empower, can you please check there,
or get in touch with Software AG support ?