0

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?

emilpytka
  • 763
  • 7
  • 19
  • Possible duplicate of [Connecting to SQL Azure in Server Explorer](http://stackoverflow.com/questions/10979427/connecting-to-sql-azure-in-server-explorer) – Michael Freidgeim Aug 10 '16 at 01:39

1 Answers1

0

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.

AvkashChauhan
  • 20,495
  • 3
  • 34
  • 65
  • Thanks, it's weird that earlier everything worked. Unfortunately i can't change database collation so i have to create a new one, but thanks for help. – emilpytka Jun 11 '12 at 18:50
  • Thanks us3r!! Creating new sure will work and while creating you can follow the guidance provide by the SQL Azure team. – AvkashChauhan Jun 11 '12 at 18:59
  • Perhaps this is the same as the problem described [here](http://stackoverflow.com/questions/12216003/azure-nodejs-site-cannot-connect-to-sql-db-that-has-a-collation-different-than-t). No matter what, a connection to a non standard collation DB will not work – abinop Aug 31 '12 at 15:43