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?

Answers


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.


Need Your Help

Double for loop with arrylist that are changing size

java debugging for-loop arraylist

The situation is that I have two nested for loops that are each iterating through an arraylist of objects. The outer for loop grabs the object at the current index and adds it two another arraylist

how to specify the URL for calling the webservice from android emulator?

android .net web-services

I want to use my local .net webservice (which is not yet hosted) in an android application in my local machine.Is it possible? What URL should I use to call the web service ?