problem with get data statement
Date: Thu, 9 Jul 2009 07:01:19 -0700 (PDT)
I am having a hard time running a get data statement in SPSS. It appears that there could be a problem with the SQL driver. I am clueless as to how to approach this. The syntax and error message are below, I have Xed out some of the details. Any ideas on how to solve this problem? Thanks for the help.
GET DATA /TYPE=ODBC /CONNECT=
/SQL = 'select * from XXX where id=30 and id<999999 order by id'.
>Warning. Command name: GET DATA
>SQLDriverConnect failed :Specified driver could not be loaded due to system error 1114 (Oracle in OraClient10g_home3).
>Error # 105. Command name: execute
>This command is not valid before a working file has been defined.
>This command not executed.
Received on Thu Jul 09 2009 - 09:01:19 CDT