SEO

#1 (**permalink**) 04-16-2008, 01:59 AM

I am using PostgreSQL version 8.0 with VC++ 2005.

I use the native VC++ ODBC classes to access the PostgreSQL ODBC driver.

When I issue an SQL command with an error I always get the same error code:
7

The message is ok but the code would be kinda useful – don’t really want to
start parsing the message.

I tried it with the 8.02.00.02 driver and the ANSI version of the 8.01.02.00

Both give the same result.

Is this a bug or am I doing something wrong?

Jonathan Blitz

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.8.1/355 - Release Date: 06/02/2006

#2 (**permalink**) 04-16-2008, 01:59 AM

> I am using PostgreSQL version 8.0 with VC++ 2005.
>
> I use the native VC++ ODBC classes to access the PostgreSQL ODBC driver.
>
> When I issue an SQL command with an error I always get the same error code:
> 7

....

> Is this a bug or am I doing something wrong?

It's normal behaviour. Let's try read sqlstate (I don't know how it is
accessed through VC++ ODBC classes.

Regards,

Luf

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

http://archives.postgresql.org

#3 (**permalink**) 04-16-2008, 01:59 AM

Ok - I'll give it a try and see what I get.

> -----Original Message-----
> From: Ludek Finstrle [mailto:luf@pzkagis.cz]
> Sent: Sunday, June 04, 2006 6:05 PM
> To: Jonathan Blitz
> Cc: pgsql-odbc@postgresql.org
> Subject: Re: [ODBC] Return code for bad command
>
> > I am using PostgreSQL version 8.0 with VC++ 2005.
> >
> > I use the native VC++ ODBC classes to access the PostgreSQL ODBC driver.
> >
> > When I issue an SQL command with an error I always get the same error
code:
> > 7
>
> ...
>
> > Is this a bug or am I doing something wrong?
>
> It's normal behaviour. Let's try read sqlstate (I don't know how it is
> accessed through VC++ ODBC classes.
>
> Regards,
>
> Luf
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
>
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.394 / Virus Database: 268.8.1/355 - Release Date: 6/2/2006
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.394 / Virus Database: 268.8.1/355 - Release Date: 06/02/2006
>

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.394 / Virus Database: 268.8.1/355 - Release Date: 06/02/2006

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

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

#4 (**permalink**) 04-16-2008, 01:59 AM

I'm having the same behavior and the sqlstate returns the same code: HY000.
Reading the MSDN this code is described as "General error".

Renato Gondim.

-----Mensagem original-----
De: pgsql-odbc-owner@postgresql.org [mailto

gsql-odbc-owner@postgresql.org]
Em nome de Ludek Finstrle
Enviada em: domingo, 4 de junho de 2006 13:05
Para: Jonathan Blitz
Cc: pgsql-odbc@postgresql.org
Assunto: Re: [ODBC] Return code for bad command

> I am using PostgreSQL version 8.0 with VC++ 2005.
>
> I use the native VC++ ODBC classes to access the PostgreSQL ODBC driver.
>
> When I issue an SQL command with an error I always get the same error
code:
> 7

....

> Is this a bug or am I doing something wrong?

It's normal behaviour. Let's try read sqlstate (I don't know how it is
accessed through VC++ ODBC classes.

Regards,

Luf

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

http://archives.postgresql.org

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

#5 (**permalink**) 04-16-2008, 01:59 AM

> I'm having the same behavior and the sqlstate returns the same code: HY000.
> Reading the MSDN this code is described as "General error".

Does psqlodbc 08.01.0200 return the same?
Please could you send mylog outputs from two different errors?

Regards,

Luf

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

http://archives.postgresql.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode