55 questions
0
votes
0
answers
433
views
VS Code SQLTools: 'No active connection found' error even after successful MySQL connection
I'm using VS Code with the SQLTools extension to connect to a local MySQL database, but I'm unable to make a proper connection.
How to properly attach a .sql file or open editor to the active SQLTools ...
0
votes
1
answer
478
views
Cannot connect to Oracle thas uses wallet (certificates) with SQLTools
We have an Oracle database (external supplier) which we want to connect to with certificates. I have in the file tnsnames.ora the next entry:
TESTDB =
(DESCRIPTION=
(ADDRESS_LIST =
(...
- 1
0
votes
1
answer
191
views
VSCode SQLTools gives unnecessary errors for non-keywords as keywords
VSCode SQLTools gives unnecessary errors for non-keywords as keywords such as position, name, password, etc.
DROP DATABASE IF EXISTS VolleyDB;
CREATE DATABASE VolleyDB;
USE VolleyDB;
CREATE TABLE ...
2
votes
0
answers
230
views
SyntaxError: Unexpected token '.' when running SQLTools in VScode
SyntaxError: Unexpected token '.'
at wrapSafe (internal/modules/cjs/loader.js:1054:16)
at Module._compile (internal/modules/cjs/loader.js:1102:27)
at Object.Module._extensions..js (...
- 29
-1
votes
1
answer
6k
views
How to use VS Code's SQLTools extension to log in to a SQL Server database with domain credentials
I can successfully use SQL Server Management Studio and Python (via SQLAlchemy) to access a database. I would like to use VSCode's SQLTools extension to do the same. Below are my settings
These ...
- 190
0
votes
0
answers
244
views
VSCode extension "SQL Tools" showing duplicate attributes in mysql database
enter image description here
I am using SQL tools extension in VScode and using sequelize library, managing the SQL database queries but recently i found a problem in the SQL tools database(extension ...
2
votes
0
answers
342
views
LOCAL INFILE ERROR: but as of v2.0 you must provide streamFactory option returning ReadStream
I wanted to upload a csv file using SQL commands but I got this error.
As a result of LOCAL INFILE command server wants to read yob2019.csv file, but as of v2.0 you must provide streamFactory option ...
- 21
0
votes
2
answers
2k
views
SQLTools Teradata Driver v0.4.0 Plugin is not getting registered
It used to work earlier but suddenly one day this error popped up, and since then it always fails to get registered. Every other driver gets registered but this one.
Here's the log:
type here[...
0
votes
0
answers
83
views
sending query from a C program using sqltools (in visual studio code)
i'm trying to send queries from a C program using the sqltools extension in vs code, which i have already connected to my mysql database on xampp, but i can't find any way to send queries directly ...
0
votes
0
answers
1k
views
Setting up Athena connection in VSCode using VPN
I am trying to set-up Athena connection in VSCode using SQLTools extension.
When I do Test Connection, I get this error
Error opening connection Inaccessible host: athena.us-east-1.amazonaws.com'. ...
- 2,299
1
vote
1
answer
3k
views
Why does my Redshift connection work on DBeaver but not on VSCode SQLTools?
I'm relatively new to SQL, but currently I'm using a VPN trying to connect into a Redshift database. Here are some of the details
Driver Name : AWS / Redshift
Host : 10.x.xxx.48
Port : 5439
Username : ...
- 244
1
vote
1
answer
264
views
Call procedure sql-tool vscode
I couldn't figure out where the problem is!
The procedure is successfully created but the call throws the following error:
Cannot read properties of undefined (reading 'undefined')
Full example:
-- @...
- 410
0
votes
1
answer
2k
views
Getting error trying to run script with SQLTools
I tryed to use the SqlTools extansion for VSCorde and wanted to run the script with it and gives me this erros (I'm using github codespaces)
[1674681282366] INFO (ext): EXECUTING COMMAND => ...
0
votes
1
answer
69
views
adding data from two different tables using a trigger
I created three tables A (id, name, date, realnumber, integer), B (id, name, date, realnumber, integer), and C which is identical to table A. It only has two more columns called integerB and sequence ...
- 1
1
vote
0
answers
687
views
vscode shows postgresql query execution error but not the detail
I'm using vscode 1.74.2 with SQLTools extension v0.26.0 with postgresql 15.
when I run a query that results in an error in psql it returns error output in several namespaces, for example in my case ...
- 32.5k