SQLCODE when using psqlODBC with libODBC++

This is a multi-part message in MIME format.

------=_NextPart_000_0086_01C67918.615C6920
Content-Type: text/plain;
charset="windows-1250"
Content-Transfer-Encoding: quoted-printable

I am using PostgreSQL version 8 with psqlODBC as the ODBC driver.

=20

I am writing programs in C++ and using libODBC++ for the C++ interface.

=20

Everything works great except:

When I get an SQL error it returns SQLCODE of 7 and SQLSTATE of =
=93HY000=94
every time.

The only correct value is the SQLERRM.

=20

I am probably doing something stupid but I couldn=92t find anything =
anywhere
about it.

=20

Jonathan Blitz

=20


--=20
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.5.6/340 - Release Date: =
05/15/2006
=20

------=_NextPart_000_0086_01C67918.615C6920
Content-Type: text/html;
charset="windows-1250"
Content-Transfer-Encoding: quoted-printable

xmlns:w=3D"urn:schemas-microsoft-com:office:word" =
xmlns=3D"http://www.w3.org/TR/REC-html40">


charset=3Dwindows-1250">

--

No virus found in this outgoing message.

Checked by AVG Free Edition.

Version: 7.1.392 / Virus Database: 268.5.6/340 - Release Date: =
05/15/2006

Re: SQLCODE when using psqlODBC with libODBC++

> I am using PostgreSQL version 8 with psqlODBC as the ODBC driver.

You specify no psqlODBC version. Older versions have this bad behaviour.
So if I use my crystal ball I see there only upgrade advice.

> Everything works great except:
>=20
> When I get an SQL error it returns SQLCODE of 7 and SQLSTATE of â€=9C=
HY000â€=9D
> every time.

Regards,

Luf

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Re: SQLCODE when using psqlODBC with libODBC++

>
> You specify no psqlODBC version. Older versions have this bad behaviour.
> So if I use my crystal ball I see there only upgrade advice.

I am using version 0.2.4pre3. Dated Sept 2005.
I downloaded it from sourceforg.net

Is there a newer version?

Jonathan

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.6.1/343 - Release Date: 05/18/2006



---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Re: SQLCODE when using psqlODBC with libODBC++

Fri, May 19, 2006 at 12:23:59PM +0200, Jonathan Blitz napsal(a):
> > You specify no psqlODBC version. Older versions have this bad behaviour.
> > So if I use my crystal ball I see there only upgrade advice.
>
> I am using version 0.2.4pre3. Dated Sept 2005.
> I downloaded it from sourceforg.net
>
> Is there a newer version?

From where? This list is for psqlodbc from pgfoundry.org. The latest
version is 08.02.0002.
Are we talking both about psqlodbc? Could you send the URL for sf.net
project (I try to locate it with no success)?

Please try the newest psqlodbc from pgfoundry.org.

Regards,

Luf

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Re: SQLCODE when using psqlODBC with libODBC++

> -----Original Message-----
> From: Ludek Finstrle [mailto:luf@pzkagis.cz]
> Sent: Friday, May 19, 2006 1:20 PM
> To: Jonathan Blitz
> Cc: pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] SQLCODE when using psqlODBC with libODBC++
>
> Fri, May 19, 2006 at 12:23:59PM +0200, Jonathan Blitz napsal(a):
> > > You specify no psqlODBC version. Older versions have this bad
behaviour.
> > > So if I use my crystal ball I see there only upgrade advice.
> >
> > I am using version 0.2.4pre3. Dated Sept 2005.
> > I downloaded it from sourceforg.net
> >
> > Is there a newer version?
>
> >From where? This list is for psqlodbc from pgfoundry.org. The latest
> version is 08.02.0002.
> Are we talking both about psqlodbc? Could you send the URL for sf.net
> project (I try to locate it with no success)?
>
> Please try the newest psqlodbc from pgfoundry.org.
>
> Regards,
>
> Luf
>

Oops.
I am totally confused. I thought u asked for the version of libODBC++.

I am now totally lost.
I am new to accessing PostgreSQL from C++.

I already had PostgreSQL installed with the ODBC driver since I use it for
another program (Poker Tracker).

I wanted to write a C++ program to access the same database so I used
libODBC++ to issue the commands from within C++.

I am probably doing something wrong.

When I look at the ODBC connection for the database I see that I have a
choice of 3 drivers:

PostgreSQL - version 8.02.00.02
PostgreSQL ANSI - version 8.01.02.00
PostgreSQL Unicode - version 8.01.02.00

The first one is the one selected.

Jonathan

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.6.1/343 - Release Date: 05/18/2006



---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly