problem with get data statement
Date: Thu, 9 Jul 2009 07:01:19 -0700 (PDT)
Message-ID: <deeb0755-ea06-4684-b193-00ee6dec4b92_at_v20g2000yqm.googlegroups.com>
Hi everyone,
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=
'DSN=XXX;UID=XXX;PWD=dc99;DBQ=XXX ;DBA=X;APA=X;EXC=X;FEN=T:Fa;'
'QTO=T;FRC=10;FDL=10;LOB=F;RST=T;GDE=T;FRL=T;BAM=IfAllSuccessful;MTS=F;'
'MDI=F;CSR=T;FWC=F;PFC=100;TLO=0;'
/UNENCRYPTED
/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).
cache.
execute.
>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