WinSQL » Knowledge base

Document information

Details

Symptoms You are getting the following error message when importing data from a DataBag to any database:

[ERROR] Unable to insert data. Row number = 2. Error: Data type for parameter 1 has changed since first SQLExecute call.

This error occurs when you are using an ODBC driver from DataDirect Technologies. Note that the drivers that ship with WinSQL are made by this company and some drivers shipped with Informix and Sybase are also made by the same company.

Work-around:
To avoid this problem follow the steps below.

1. Login as Administrator on the machine
2. Use Regedit or any other Windows Registry editor
3. Select Edit/Find on the main menu and search for your DSN name. This is the name that gets displayed in WinSQL connection window.
4. Click Find Next to search. You should end up with a registry entry that matches with following path:
   
   HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI   OR
HKEY_CURRENT_USER\SOFTWARE\ODBC\ODBC.INI
   
   If the path does not match with these value, go to the next search results.
5. When you select the DSN in Regedit, it should display some key-value pairs on the right hand side.
6. Add a new String Value and call it WorkArounds. Assign 536870912 as the value for this newly added key.
7. Start WinSQL and try to import data again.

Add a comment to this document

Do you have a helpful tip related to this document that you'd like to share with other users?

Your Name

Email

Hide my email address

Captcha

Your Tip

Submit Tip