Thread: odbc problem on windows?

odbc problem on windows?

From
Axel.Fix@iff.fraunhofer.de
Date:
hallo,
 
i use the cygwin postgresql 7.03.x and i have ported some tables from access to pg. for example you can see the table definition at the bottom of this mail. and there are some datasets in this table (more than 1!!!).
with libodbc++ i login into the db, create and execute my select-statement and get the resultset with:
  odbc::ResultSet* rs = stmt->getResultSet();
 
and with rs->next() i go to the first dataset. all to this point works fine and the data is also correct. but if i try to get the next dataset with rs->next() i get this sql-exception:
  Error fetching numeric statement option: Not positioned on a valid row.
 
but there are more than 1 dataset in this table.
the odbc driver seems to work correctly cause access shows me all datasets.
 
i hope, somebody can help me.
thanks in advance,
axel
 
 

CREATE TABLE public.devices ( key_devclass int4 NOT NULL, key_devname varchar(50) NOT NULL, CONSTRAINT devices_pkey PRIMARY KEY (key_devname)) WITH OIDS;

 


Re: odbc problem on windows?

From
s0lao@netscape.net (S. L.)
Date:
Hello,

[...]
>i use the cygwin postgresql 7.03.x and i have ported some tables from
>access to pg.
[...]

There is not enough info for someone to give you an advice.
Here are some hints:
1. Try to use another method to browse the table using ODBC (e.g. Excel, or OpenOffice Calc)
2. One issue with the ODBC is that one needs a driver for a certain database. There are differences beteewn backend
versionssome drivers may connect to or not. So, are you sure your backend/driver versions match ? 

SLao

__________________________________________________________________
Introducing the New Netscape Internet Service.
Only $9.95 a month -- Sign up today at http://isp.netscape.com/register

Netscape. Just the Net You Need.

New! Netscape Toolbar for Internet Explorer
Search from anywhere on the Web and block those annoying pop-ups.
Download now at http://channels.netscape.com/ns/search/install.jsp