ODBC support

Jonathan Foy | 7 Apr 2010 21:57

Acucobol, ODBC and Postgres

Hello

I'm trying to configure the postgres odbc driver with our Acucobol application (5.2 and 8.1), and was hoping that someone out there might have some experience with this.

The application currently connects to our postgres databases (8.1.3 up to 8.4.2) without issue. The problem came up when I started trying to use pgbouncer. I had it up and running from the command line, but connections coming from the application are rejected due to a "bad packet header", which seems to be because the connect packets are coming in with V2 in the data, and pgbouncer only supports V3. So, we downloaded the latest driver, compiled it (RHEL 5.4), and (in theory) recompiled cobol with the new library (libodbcpsql.so.2.0.0) linked in. There was no apparent change.

The application can still parse the odbc.ini file to get the database name, server, port, user, and password, but any additional settings seem to be ignored. I can't get any logging, I can't set the Protocol version...I'm not convinced that the proper driver is being used.

Does anyone have any ideas? Pulling my hair out...

headers

Korry Douglas | 7 Apr 2010 22:06

Re: Acucobol, ODBC and Postgres

> I'm trying to configure the postgres odbc driver with our Acucobol  
> application (5.2 and 8.1), and was hoping that someone out there  
> might have some experience with this.
>
> The application currently connects to our postgres databases (8.1.3  
> up to 8.4.2) without issue.  The problem came up when I started  
> trying to use pgbouncer.  I had it up and running from the command  
> line, but connections coming from the application are rejected due  
> to a "bad packet header", which seems to be because the connect  
> packets are coming in with V2 in the data, and pgbouncer only  
> supports V3.  So, we downloaded the latest driver, compiled it (RHEL  
> 5.4), and (in theory) recompiled cobol with the new library  
> (libodbcpsql.so.2.0.0) linked in.  There was no apparent change.
>
> The application can still parse the odbc.ini file to get the  
> database name, server, port, user, and password, but any additional  
> settings seem to be ignored.  I can't get any logging, I can't set  
> the Protocol version...I'm not convinced that the proper driver is  
> being used.
>
> Does anyone have any ideas?  Pulling my hair out...

I would start by running strace on your application while it is trying  
to connect.  When I've run into kind of problem that you describe,  
I've found that the ODBC Driver Manager is reading the wrong odbc.ini  
file (for example, reading from /etc/odbc.ini when I expected /usr/ 
local/etc/odbc.ini).

Just run:

	$ strace -o /tmp/myapp.trc <your application name goes here>

Then look through the /tmp/myapp.trc file, searching for attempts to  
open odbc.ini, odbcinst.ini, and the libodbcpsql.so library.

			-- Korry

-----------------------------------------------------------------------
Korry Douglas
Senior Database Dude
EnterpriseDB Corporation
The Enterprise Postgres Company

Phone: (804)241-4301
Mobile: (620) EDB-NERD

--

