Reputation: 114
I have seen extensions that allow you to connect to a MySQL database, PostgreSQL, Oracle, etc ... But I have not found a way to connect to an SQL Anywhere database (or to connect to an ODBC created in the system). Does anyone know how to do it?
EDIT: This is the conection data on ODBC (that works): ODBC Conecction
Upvotes: 2
Views: 9374
Reputation: 1018
Check out the extension vscode-database. I have tried this, and it works flawlessly.
Upvotes: 0
Reputation: 29
I found the extension database-client. It supports MySQL, PostgreSQL, and SqlServer, and works fine for me.
Upvotes: 2
Reputation: 1308
1- Check that you have the extension : SQL Server (mssql)
2- Press F1 to show all commands
3- Write "sql" to search, and then choose : "MS SQL : Connect"
4- Fill the needed information step by step, choose SQL as language, server name, username, password, ...
5- Ready to write your first query!!
Upvotes: 0