ODBC query - incomplete results

Moderators: statman, Analyst Techy, andris, Fierce, GerineL, Smash

dianek
Posts: 2
Joined: Tue Jun 23, 2015 3:09 pm

ODBC query - incomplete results

Postby dianek » Tue Jun 23, 2015 3:27 pm

Have been trying to open a data set (2 million rows) that resides in Oracle 11g for 2 weeks. I use SPSS v21.0.0.2. I've done this hundreds of times; whenever the data is refreshed I query the new table. However now the query only returns a small number of rows. Sometimes 2, sometimes 150, sometimes 2000. If I reduce the number of columns I'm requesting I can usually get all the rows. But then I have to merge them together. Which is no big deal, but seriously? Have found no problems with my ODBC driver, no trouble connecting to the data base. No errors in SPSS. Has anyone else experienced this odd problem?
dianek
Posts: 2
Joined: Tue Jun 23, 2015 3:09 pm

Re: ODBC query - incomplete results

Postby dianek » Tue Jun 23, 2015 8:14 pm

Downloading spss v23 appears to have resolved this issue. Apparently there were some version incompatibilities with the version of Oracle in our environment.

Who is online

Users browsing this forum: No registered users and 1 guest

cron