# Accessing Postgresql from Natural **URL:** \ **Category:** Forum\ **Tags:** Adabas-Natural, Natural, Natural-on-Linux, Natural-Database-Interfaces-on-Open-Systems\ **Created:** [October 30, 2012, 6:10pm UTC](https://techcommunity.softwareag.com/t/accessing-postgresql-from-natural/101687 "2012-10-30T18:10:51Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Axt](https://avatars.discourse-cdn.com/v4/letter/a/b2d939/32.png) [@Axt](https://techcommunity.softwareag.com/u/Axt)\ **Post date:** [October 30, 2012, 6:10pm UTC](https://techcommunity.softwareag.com/t/accessing-postgresql-from-natural/101687/1 "2012-10-30T18:10:51Z")
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. ---
**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\ **Post date:** [October 30, 2012, 6:32pm UTC](https://techcommunity.softwareag.com/t/accessing-postgresql-from-natural/101687/2 "2012-10-30T18:32:46Z")
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]](http://techcommunity.softwareag.com/ecosystem/documentation/natural/osx621unw/osx/error_diagnosis.htm%5B/url%5D) Best regards, Mogens ---
**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\ **Post date:** [October 30, 2012, 7:33pm UTC](https://techcommunity.softwareag.com/t/accessing-postgresql-from-natural/101687/3 "2012-10-30T19:33:03Z")
One thing to always watch out for is the following note in the requirements section of the OSX documentation > [@](#): > > No mixing of 32-bit software with 64-bit software is supported in any form Just in case 😉 ---
**Author:** ![Axt](https://avatars.discourse-cdn.com/v4/letter/a/b2d939/32.png) [@Axt](https://techcommunity.softwareag.com/u/Axt)\ **Post date:** [October 31, 2012, 11:09am UTC](https://techcommunity.softwareag.com/t/accessing-postgresql-from-natural/101687/4 "2012-10-31T11:09:44Z")
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? ---
**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\ **Post date:** [October 31, 2012, 11:49am UTC](https://techcommunity.softwareag.com/t/accessing-postgresql-from-natural/101687/5 "2012-10-31T11:49:20Z")
There is an issue re. that message in empower, can you please check there, or get in touch with Software AG support ? ---
**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\ **Post date:** [April 2, 2021, 3:02pm UTC](https://techcommunity.softwareag.com/t/accessing-postgresql-from-natural/101687/6 "2021-04-02T15:02:33Z")