How to link window Azure database to my window 8 application

Question

1.00/5 (1 vote)

See more:

I have created a Window Azure database but I not sure how to link to my Window 8 application

I am using Visual studio 2012 to create my window 8 application and using C#

How to connect anyone here know ? please guide me

thank you

Posted 23-Jan-13 16:29pm

weixiongpoh

Add a Solution

Comments

Sergey Alexandrovich Kryukov 23-Jan-13 23:26pm

XAML?!

Jeff Blankenburg 6-Feb-13 11:44am

Have you looked at Windows Azure Mobile Services? Pretty remarkable set of tools.

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

André Kraak · Answer 1 · 2013-01-27T09:19:00

Solution 1

Guidelines for Connecting to Windows Azure SQL Database[^] should be a good place to start.

Posted 27-Jan-13 9:19am

André Kraak

Comments

weixiongpoh 27-Jan-13 21:48pm

I having a error message while connecting

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

Is the network problem ?

JasonMacD · Answer 2 · 2013-02-27T07:05:00

Port 1443 needs to be opened to connect to Windows Azure DB, you also need to add your IP address to allow access to the Azure server (click on the "Manage Allowed IP Addresses" link on the DB dashboard to set your local machine's IP address) . Also if your on your Windows Azure Portal, click the Database tab > Click your Database Name > then Click Connection Strings, use the Connection String info in SSMS to connect the Database Remotely. Because the useraneme has an @ sign behind it with the server name. So if your not including that then it would fail.

Steve Maier · Answer 3 · 2013-02-27T10:15:00

Jeff's comment about using Windows Azure Mobile Services is a great suggestion. Don't let the name mobile services fool you, It is setup for Windows 8 as well as iOS.

http://www.windowsazure.com/en-us/home/scenarios/mobile-services/[^]

If you don't want to do that then you could always create your own service to connect to that to access the database. I do that with one of my apps, since I connect to it from iOS, android, WP7/8, Windows 8, and Facebook. I created a web service and connected to the database with EF.

How to link window Azure database to my window 8 application

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0