• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1561
  • Last Modified:

SPSS error message; importing data from Oracle

In attempts to import data into SPSS from Oracle, I keep getting the following error messages:
>Warning.  Command name: GET DATA
>SQLExecDirect failed :[Oracle][ODBC][Ora]ORA-24324: service handle not initialized

>Error # 100.  Command name: VARIABLE LABELS
>This command is not permitted before the beginning of file definition
>This command not executed.

>Error # 105.  Command name: EXECUTE
>This command is not valid before a working file has been defined.
>This command not executed.

Does anyone know what exactly these mean, and how I can get around them?
  • 2
1 Solution
the connection to oracle is not being specified properly..can you verify the settings for the ODBC connection?
mintsiiAuthor Commented:
We have an oracle client set up that is trying importing tables from the oracle 9i DB over our local network.  We can get at the db and see the tables that exist, however, when we try to run a query, it gives the error message above.  What information would you like about the ODBC connection.
check out in the database there will be an alert log file. this file will be having an error.
this error will be for the same time as the time you tried to execute the query. so try to sho that error here and we might be able to help you

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now