-- 
Sent via pgsql-odbc mailing list (pgsql-odbc <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

headers

Jonah H. Harris | 7 Apr 2010 22:14

Re: Acucobol, ODBC and Postgres

On Wed, Apr 7, 2010 at 3:27 PM, Jonathan Foy <thefoy <at> gmail.com> wrote:

I'm trying to configure the postgres odbc driver with our Acucobol application (5.2 and 8.1), and was hoping that someone out there might have some experience with this.

About two years ago I was working on a project which used Postgres via ODBC with both ACUCOBOL and Micro Focus. Which ODBC driver are you using? You should try ODBCng (https://projects.commandprompt.com/public/odbcng/).

Also, you may want to try/consider using the commercial PG ODBC driver from DataDirect (http://www.datadirect.com/products/odbc/odbc-postgresql/index.ssp).

--
Jonah H. Harris
Blog: http://www.oracle-internals.com/

headers

Jonah H. Harris | 7 Apr 2010 22:15

Re: Acucobol, ODBC and Postgres

On Wed, Apr 7, 2010 at 3:36 PM, Korry Douglas <korry.douglas <at> enterprisedb.com> wrote:

I'm trying to configure the postgres odbc driver with our Acucobol application (5.2 and 8.1), and was hoping that someone out there might have some experience with this.

The application currently connects to our postgres databases (8.1.3 up to 8.4.2) without issue. The problem came up when I started trying to use pgbouncer. I had it up and running from the command line, but connections coming from the application are rejected due to a "bad packet header", which seems to be because the connect packets are coming in with V2 in the data, and pgbouncer only supports V3. So, we downloaded the latest driver, compiled it (RHEL 5.4), and (in theory) recompiled cobol with the new library (libodbcpsql.so.2.0.0) linked in. There was no apparent change.

The application can still parse the odbc.ini file to get the database name, server, port, user, and password, but any additional settings seem to be ignored. I can't get any logging, I can't set the Protocol version...I'm not convinced that the proper driver is being used.

Does anyone have any ideas? Pulling my hair out...

I would start by running strace on your application while it is trying to connect. When I've run into kind of problem that you describe, I've found that the ODBC Driver Manager is reading the wrong odbc.ini file (for example, reading from /etc/odbc.ini when I expected /usr/local/etc/odbc.ini).

Yeah, I like to explicitly define my ODBCINI and ODBCINST environment variables to avoid that issue.

--
Jonah H. Harris
Blog: http://www.oracle-internals.com/

headers

Jonathan Foy | 7 Apr 2010 22:55

Re: Acucobol, ODBC and Postgres

The application is actually launched from a windows box via a thin client...I'm not sure how I would run it with strace.

However, I'm fairly sure I'm pulling in the correct one, if I change the port it fails, as it should. Switch it back and it works. Of all the odbc entries on the system (from a root level search for both odbc.ini and .odbc.ini), only the one has this database entry in it at all. And it WILL connect, just not do what I want it to.

On Wed, Apr 7, 2010 at 4:06 PM, Korry Douglas <korry.douglas <at> enterprisedb.com> wrote:

I'm trying to configure the postgres odbc driver with our Acucobol application (5.2 and 8.1), and was hoping that someone out there might have some experience with this.

The application currently connects to our postgres databases (8.1.3 up to 8.4.2) without issue. The problem came up when I started trying to use pgbouncer. I had it up and running from the command line, but connections coming from the application are rejected due to a "bad packet header", which seems to be because the connect packets are coming in with V2 in the data, and pgbouncer only supports V3. So, we downloaded the latest driver, compiled it (RHEL 5.4), and (in theory) recompiled cobol with the new library (libodbcpsql.so.2.0.0) linked in. There was no apparent change.

The application can still parse the odbc.ini file to get the database name, server, port, user, and password, but any additional settings seem to be ignored. I can't get any logging, I can't set the Protocol version...I'm not convinced that the proper driver is being used.

Does anyone have any ideas? Pulling my hair out...

I would start by running strace on your application while it is trying to connect. When I've run into kind of problem that you describe, I've found that the ODBC Driver Manager is reading the wrong odbc.ini file (for example, reading from /etc/odbc.ini when I expected /usr/local/etc/odbc.ini).

Just run:

$ strace -o /tmp/myapp.trc <your application name goes here>

Then look through the /tmp/myapp.trc file, searching for attempts to open odbc.ini, odbcinst.ini, and the libodbcpsql.so library.

-- Korry

-----------------------------------------------------------------------
Korry Douglas
Senior Database Dude
EnterpriseDB Corporation
The Enterprise Postgres Company

Phone: (804)241-4301
Mobile: (620) EDB-NERD

headers

Jonathan Foy | 7 Apr 2010 23:05

Re: Acucobol, ODBC and Postgres

I'm using (or think I am) the latest psqlODBC download from the postgresql website. 8.04.0200. It was compiled and then linked into runcbl via the ACUSQL_ODBC_LIB variable, which then gets passed up the chain, in the Makefile (for runcbl). Is this not the correct way to do it?

I'm under the impression that I'm bypassing unixODBC, but I am fairly new with this (cobol/odbc). So I could be wrong.

ODBCng is no longer being developed, I'm not sure that that's the route I want to take for the future. And convincing Higher Ups to go the commercial route would be difficult...

On Wed, Apr 7, 2010 at 4:14 PM, Jonah H. Harris <jonah.harris <at> gmail.com> wrote:

On Wed, Apr 7, 2010 at 3:27 PM, Jonathan Foy <thefoy <at> gmail.com> wrote:
I'm trying to configure the postgres odbc driver with our Acucobol application (5.2 and 8.1), and was hoping that someone out there might have some experience with this.

About two years ago I was working on a project which used Postgres via ODBC with both ACUCOBOL and Micro Focus. Which ODBC driver are you using? You should try ODBCng (https://projects.commandprompt.com/public/odbcng/).

Also, you may want to try/consider using the commercial PG ODBC driver from DataDirect (http://www.datadirect.com/products/odbc/odbc-postgresql/index.ssp).

--
Jonah H. Harris
Blog: http://www.oracle-internals.com/

headers

Goutham Jalakam - ERS, HCL Tech | 8 Apr 2010 09:28

Regarding sinsle quotes

Hi support team,

We are using postgre 8.1.5 version.

And postgreODBC driver 8.1.200.

When we try to insert ‘’ into DB its inserting as \’\’. Can you help on this issue?

Can we install latest version ODBC driver for postgre 8.1.5 version?

Regards

Goutham J

DISCLAIMER: ----------------------------------------------------------------------------------------------------------------------- The contents of this e-mail and any attachment(s) are confidential and intended for the named recipient(s) only. It shall not attach any liability on the originator or HCL or its affiliates. Any views or opinions presented in this email are solely those of the author and may not necessarily reflect the opinions of HCL or its affiliates. Any form of reproduction, dissemination, copying, disclosure, modification, distribution and / or publication of this message without the prior written consent of the author of this e-mail is strictly prohibited. If you have received this email in error please delete it and notify the sender immediately. Before opening any mail and attachments please check them for viruses and defect. -----------------------------------------------------------------------------------------------------------------------

headers

Anand | 8 Apr 2010 16:35

Postgres Driver

Hi All,

I need Postgres driver on unix host. My Informatica is hosted on unix system.

Do I need to instal PostgreSQL client or Postgres server or psqlodbc driver is enough?

Thanks,
Anand P.S

headers

Mark Simonetti | 12 Apr 2010 20:25

Deallocation speed

Hi,
I'm currently working on a c++ project that uses the psqlodbc driver.

I have a query that returns over 26000 rows, and about 45 columns.

When it comes to closing the statement using SQLFreeStmt(hstmt, 
SQL_CLOSE), the command seems to take about 70 seconds to return (on a 
3.16ghz processor!).   This just doesn't seem right.  Is there something 
I may be missing?

I thought I'd ask first before I posted more details incase it is 
something obvious.

Thanks,

Mark.

--

-- 
Sent via pgsql-odbc mailing list (pgsql-odbc <at> postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-odbc

headers

Ken Sell | 12 Apr 2010 23:13

Re: Postgres Driver

Hi,

Informatica uses the DataDirect ODBC driver manager. You’ll need a postgres ODBC that
is compiled with that driver’s headers.

When you refer to a “Postgres server” do you mean the database? If so, you do not
have to have it on the same machine as your Informatica server.

...Ken Sell

On 4/8/10 6:35 AM, "Anand" <anand.satyanarayana <at> gmail.com> wrote:

Hi All,

I need Postgres driver on unix host. My Informatica is hosted on unix system.

Do I need to instal PostgreSQL client or Postgres server or psqlodbc driver is enough?

Thanks,
Anand P.S

38	May 2013
50	April 2013
27	March 2013
2	February 2013
17	January 2013
3	December 2012
5	November 2012
16	October 2012
20	September 2012
30	August 2012
15	July 2012
38	June 2012
18	May 2012
24	April 2012
33	March 2012
18	February 2012
10	January 2012
3	December 2011
32	November 2011
7	October 2011
14	September 2011
4	August 2011
16	July 2011
19	June 2011
11	May 2011
19	April 2011
37	March 2011
17	February 2011
25	January 2011
25	December 2010
37	November 2010
40	October 2010
35	September 2010
33	August 2010
34	July 2010
44	June 2010
52	May 2010
21	April 2010
19	March 2010
19	February 2010
24	January 2010
32	December 2009
79	November 2009
22	October 2009
40	September 2009
39	August 2009
45	July 2009
16	June 2009
43	May 2009
23	April 2009
43	March 2009
13	February 2009
24	January 2009
30	December 2008
40	November 2008
40	October 2008
38	September 2008
33	August 2008
5	July 2008
25	June 2008
19	May 2008
52	April 2008
47	March 2008
64	February 2008
45	January 2008
29	December 2007
63	November 2007
31	October 2007
21	September 2007
46	August 2007
62	July 2007
69	June 2007
73	May 2007
91	April 2007
124	March 2007
52	February 2007
84	January 2007
92	December 2006
60	November 2006
122	October 2006
112	September 2006
185	August 2006
53	July 2006
162	June 2006
77	May 2006
144	April 2006
239	March 2006
152	February 2006
308	January 2006
331	December 2005
245	November 2005
132	October 2005
206	September 2005
248	August 2005
171	July 2005
81	June 2005
77	May 2005
142	April 2005
144	March 2005
127	February 2005
95	January 2005
61	December 2004
119	November 2004
133	October 2004
104	September 2004
65	August 2004
173	July 2004
61	June 2004
47	May 2004
128	April 2004
87	March 2004
49	February 2004
119	January 2004
91	December 2003
131	November 2003
90	October 2003
119	September 2003
77	August 2003
62	July 2003
83	June 2003
74	May 2003
101	April 2003
81	March 2003
99	February 2003
111	January 2003
113	December 2002
212	November 2002
91	October 2002
110	September 2002
57	August 2002
80	July 2002
116	June 2002
71	May 2002
82	April 2002

Mon	Tue	Wed	Thu	Fri	Sat	Sun

			1	2	3	4
5	6	7	8	9	10	11
12	13	14	15	16	17	18
19	20	21	22	23	24	25
26	27	28	29	30