Hello,
Im using SPSS v18 with MySQL server. To get data from my db to the spss Im using mysql odbc driver v.5.1.6.
Im trying to with with enourmous db (22million rows). SPSS imports the data ok, even the right amount,
but I still get an error (pasted below) in the statistics viewer. Now I dont know if anything went wrong during the import of my data from the db or if the error msg is just "false alarm".
error msg:
Code:
GET DATA
/TYPE=ODBC
/CONNECT='DSN=DB;'
/SQL='SELECT * FROM payment'
/ASSUMEDSTRWIDTH=255.
>Warning. Command name: GET DATA
>SQLExecDirect failed :[MySQL][ODBC 5.1 Driver][mysqld-5.0.45-community-nt-log]MySQL client ran out of memory
CACHE.
EXECUTE.
>Error # 105. Command name: EXECUTE
>This command is not valid before a working file has been defined.
>Execution of this command stops.
DATASET NAME DataSet1 WINDOW=FRONT.
Does anyone knows how to handle this?
thank you!!!
