Problems Connecting with Oracle Database, Win7 64 bit OS

I am having the identical issue that was described in the question linked below. Basically, when obtaining data from an Oracle 9i database using a Win7 64-bit system, MatLab R2010a, on the first attempt the returned data is only the first row of what should be the result, and on follow up attempts no data is returned.

The solution provided previously was to set up and use JDBC connections instead of ODBC. Does anyone know if there is another way to fix this problem without switching to JDBC? Is this a common problem? Much thanks.

http://www.mathworks.nl/matlabcentral/answers/3116-database-connectivity-in-matlab-2010b-picks-up-only-one-row-from-oracle

Answer 1

[Matthew]

I no longer need an answer - I found this helpful page on how to set up JDBC connections and found it wasn't as hard as I originally thought. All it took was a tweak to the classpath.txt file and a more explicit database command. Granted I already had the "thin" JDBC drivers installed with my Oracle Client 11g install, which helped.

<http://www.mathworks.com/support/solutions/en/data/1-CL94AW/index.html?product=DB&solution=1-CL94AW>