Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Location
    India
    Posts
    2

    Unanswered: General SQL error. Unicode data in a.....

    Hi,

    While trying to execute SELECT statement its giving the following error :


    Message: General SQL error. Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-Library (such as ISQL) or ODBC versioÀ

    I'm using MS SQL Server 2000.
    Anyone has any idea why this error is poping up ?

    How will I rectify this ?? I tried installing the latest version of MDAC 2.7. Will MDAC 2.7 install the latest version of ODBC. Is there any separate setup for ODBC ??

    Please help.

    Thanks
    Rajeev R

  2. #2
    Join Date
    Feb 2002
    Location
    Houston, TX
    Posts
    809
    What tool or program are you issuing tyhe select from?

    The error indicates you are connecting to your DB via DB-Lib or a very old ODBC driver. Updateing MDAC will NOT update your ODBC drivers.
    Paul Young
    (Knowledge is power! Get some!)

  3. #3
    Join Date
    Jun 2003
    Location
    India
    Posts
    2
    Hi,

    I have developed the application using Borland Delphi 4. I uses the TQuery component to fire the query. I have about 100 customers using my application and having no problems. The error is coming only for one customer.

    If MDAC won't install the latest version of ODBC, then how will I install the latest version of ODBC. Can i know from where I can get the latest version of ODBC ??

    Thanks
    Rajeev R

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •