Synametrics Technologies

Hello, I am trying to connect with WinSQL but its giving me below error: Please help me to fix it.

---------------------------
ODBC Error
---------------------------
SQL Error State:IM014, Native Error Code: 0, ODBC Error: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application
---------------------------
OK
---------------------------

Irfan,

This is happening because you are using a 64bit driver with WinSQL 9, which is a 32bit application. You cannot use a 64bit ODBC driver with a 32bit application.

The next version of WinSQL (version 10) will be available in both 32 and 64bit. Check http://web.synametrics.com/WinSQLBeta.htm to download the 64bit version. This will work with the driver you are using.

thanks issue resolved after downloading beta version. But I am trying to transfer data from MYSQL to Oracle. And i am not able to drag & drop feature. Please guide me further/

Try the following steps:

• Connect to your MySQL database
• Write your desired query. For example:
  
  SELECT * FROM SourceTable
• From the main menu select Query/Import Export/Export to external DB
• Follow the steps on the screen