Skip site navigation (1) Skip section navigation (2)

Problem with ODBC Driver Version 7.1.9, DB Version 7.1.3

From: Wolfgang Fuertbauer <w(dot)fuertbauer(at)eunet(dot)at>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Problem with ODBC Driver Version 7.1.9, DB Version 7.1.3
Date: 2002-01-08 09:24:57
Message-ID: 5.1.0.14.0.20020108102055.009e7db0@mail.austria.eu.net (view raw or flat)
Thread:
Lists: pgsql-bugs
Severity: Major

Short description: Problem with ODBC Driver Version 7.1.9, DB Version 7.1.3

Long description:
created table umsatz:

fakt32=# \d umsatz
                                      Table "umsatz"
  Attribute  |         Type          |                      Modifier 

------------+-----------------------+----------------------------------------------------
  inr        | integer               | not null default 
nextval('"umsatz_inr_seq"'::text)
  kdnr       | bigint                | default 0
  jahr       | integer               | default 0
  menge      | real                  | default 0
  netto      | real                  | default 0
  nettostamm | real                  | default 0
  kz         | character varying(2)  |
  kolltext   | character varying(30) |
  agtext     | character varying(30) |
  rabproz    | real                  | default 0
Indices: umsatz_kdnr_key,
          umsatz_pkey

as you can see: field "kdnr" is defined as bigint;

using MsAccess as frontend; connecting tables via ODBC (Driver Version 7.1.9);


field "kdnr" is shown as type text length(19) ????

Example code:

"Select * from umsatz where kdnr = 2" gives Error-Message: Data Type 
mismatch in criteria expression.

Please help!
Best regards
Wolfgang

---------------------------------------------------------------------
Wolfgang F├╝rtbauer                                      w(dot)fuertbauer(at)eunet(dot)at
Steinbichlstrasse 58d                                   07612/77620
A-4812 Pinsdorf 


pgsql-bugs by date

Next:From: pgsql-bugsDate: 2002-01-08 09:51:16
Subject: Bug #555: Lock-problem via ODBC
Previous:From: Michael HandlerDate: 2002-01-07 20:30:26
Subject: MACADDR type & 00:00:00:00:00:00

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group