SQL Azure cannot connect to database with Polish collate
Since Microsoft released new SDK for Windows Azure (June 2012) i have problem with connect to SQL Azure database with collation set to 'Polish_CI_AS'.
With previous sdk it works fine. Now when i want to add new connection string i have error:
"Unable to add data connection. Failed to retrieve data for this request. Unknown property PrimaryFilePath"
With default collation (SQL_Latin1_General_CP1_CI_AS) connection string is creating.
Did anyone know how to fix it?
I believe your problem and solution is described here in this blog Working With Collations In SQL Azure
The default collation for character data in SQL Azure databases is SQL_Latin1_General_CP1_CI_AS. This collation is also used across the SQL Azure infrastructure to sort and compare metadata that defines database objects. The server and database level collations are not configurable in SQL Azure. However, you can use a collation of your choice at the column and expression level.