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
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
