Have a search on fetch on this forum. The oracle default fetchsize is around 200.

Solved post

What do you get if you use the Oracle OLEDB drivers for oracle?

Try the oracle drivers instead of microsoft driver for oracle

Glad you sniffed it out.

Check if you have still remains of oracle software (check registry local machine\software\oracle). If I'm not mistaken the .1 points at home1.

Install 64-bit first (full administrator) and then 32-bit in...

Did you install them in a different base directory? 11g has a deinstall bug

Any errors in the install log?

Smallint can be used to store 0 or 1, but isn't supported in Oracle (has number datatype).

ANSI<->TSQL

ANSI<->Oracle

Congratulations

You'll have to specify nogrowth for the datafile like (no autoextend clause)

Like

CREATE TEMPORARY TABLESPACE temp TEMPFILE 'd:\temp\tempfile1.dbf' SIZE 4096M ;

It pays to read the oracle concepts

Oracle concepts

Administrator guide on oracle...

Also check the power saving mode of the vm host(s). For reliable performance: high performance mode instead of balanced power saving

Great article, will reread it twice

MSDAORA is an old driver for Oracle.

Try OracleOleDB or the Attunity drivers

64-bit client version is oracle X.Y.Z.B? Like 11.2.0.2

congratulations