Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002
    Location
    London
    Posts
    73

    Unanswered: Collation Conflict

    Hi i am using MS Access and the tables are linking off SQL 2008.

    When i am trying to run the query in ms access by joining 2 tables there is an error message coming up
    "ODBC failed"
    [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "Latin1_General_Bin" in the equal to operation (#468)

    In SQL view i was also getting a similar message, but i found out i had to put the below in bold to run the query which works


    SELECT dbo_Table1.Field1, table2.field2
    FROM dbo_ASC_PMA_TBL RIGHT JOIN SALES_MAIN ON dbo_Table1.Field1 COLLATE Latin1_General_BIN = table2.field2.

    Can you please let me know what i need to put for MS Access please

    Thanks

    Hemish

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    I'm not sure of how you can solve that in Access but why don't you create a view or a stored procedure in the database on the SQL Server, then link it in Access (linked table or pass-through query)?
    Have a nice day!

Posting Permissions

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