Windows 10: How to connect to a MariaDB via the SQL Management Studio SSMS

From the SQL Management Studio (SSMS) there is a way to connect/create a linked server to a MariaDB. For this you would need the following.

– Install the ODBC Connector for MariaDB
– Create an ODBC Connection (System DSN)
– Add Linked Server.

Installing the ODBC libraries for MariaDB

Browse to https://mariadb.com/downloads/connectors/connectors-data-access/odbc-connector/
Download the required ODBC installer for Windows.



Install the downloaded “mariadb-connector-odbc-3.2.3-win64.msi” file

Creation of the ODBC connection

Open the ODBC Data Source Administrator (64-bit)
Click on System DSN
Click on Add
Select MariaDB ODBC 3.2 Driver
Give the connection a name
Enter the server details and click on Test DSN to confirm the connectivity.



Setting up the connection via the SSMS

Open the SQL Management Studio
Connect to the SQL instance
Click on Server Objects and right-click on Linked Servers
Click on New Linked Server



Enter a name in the linked server section
Change the Provider to Microsoft OLE DB Provider for ODBC Drivers
Enter the ODBC Connection name you created in the Data Source section
Click on Security
Click on Be made using this security context and enter the credentials of the MariaDB server



Click OK

This will create the connection and you can browse the data.



read more...

 

Announcing SQL Server Management Studio – 16.5.1 Release

Source: Announcing SQL Server Management Studio 16.5.1 Release | SQL Server Release Services

 

Announcing SQL Server Management Studio – March 2016 Refresh


Announcing SQL Server Management Studio – March 2016 Refresh

Source: https://blogs.msdn.microsoft.com/sql...-shell-update/

 

Microsoft SQL Server Management Studio 18 setup doesn't launch

Hello,

I've been trying to install Microsoft SSMS (SQL Server Management Studio) onto my computer and the installer doesn't appear when I double-click it. I have tried running the program as administrator, and also restarted my computer. I have also tried installing it via the command-line based on the instructions listed here: https://docs.microsoft.com/en-us/sq...udio-ssms?view=sql-server-ver15#download-ssms and haven't been successful. I am on Windows 10 Pro build 19044.

There are no error messages that appear on the screen, I just try to launch the program/installer and nothing happens. I can install/use a previous version of SSMS just fine. I have been trying to look for any log file that has some error information but haven't been successful and don't know where to look otherwise. Has anyone had any experience with this before?