mtxr/vscode-sqltools

ODBC/JDBC support #44

FireFighter1017 posted onGitHub

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

  • Feature Request
  • Bugfix/Errors
  • Questions
  • Other

Prerequisites (For bugfixes)

  • Are you running the latest version?
  • Did you check the logs?
  • Did you check the Setup?

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)

  1. [First Step]
  2. [Second Step]
  3. [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 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

image

posted by mtxr about 5 years ago

It wasn't me that added DB2 support, it was @snyang :sweat_smile:

The PR is #391

posted by EpicEric about 5 years ago

Thank you

posted 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 ago

It'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 ago

Couldn'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

image

I can't find that driver in the extensions-browser :-(

posted by denladdi 11 months ago

@denladdi this driver is no longer available. Please see https://github.com/mtxr/vscode-sqltools/issues/454#issuecomment-678024106 and subsequent comments.

posted 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

Fund this Issue

$0.00
Funded

Pull requests