Stack Overflow
Stack Overflow

Questions tagged [sqltools]

51 questions
1
vote
1 answer

Connections not showing on VSC with SQLTools

I don't know if this is the place to ask, but I'm desperate. So I've trying to make a connection with SQLTools on VSC, but it won't work. I think it is making the connection, but it's just not showing up. I don't know why this is, but I've tried…
polelord
  • 45
  • 6
1
vote
1 answer

Any way to connect to more than one db in the same connection? (using SQLtools extension in VScode)

I'm trying to connect to 2 db's from the same connection simultaneously but I can't seem to find a way to do so. The idea is to get something like this. { "sqltools.connections": [ { "previewLimit": 50, "server": "localhost", …
Vincent Adams
  • 51
  • 6
1
vote
1 answer

Unable to get execute result (SQL-Tools)

I have retrieve a record from my database (sqlite). When I ran the following code: from sql_tools import sqlite sqlite.connect("base.sqlite3") names = sqlite.execute("SELECT * FROM NAMES") print(names) sqlite.disconnect() It gives me an object…
user11096038
1
vote
2 answers

Only localhost doesn't work in Oracle

I installed Oracle 11g R2 on my computer and I connected with my localhost (by SQLTools) and external hosts. Everything worked good. I turned off and turned on my computer and I can't connect to my localhost (ORA-12541). External hosts work ok…
Robert Daraż
  • 323
  • 2
  • 19
1
vote
0 answers

Execution of .sql file through sqltool utility in hsqldb

I am trying to execute the demofeature_enable.sql file through the following way. java -jar sqltool.jar --inlineRC=url=jdbc:hsqldb:hsql://localhost:9999/bwdb,user=sa,password= demofeature_enable.sql The above command is throwing follwoing…
ShriM
  • 21
  • 4
1
vote
2 answers

convert column data to xml format; query fails because all columns types are currently not supported

I am trying to convert column data to xml format, but I get this error message: The query fails because all columns types are currently not supported. CREATE TABLE EMP(NAME VARCHAR2(10 BYTE)) INSERT INTO EMP VALUES ('C'); INSERT INTO EMP VALUES…
sam
  • 385
  • 3
  • 10
  • 28
0
votes
1 answer

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[1688627335831] INFO (ext): SQLTools is…
Jatin Rathour
  • 1
0
votes
0 answers

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 from the C program and not from the extension's .sql…
Davide Mazzarotto
  • 1
  • 2
0
votes
0 answers

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'. This service may not be available in the us-east-1'…
adbdkb
  • 1,897
  • 6
  • 37
  • 66
0
votes
0 answers

Using VSC and SQLTools to connect to an older MySQL database ( insecureAuth:true)

At the place I work we make some use of databases, IT administrates them, we have a few older databases on the network, I have been able to connect to all the databases via HeidiSQL and using ODBC, but I want to use VSC to design queries when I…
onering20
  • 1
  • 2
0
votes
1 answer

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 => sqltools.getConnections [1674681282367] INFO (ls):…
Hauscrafter1978
  • 1
  • 1
0
votes
1 answer

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 s. I want to create a trigger which would fire…
H22
  • 1
  • 1
0
votes
0 answers

executing create plpgsql function in vscode runs properly only if selecting the all function definition lines

I'm using vscode version 1.74.2 with SQLTools extension v0.26.0 in order to work with a postgresql 15 database. when i'm writing a plpgsql function, the editor marks in color the function besides the last line of END $$ LANGUAGE plpgsql. SQLTools…
ufk
  • 30,912
  • 70
  • 235
  • 386
0
votes
0 answers

how to export and load mysql database in vscode sqltools extension

I'm using Apache2.4 as my server, php8.1, and sqltools extension in vscode. I wonder how can I export and import/load mysql database from and to another device and set it up on sqltools, so that I can connect it to my php code Should I also…
Vincent Theodore
  • 1
  • 2
0
votes
5 answers

SQL Server change management

Does anybody know of a good change management tool for SQL Server? We would like to use it to migrate our existing clients database to newer version via an api.
Johan J v Rensburg
  • 302
  • 2
  • 10
1
2
3 4