Join GitHub today

  • Create ODBC driver for DocumentDB Because you're supporting SQL in DocumentDB, a standard for interacting with a database that supports SQL is ODBC. Would increase interoperability with any ODBC consumer (e.g. A variety of Microsoft and non-Microsoft products).
  • We are pleased to announce an update to the Microsoft ODBC Driver 17 for SQL Server! Added Support for SQLCOPTSSCEKCACHETTL and SQLCOPTSSTRUSTEDCMKPATHS connection attributes Azure Active Directory Interactive Authentication Support Fixed This release also contains the following fixed issues: Fixed 1-second delay when calling.
  • My Tasks need to access an Azure SQL server database and my code is written in Python. Before I can use pyodbc, I need to install the Microsoft ODBC Driver 13 for SQL Server. I've tried following the guide here and added the commands to the Azure Batch Pool StartTask to install the libraries on the nodes, but I am getting errors.
  • Azure CosmosDB provides ODBC driver that enables you to query CosmosDB collections like classic databases. In this post you will see how to query CosmosDB collections from Sql Server using Transact-Sql.

Deploy an Azure SQL database is a very easy task and you don’t have to worry about the hardware, deployment issues around applications. You can deploy the SQL DB in a few minutes and start using it by using this you will save a lot of time and cost to hardware. Download the ODBC Driver to the Machine you want to access the SQL Database.

GitHub is home to over 40 million developers working together to host and review code, manage projects, and build software together.

Sign up New issue

Odbc Driver Access

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Comments

commented Oct 11, 2018

I'd like to be able to connect from a Python Azure Function in the 2.0 runtime (consumption plan) to an Azure SQL Server 17 database.

Currently receiving the error: OdbcNoLibrary: ODBC Library is not found. which should be resolved by #32, but I believe the correct driver would also need to be installed for unixodbc to actually make the connection. I found instructions for that here: https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-2017 .

Could we have this driver installed to the base image for Python Azure Functions, to enable out-of-the-box SQL Server 17 connectivity?

commented Oct 15, 2018

Driver

Odbc Driver Azure

should be fixed in 77e57d3

closed this Oct 15, 2018

commented Oct 16, 2018

I believe the particular SQL Server driver needs to be made available as described above. With the changes you mentioned, my error advanced from OdbcNoLibrary: ODBC Library is not found. to ('01000', '[01000] [unixODBC][Driver Manager]Can't open lib 'ODBC Driver 17 for SQL Server' : file not found').

If I'm mistaken and this is working as intended, could you advise on what needs to be changed for this to work with the current installation? If it helps clarify, I'm trying to use the pypyodbc library and the SQL Server driver mentioned in the error above.

commented Feb 11, 2019

@Rye6 I don't know if you figure out but I was successful by not hard-coding the driver version:

Odbc Driver Azure Sql Server

commented Apr 9, 2019•
edited

Microsoft Odbc Driver Azure

I believe the particular SQL Server driver needs to be made available as described above. With the changes you mentioned, my error advanced from OdbcNoLibrary: ODBC Library is not found. to ('01000', '[01000] [unixODBC][Driver Manager]Can't open lib 'ODBC Driver 17 for SQL Server' : file not found').

If I'm mistaken and this is working as intended, could you advise on what needs to be changed for this to work with the current installation? If it helps clarify, I'm trying to use the pypyodbc library and the SQL Server driver mentioned in the error above.

Test-drive the world's most advanced digital sculpting solution. With the ZBrush 2018 free Trial you will have unlimited use of all the features found in ZBrush 2018 and complete freedom to evaluate how it can fit your needs as an artist. There are no watermarks or feature restrictions of any kind. Sculptris is a free 3D modeling software by the same developers as ZBrush. Pixologic acquired the program to integrate some of its features. The most remarkable feature is its automatic level-of-detail that frees users from the pains of manual subdivision control and re-meshing. Free zbrush software. ZBrush 4.7.3 can be downloaded from our website for free. ZBrush lies within Photo & Graphics Tools, more precisely Viewers & Editors. The following versions: 4.6, 4.5 and 4.4 are the most frequently downloaded ones by the program users. Oct 26, 2017  This is a painting and digital sculpting software that redefined 3D creativity and design. It features advanced tools that feels natural and elegant to use. It works well in both non linear.

This worked for me
https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-2017#microsoft-odbc-driver-131-for-sql-server

Odbc Driver Install

Sign up for freeto join this conversation on GitHub. Already have an account? Sign in to comment