Thursday, September 22, 2016

Connectivity Options for Microsoft Azure SQL Database

There are many drivers and libraries that client programs can use to connect to Azure SQL Database or Microsoft SQL Server.

The following are the language options:

ADO.NET
Java using JDBC on Windows
PHP
Node.js
Python
Ruby

This enables developers to use their language of choice and appropriateness of thei application to choose.

ADO.NET related specifics here:
https://azure.microsoft.com/en-us/documentation/articles/sql-database-develop-dotnet-simple/

Microsoft JDBC related information here:
https://msdn.microsoft.com/library/mt484311.aspx

Microsoft Node.js driver for SQL Server here:
https://msdn.microsoft.com/library/mt652093.aspx

Connecting with PHP use Microsoft PHP driver for SQL Server here:
https://msdn.microsoft.com/library/dn865013.aspx

Connect using Python:
Get Python SQL Driver
https://msdn.microsoft.com/library/mt652092.aspx

Connect using Ruby:Get Ruby driver for SQL Server here;
https://msdn.microsoft.com/library/mt652092.aspx

I have described in detail with examples connecting to SQL Azure (as it was called then) using ADO.NET, Java and PHP in my book when SQL Azure was still in Beta:

Read more about the book here:
http://hodentek.blogspot.com/2010/12/my-sql-azure-book-is-published.html
http://hodentek.blogspot.com/2011/01/do-you-want-free-copies-of-my-latest.html





No comments:

DMCA.com Protection Status