Re: problem with get data statement
From: Helma <helma.vinke_at_hotmail.com>
Date: Thu, 9 Jul 2009 07:38:05 -0700 (PDT)
Message-ID: <d13ec5b7-5720-45bd-9416-016889b9a52b_at_q11g2000yqi.googlegroups.com>
On Jul 9, 4:01 pm, elodie <elodie.gill..._at_gmail.com> wrote:
> 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.- Hide quoted text -
>
> - Show quoted text -
Date: Thu, 9 Jul 2009 07:38:05 -0700 (PDT)
Message-ID: <d13ec5b7-5720-45bd-9416-016889b9a52b_at_q11g2000yqi.googlegroups.com>
On Jul 9, 4:01 pm, elodie <elodie.gill..._at_gmail.com> wrote:
> 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.- Hide quoted text -
>
> - Show quoted text -
Yes, there is some information on this linkpage, the first link gives some hints:
http://tinyurl.com/mg24d8 Received on Thu Jul 09 2009 - 09:38:05 CDT