[R-sig-DB] calloc error issued by sqlQuery

[Idit Buch]

Hi,

I'm using R version 2.14.1 on Linux (Centos) and trying to issue a "select * from ..." query using sqlQuery(...).
I then receive the following error:
Error in odbcQuery(channel, query, rows_at_time) :
  Calloc could not allocate memory (18446744073709551616 of 22816 bytes)

The function odbcGetInfo(channel) returns the following:

                  DBMS_Name                    DBMS_Ver
     "Microsoft SQL Server"                "09.00.4035"
            Driver_ODBC_Ver            Data_Source_Name
                    "03.52"                       "DSN"
                Driver_Name                  Driver_Ver
"libsqlncli-11.0.so.1790.0"                "11.00.1790"
                   ODBC_Ver                 Server_Name
                    "03.52"                    "RGNSQL"

The function sessionInfo() returns the following:
R version 2.14.1 (2011-12-22)
Platform: x86_64-redhat-linux-gnu (64-bit)

locale:
[1] LC_CTYPE=en_US.UTF-8       LC_NUMERIC=C
[3] LC_TIME=en_US.UTF-8        LC_COLLATE=en_US.UTF-8
[5] LC_MONETARY=en_US.UTF-8    LC_MESSAGES=en_US.UTF-8
[7] LC_PAPER=C                 LC_NAME=C
[9] LC_ADDRESS=C               LC_TELEPHONE=C
[11] LC_MEASUREMENT=en_US.UTF-8 LC_IDENTIFICATION=C

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods   base

other attached packages:
[1] RODBC_1.3-5

loaded via a namespace (and not attached):
[1] tools_2.14.1

Any idea ?

Thanks

Idit Buch, Ph.D.
Computational Biologist


	[[alternative HTML version deleted]]