|
|
|
|
|
AQT is a 32-bit application. It runs without problem on a 64-bit version of Windows. However, there are a few things you need to be aware of. These are described in the following sections
AQT can only connect to a database using a 32-bit ODBC Driver.
When you start AQT, you will be shown a list of all the datasources defined to your system. This will include datasources that use both 32-bit and 64-bit ODBC drivers. You cannot tell, from this list, which datasources use a 32-bit driver, and which use a 64-bit driver.
If you try to connect to a datasource that uses a 64-bit ODBC driver, you will get message:
Data source name not found and no default driver specified
The solution is to define a datasource that uses a 32-bit ODBC Driver, and connect using this.
This is described in more detail in http://support.microsoft.com/kb/942976
When you start the ODBC Datasource Administrator program, you will get the 64-bit version of the program. This will show you only 64-bit ODBC Drivers. Datasources created with these cannot be used by AQT.
To manage the 32-bit ODBC Drivers and Datasources, you need to start the 32-bit version of the ODBC Datasource Administrator program. This can be found at c:\windows\sysWOW64\odbcad32.exe
When you attempt to connect to an Oracle database, you may get message:
TNS could not resolve the connect identifier
There are a number of possible causes of this error message - see Oracle - Diagnosing Connection Problems. However, there is a problem in the 64-bit Windows environment that may be responsible for this problem. This is discussed below.
By default, AQT will be installed into C:\Program Files (x86)\Advanced Query Tool. The Program Files (x86) directory structure is used for 32-bit applications. However there is a bug in the Oracle client - when you run a program which has a bracket in the path, the Oracle client will fail to parse tnsnames.ora correctly, resulting in the above message.
The resolution to this problem is to install AQT into a directory that doesn't have a bracket in the name.