The issue has been closed
This is a guideline to help us to understand SQLTools Issues.
You don't need to stick to this, but please try to guide us to reproduce the errors or understand your feature requests.
Issue Type
Prerequisites (For bugfixes)
Description
I would like to connect not only to MSSQL or MySQL but also to DB2, CSV, Access, etc. using ODBC or JDBC.
Steps to Reproduce (For bugfixes)
- [First Step]
- [Second Step]
- [and so on...]
Expected behavior: [What you expected to happen]
Connection config that allows for JDBC connection and URL
No need to define supported drivers, as this would come along with PATH or CLASSPATH
Actual behavior: [What actually happened]
Versions
- Version: vX.Y.Z
- OS: ...
- SGDB: MySQL, PostgresSQL...
You can get this information from executing SQLTools: Version
from VSCode Quick Open
.
Where was it released? His fork is behind yours and I can't find where you've done a PR for it.
posted by SimonDever about 5 years agoIt was release a few weeks ago. It's part of SQLTools extension. Just install version v0.21.2
and you should be able to see it in the connection assistant
posted by mtxr about 5 years agoIt wasn't me that added DB2 support, it was @snyang :sweat_smile:
The PR is #391
posted by EpicEric about 5 years agoposted by SimonDever about 5 years ago
It wasn't me that added DB2 support, it was @snyang
The PR is #391
Lol. That's true. Thanks @EpicEric and @snyang
posted by mtxr about 5 years agoIt's sad that this was never supported. JDBC and ODBC are highly useful and utilized ways to connect to databases generically without the need to customize the client. It sounds like you've got a tight coupling between the dialect and the driver as a whole. This isn't normal or necessary. Products like Hibernate allow you to connect to any JDBC source generically. Since Hibernate uses canned query approaches, it also has need of a dialect definition, but does not couple this to the driver API in any way. Dialects are specified independently. In addition, Hibernate defines more generic dialects that can often be used across multiple databases for which no specific dialects have yet been defined.
posted by a019647 about 4 years ago@mtxr - any plans supporting odbc driver for redshift?
posted by shrikantkulkarni23 almost 4 years agoCouldn't be developed a generic JDBC driver implemented with node-jdbc?
This would allow connecting with any database that has a JDBC driver (despite you have Java installed and available in the PATH) without having to implement an specific SQLTools driver for that database.
posted by rubensa over 3 years ago
It was release a few weeks ago. It's part of SQLTools extension. Just install version v0.21.2
and you should be able to see it in the connection assistant
I can't find that driver in the extensions-browser :-(
posted by denladdi 11 months agoposted by gjsjohnmurray 11 months ago
@denladdi this driver is no longer available. Please see #454 (comment) and subsequent comments.
gotcha.. sadly nothing new there.. hoped I could switch from SQL Workbench (JS), HeidiSQL, DreamWeaver and various other SQL/coding tools to just using vs code :-(
Hope this evolves somewhen.
posted by denladdi 11 months ago