Results 1 to 7 of 7
  1. #1
    Join Date
    Mar 2007
    Posts
    4

    Red face Unanswered: ODBC--Call Failed - Collation Conflict

    Hi Everyone,

    I am fairly new to MS-SQL so excuse my ignorance if I have any.

    I am trying to add and link a new table to an existing database. I can add the database and colums and add some data into it, and even run a query on it. However, if I try to run a query using the new table and and existing table (linked) I get the following error:

    ODBC--call failed.
    [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot resolve collation conflict for equal to operation. (#446)

    Any ideas?

    my Server and SQL specs: SBS2003 & MSSQL ver 8.0

  2. #2
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    what's the query you are executing?

  3. #3
    Join Date
    Mar 2007
    Posts
    4

    reply

    A Simple or Single Join Query

  4. #4
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    post it here.

  5. #5
    Join Date
    Mar 2007
    Posts
    4
    Here is the query :

    SELECT ChangeCustidLog.NewCustid, Customer.CustId, Customer.CustName
    FROM ChangeCustidLog INNER JOIN Customer ON ChangeCustidLog.NewCustid = Customer.CustId;
    Last edited by TheSonic1; 03-22-07 at 15:26.

  6. #6
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    try this:

    Code:
    SELECT ChangeCustidLog.NewCustid, Customer.CustId, Customer.CustName
    FROM   ChangeCustidLog 
    INNER JOIN Customer ON 
         ChangeCustidLog.NewCustid COLLATE Latin1_General_CI_AS =
         Customer.CustId COLLATE Latin1_General_CI_AS;

  7. #7
    Join Date
    Mar 2007
    Posts
    4
    thank you,

    the query works fine with the 'collate' phrase, when run in SQL server. I am having trouble when the query runs in Access (and thats where the linked tables are)..

    is there a way to fix this 'collate' problem??

Posting Permissions

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