Stack Overflow
Stack Overflow

Questions tagged [sqltools]

51 questions
0
votes
2 answers

PUT command Snowflake on VSCode

I use the snowflake driver for SQLTools on vscode and i'm connect to my snowflake account but i'm some issues when i want to put some files with extensions .csv from my local machine to my stage in snowflake. Indeed, when i use the command put…
Max Mamazita
  • 81
  • 8
0
votes
1 answer

How to delete connections from SQLTools on VSC?

I made a connection in SQLTools once, but something gave an error so I deleted it. Now, when I made a connection, it doesn't show up or something like that and I don't know why. I thought maybe I could fix it by deleting my connections, but I don't…
polelord
  • 45
  • 6
0
votes
0 answers

Visual Studio Code - Redshift Driver

My driver on Visual Studio Code don't working. My problem is SQLTOOLS - I deleted this extension and downloaded it again but my problem didn't get fixed. I don't understand, and I try another driver but it's the same problem.
Carla Moreno
  • 9
  • 2
0
votes
2 answers

How can I fix the error "Cannot destructure property 'name' of 'undefined' as it is undefined" using MySQL, VSCode and SQLTools with basic queries?

Some basics... I have MySQL installed using the latest version of WAMP and it works fine. MySQL v5.7.31 I use the latest version of VSCode, v1.56.2 I Installed the SQLTools Extension for VSCode, v0.23.0 by Matheus Teixeira I installed the SQLTools…
Lord Dewi
  • 23
  • 6
0
votes
1 answer

Handshake inactivity timeout - mysql using sqltools

I am using SQL tools however I keep getting this error. I have changed the connection to 5000 but I keep getting this error. I don't know if this is a syntax error, sqltools error, or a MySQL error. here is my code --@block CREATE TABLE Main( id INT…
Travis C
  • 77
  • 1
  • 8
0
votes
0 answers

Sublime Text 3 SQLite Setup

Can someone please help me setting up SQLite Connection in Sublime Text 3? This is all I have changed from original SQLTOOLS Settings are: // Settings in here override those in "SQLTools/SQLTools.sublime-settings" "cli": { "sqlite" :…
sqluser
  • 393
  • 1
  • 4
  • 22
0
votes
1 answer

Unable to get result on multiple databases (SQL-Tools)

I have to get mixed result from the databases but this code is raising an error: from sql_tools import sqlite sqlite.connect(["main.db", "base.sqlite3"]) data = sqlite.execute(["SELECT * FROM PREFERENCES", "SELECT * FROM…
user12920524
0
votes
2 answers

VS Code: "Error opening connection connect ECONNREFUSED 127.0.0.1:3306" when trying to connect to database

I have xampp installed on linux mint and now i want to connect vs code to the sql-database. I have installed the extension SQLTools and created a connection to the database with the correct credentials but then i get an error: Error opening…
user12520790
0
votes
0 answers

Issue with Visual Studios Data Type alteration

I have gathered a data set from sql to use in visual studios, some of which are large numbers and others which are small. I want any value below 100 to show 1 decimal place and anything above to show as an integer without any decimal places. When I…
S.Elgar
  • 25
  • 4
0
votes
0 answers

Litecli doesn't recognize ".read" command when trying to execute an SQL script

I recently started learning about relational databases by taking part in a course about programming. The course mentors suggested we use Litecli: https://litecli.com It's a great tool, but it doesn't seem to recognize the ".read" command when I try…
Kamen Hristov
  • 21
  • 8
0
votes
1 answer

HSQLDB SqlTool is throwing user lacks privilege or object not found

I'm executing .sql scripts using SqlTool. It keep on saying user lacks privilege or object not found. The same script is working perfectly from Swing UI. My Script (hello.sql) \. SET DATABASE SQL SYNTAX ORA TRUE; ALTER CATALOG PUBLIC RENAME TO…
Thiagarajan Ramanathan
  • 1,035
  • 5
  • 24
  • 32
0
votes
1 answer

HSQLDB Stored Procedure ran through SQL Tool is throwing Scanner Error

From Swing UI I am able execute the following Scripts one by one. ALTER CATALOG PUBLIC RENAME TO SOMENAME; CREATE SCHEMA SOMESCHEMA; SET DATABASE SQL SYNTAX ORA TRUE; CREATE PROCEDURE SOMENAME.SOMESCHEMA.SP_FAILED_COUNT(IN i_ssn VARCHAR(100), IN…
Thiagarajan Ramanathan
  • 1,035
  • 5
  • 24
  • 32
0
votes
1 answer

Exploring an MySQL file using HSQLDB sqltool

I have a MySQL file that I would like to explore using sqltool. I do not want to deploy a MySQL database because I only need to run a few queries on the data; I do not need persistence. I understand that sqltool will allow me to create an in-memory…
sdgfsdh
  • 33,689
  • 26
  • 132
  • 245
0
votes
1 answer

Variables for Read-Only Oracle SQL Queries

I am a read only user for a database and I have a task of adding some data into the system and need to verify my progress at every step. Adding and modifying the data is a task done in a portal and is not done directly from my SQL file. I have one…
Metomorphose
  • 434
  • 3
  • 14
0
votes
2 answers

Trouble understanding PL/SQL and where clause with curly braces

So I'm new to SQL. I have to ensure this file works on both Oracle and SQL Server. For this I use SQL Tools (Oracle) and sQL Server Management Studio. I'm begining to learn the different between PL/SQL and TSQL (I think), which is basically just to…
user2903379
  • 375
  • 3
  • 22
1 2
3
4