[erlang-questions] Very strange ODBC behaviour under 64 bits?

Laura M. Castro Souto <>
Wed Apr 2 17:25:04 CEST 2008


   Hello list,

	I have just changed my old 32-bit development box by a 64-bit one, and I am 
facing the strangest behaviour of the Erlang ODBC module.
	Assume a table named 'divisas', which has a few rows. This is what I am 
getting:

> {ok, Co} = odbc:connect("DSN=database-name;USR=user-name;PWD=password",[]).
{ok,<0.51.0>}
> odbc:sql_query(Co, "select * from divisas").
[{selected,[],[]},
 {},{},{},{},{},{},{},{},{},{},{},{},{},{},{}]
> odbc:sql_query(Co, "insert into divisas values (9, 'Test 
divisa ', 'TES', '0')").
{updated,1}
> odbc:sql_query(Co, "select * from divisas").
[{selected,[],[]},
 {},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{}]
> odbc:sql_query(Co, "update divisas set dvs_abr = 'PRU' where dvs_oid = -9").
{updated,1}
> odbc:sql_query(Co, "select * from divisas").
[{selected,[],[]},
 {},{},{},{},{},{},{},{},{},{},{},{},{},{},{},{}]
> odbc:sql_query(Co, "delete from divisas where dvs_oid = -9").
{updated,1}
> odbc:sql_query(Co, "select * from divisas").
[{selected,[],[]},
 {},{},{},{},{},{},{},{},{},{},{},{},{},{},{}]

	The thing is that, every time I submit the above SELECT query, I was checking 
both via a database shell (psql, since the database server is PostgreSQL) and 
via an odbc shell (isql), and the changes are visible (i.e. data is inserted, 
updated and then deleted, as said by the sql_query command return value). So 
the disturbing thing is that only SELECT queries seem not to be working at 
all, always returning empty tuples.

	I am running R12B-0. I am assuming the 64-bit change has something to do 
because I was running R12B-0 on the previous 32-bit computer. Any 
clues/suggestions?

	Thanks in advance.

--
Laura M. Castro
MADS Group - Computer Science Department
University of A Corunna
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part.
URL: <http://erlang.org/pipermail/erlang-questions/attachments/20080402/bf355d2f/attachment.bin>


More information about the erlang-questions mailing list