Thread: Return code for bad command

Return code for bad command

From
"Jonathan Blitz"
Date:

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

Re: Return code for bad command

From
Ludek Finstrle
Date:
> 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

Re: Return code for bad command

From
"Jonathan Blitz"
Date:
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



RES: Return code for bad command

From
"Renato Gondim"
Date:
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:pgsql-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


Re: RES: Return code for bad command

From
Ludek Finstrle
Date:
> 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