We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question
0

ODBC connection to SQL Server on Azure, on Mac

asked 2020-08-17 03:28:33 +0200

JessP gravatar image

Hi there,

I've been tearing my hair out with this all weekend, and I'm hoping someone might have some clues to help me out. I have setup a SQL server database on Azure, and I want my Mac installation of LibreOffice Base (Version: 6.4.6.2) to connect to it.

I've installed Java (Version 8 Update 261) and have a JRE selected in LibreOffice (Oracle Corporation 1.8.0_261). Installed various ODBC drivers and can see them in the ODBC Manager, and have crated the relevant DSN for each. I've tried: - Devart ODBC Driver for SQL Server 3.1 - Microsoft ODBC 13.1 - Microsoft ODBC 17 - freetds v1.2.3

When I try to connect in LibreOffice and test the connection, it fails.

Anyone have an ideas what I'm doing wrong?

Thanks in advance, your help is much appreciated.

edit retag flag offensive close merge delete

Comments

When I try to connect in LibreOffice and test the connection, it fails.

Any error message?

Btw: The whole question sounds like you are running Windows (instead of macOS) on your Mac. Is that true?

Opaque gravatar imageOpaque ( 2020-08-17 11:16:55 +0200 )edit

I'm definitely running macOS Catalina. One error I got was literally just a red square with a cross, and no words. I've tried so many things and received so many different errors. What I really need is some clear end to end instructions on how to connect with ODBC. I ended up giving up and switching to JDBC. My method was roughly install Java 8 > Install JDK 8 > Install JDBC driver > Set preferences in LibreOffice > Create new database with JDBC and connection string info from Azure. Got there eventually but it was SUPER painful. Thanks for your time anyway.

JessP gravatar imageJessP ( 2020-08-17 12:41:55 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2021-06-10 13:05:12 +0200

updated 2021-06-10 16:55:51 +0200

Ratslinger gravatar image

Usually I also use (removed SPAM link - @Ratslinger ) - Reliable and simple to use data connectors for ODBC data sources. Compatible with multiple third-party tools.

edit remove flag flag offensive (1) delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-08-17 03:28:33 +0200

Seen: 126 times

Last updated: Jun 10