=========================================================================
Date:         Sat, 8 Jul 2006 05:57:26 +0100
Reply-To:     "John S. Lemon" <j.s.lemon@abdn.ac.uk>
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         "John S. Lemon" <j.s.lemon@abdn.ac.uk>
Subject:      Re: Get Data ODBC help!
Comments: To: Julia Li <jli@DWD.IN.GOV>
In-Reply-To:  <200607071856.k67IcuLZ011070@mailgw.cc.uga.edu>
Content-Type: text/plain;charset=iso-8859-1

Julia

The first course of action is to use the 'Paste' option on the final
screen and then check to see what commands have been generated by the
wizard. There is just a chance that something is not quite right. If you
are still having problems post the syntax commands to the list when we may
have some further ideas.

> I use SPSS 12.0 Database Wizard to get data from remote SQL sever.  All
> steps up "Result" went thought smoothly.  Wizard generated SQL query base
> on my selection. But after run "retrieve the data I have selected", I get
> error message like this:
>>Error. Command name: GET DATA
>>Unknown error
>>This command not executed.
> I tried to reinstall SPSS, reboot my computer but still got the same
> error.



Best wishes

John S. Lemon     Mailto:j.s.lemon@abdn.ac.uk
 DISS - ASD (Computing)    Tel: +44 1224 273350
 Aberdeen University - Scotland