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

have a look at

alternative

Depends on selectivity (most distinct values goes) and the number of rows returned

WHERE clauses like Date BETWEEN a And B and Database = 'X'.

Assuming the most popular query relies on...

You'll have to check the NLS-settings of the database[/url]

In the earlier days in compares to varchar, but now the database can be fully in unicode so that varchar2 is also...