WinSQL » Knowledge base

Document information

Document ID:817
Subject:I get the following error when importing a databag. Error: Data type for parameter 1 has changed since first SQLExecute call
Creation date:7/29/09 4:50 PM
Last modified on:7/29/09 4:50 PM


Details


Symptoms You get the following error 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? Please add it below. Your name and tip will appear at the end of the document text.
Your name:
Your email:
Hide my email address
Verification code:
Enter the verification code you see above more submitting your tip
Tip:Please limit tips to 1000 characters

Navigation

Social Media

Powered by 10MinutesWeb.com