hello,
we have postgres 9.0.1 installed on a windows 2008 r2 server.
odbc is psqlodbc_09_00_0200.zip.
the database has currently a size of around 800mb.
it works as expected on the server (pgadmin), but if we try queries for
large datasets we get the error message: "No data" from our frontend or
any other database tools thats using the ODBC connection (e.g. anysql
maestro).
1.) first we will make a query with only 1 column. we get data.
2.) then make the same query but with all columns: it says "No data".
3.) Afterwards we try the query from before again, but still getting "No
data".
Only a reconnect will "fix" that!
here are the results:
select sample_number from result
Query OK, 325194 rows affected (28.75 sec)
select * from result
Query OK, 0 rows affected (8.75 sec)
select sample_number from result
Query OK, 0 rows affected (0.20 sec)
cheers jk