Hi at your time stamp 4:46, the screen where it says "Use password", mine does not say that. It says "password mode" and gives the options 'SQLTools driver credentials' ,'Ask on connect', 'Use empty password', and 'Save as plaintext in settings'. When I attempted to try each of these it gave me an error once I clicked save connection. I tried uninstalling and reinstalling all of my extensions and even tried downloading different versions of vsc but it still shows this. Any idea how to fix this??
Oh that's strange, perhaps the authors have updated the extension. Is your password correct? If it is, I would suggest contacting the author or developer of the extensions.
In 4:23, when I tried the connection I have an error that says: Client option 'pooling.maxIdleTime' does not support value 'NaN'. can someone help me with this.
Hey man, your videos are super helpful. I just wanna ask, what do I do at 5:55 when I try to Test Connection it tells me ("Client option 'pooling.maxIdleTime' does not support value 'NaN'. ") When I put a value of 30 like you said, it says ("The server has gone away") Yours came so quickly so I'm stumped
Thanks! I’m not sure why you’re getting that error about the server going away. The NaN issue is mentioned in a few other comments and I think adding that value like you have would resolve it. Unsure about the other error thought.
im trying to learn sql on my own through youtube. at 5:20 where you link the database you put new_app what does this mean and what do i need to do to create my own. thank you for the great video
Good question! The "new_app" is the name of an existing "database" that has been created on a MySQL server. If you have already installed MySQL on your computer, you probably won't have any databases yet. So, you'll have to open another tool such as MySQL Workbench and create a new database. This is what I did - I created a new database called "new_app" in MySQL Workbench, and then specified it here. This needed to be done in another application (not VS Code) because this Database field is mandatory - unfortunately we can't just connect here and then create a database after we connect.
Hi, thanks for the great easy-to-follow-content! I only have one minor problem that bothers me, around 10:20 whenever I run any query, I don't see the green box even when it's successful, it does show errors, however a feedback on successful queries is essential for me. Any idea how to fix this? Thanks in advance
That's interesting. Is the query successful? I'm not sure why the box would not be appearing. Perhaps there's a setting that shows or hides this panel. Or perhaps it's a known issue in a certain version of the extension.
6:54 I'm trying this on mac os and I'm stumped by what to put in the Database. SSMS isn't available for Mac so how do I create a database on my local machine for visual studio to access?
Ah good question. If you want to run SQL Server on your Mac, you could use a tool called Docker. That’s what I use and I have a video about it on my channel. If you don’t necessarily need to use SQL Server, you could install either MySQL or Postgres, both of which work directly on Mac.
@@DatabaseStar Thanks for the response. I'll look into setting up docker. As for mysql and postgresql, I'm not sure about them. I'm not too educated about sql actually. But I've joined a course to learn it and I wanted to set it up on my MacBook beforehand. The instructor is just going to use SSMS so I doubt he will be able to help me
Hey, I love everything you showed me and although i had like 30 different errors i was able to work them all out except for one, where you talk about things at 11:15 , it keeps saying that it cannot find the table that I had just created, do I have to refresh it or what? I went into mysql and typed in the exact same things and it worked and went back into sqltools and was editting stuff there, but is there a delay or a refresh that has to happen? Thank you
Thanks! I'm not sure, perhaps there is a refresh that needs to happen. The object explorer that shows the tables may need to be refreshed, but if you write a query that refers to the table it should work. Did you happen to use square brackets or single quotes around your table name?
@@DatabaseStar hey, I figured it out, I needed to route my usenode thing in settings to my node application on my computer and it auto updates now!! Thanks for everything
Yes, you'll need to have access to a database, such as MySQL. You can download and install MySQL on your computer. There is no internal database included with the plugin.
Hey, I successfully added the database but when i try to connect i got the next error message: Request connection/GetChildrenForTreeItemRequest failed with message: Handshake inactivity timeout What should i do?
Hmm I’ve never heard of that message. Could you check the GitHub repo of this plugin to see if others have the same issue? Or some Googling if you have t some so already.
i also had an error in 6:00 when i did test connection. it says, "client option 'prooling.maxIdleTime' does not support value 'NaN'." what does it mean? :
Whenever I'm in the SQLTools Settings and I click on "Test Connection" I get a red error message saying "The server has gone away" I read that I can change the timeout time in the PHP document for SQL but I'm unsure of doing this, anyone knows another solution?
There's a setting on the connection screen about the timeout which you can increase to a higher number, and this may solve the issue. If not, then it may be a MySQL issue.
Hey mate - thanks for the video, very helpful! When you say you've just created a new database using MySQL workbench - any chance you could give some more detail on that please? Thanks again!
No prolem! Sure, I mean that I used MySQL Workbench to create a database. I opened MySQL Workbench and connected to MySQL running on my computer. I then created a new database which is an area that can hold database objects such as tables.
It should be the same password you use when connecting with other editors such as SSMS. The password depends on your database setup - e.g. the one you set when you installed SQL Server Express, or for a different user.
At this point, I'm entering the password to use for the root account to log in to MySQL. This is the same user and password you would use if you're accessing the database using MySQL Workbench or some other editor.
how to allow each connection to show all db that the role is allowed to connect? For example, suppose I have a role named developer and allow to connect to these databases. postgres, myAppdb, myDB3, etc. how to show all these database after connecting to the connection? Pgadmin4 will show all the DBs that developer can connect to.
Hi Ben, as always, thank you for your teaching! On a different topic, can I run Postgresql on Visual Studio (not Visual Studio Code)? Would you please send some instruction? Thank you!!!
Thanks Tim! I'm not sure how, but I am guessing you can. There may be an extension for Visual Studio, just like the one in VS Code, that can be used to access a database. I'll create a video on this in the future.
Hi, i faced to some problem when i add a new connection. I fill in same information and click "TEST CONNECTION" button. it shows error "Client option 'pooling.maxIdleTime' does not support value 'NaN'." Do I create a database before i add new connection?
I have a question. When I did this, I already made schemas and databases in the past. When I access them (such as Select/Desc), it returns with "No Data" even when the databases already have data. Is there a fix for this? Or do I have to create all databases from the start again?
That's interesting. Do you see them if you access them using another editor such as SQL Developer? Do you see the tables in the object browser on the left panel?
Great Video!!! but i have an issue/error... it say "Request connection/GetChildrenForTreeItemRequest failed with message: Client option 'pooling.maxIdleTime' does not support value 'NaN'." Can you help me?
Hey, you can import CSV files into your database as a table. I don't know if you can do this in the VS Code extension, but you can do it in most SQL Editors.
Well, my issue is I'm using a CA Certificate to authenticate to my Azure MySQL server, and this extensions appears to not have an option to select the path to it.
Hi Ben, thanks for the video, but i am getting a this error: 'Error opening connection Unknown database 'mysql_database'' . Not sure how to go about it
Hmm I would suggest checking your username and password, or trying to connect using a different IDE to see if it's a problem with VSCode. Otherwise a Google search may give a solution.
Yeah, some do. Some would limit it to only one specific tool such as SSMS, but others have a more relaxed policy or a recommendation, especially if the extension an be assessed by the company’s security team. Good point about trusting extensions though!
In the video you mentioned you'd be creating a video on how to use the orcale database VS Code extension, I have seen some videos where you use it with docker (I don't know what docker is), but have you created a similair style video to this were in the beginning you just run through how to connect properly, without brining any other technologies like docker.
Hey, that’s a good suggestion. I don’t have a video on using vs code with oracle on a regular database like Oracle Express. But I can create a video like that. The only difference would be the connection details.
No matter what driver i try, it gives me "error" when testing the connection. All default parameters, basically all that is changed are the names and the password. What am I supposed to do, considering that everyone has no issues by the looks of it.
Which database vendor are you using (Oracle, SQL Server, MySQL, Postgres, or something else)? Are you able to use the same connection details in another editor?
@@DatabaseStar managed to get it working, had to reinstall postgres... edit: now my next question is how to stop the ''making a new tab for each SQL query'' part edit2: nvm figured that one as well.. have a nice day
Yes, it has enough of the basic functionality to let you write queries and see results. For more advanced stuff, you may want to use another IDE such as SSMS.
Hi Thanks for the video. When I try to test connection I keep getting this error "connect ECONNREFUSED ::1:3306" I don't know how to move past this. any help on how to fix this?
I believe they are different. Port number is like the gate that is used to communicate between two things. A process ID is a unique number for a process that runs on the computer.
Hi Mohamed, I'm not sure what this error means. I would suggest Googling it, if you haven't done so already. Or, set a value for Max Idle Time when you create the conneciton.
Hey, I think there are some other comments with the same question. I think you can enter a value in one of the fields on the connection and it should work.
Hi, I have a problem in here. When I tried to create SQL server connect, I couldn't connect with "Login failed to user "testdb". Can someone help me fix this out? Tks
Hi~I have a problem for my sql server 2008 using vscode to connect database ,I have no idea which one extension that I can use?any one can help ? Thank you guys assistance.
@@DatabaseStar Thanks for you answer,but I'd tried to use SQL Server given connect String as like "Data Source=,;Initial Catalog=;User ID=;Password=", step by step...then I just could see the database cluster shown ,when I use sql code "select * top 1000 from ....", it appeared : This is likely caused by the extension that contributes mssql.scriptSelect.... So I thought that Sql2008 is the reason why ?and what's you opinion?
Is the password correct? Are you trying to connect to an Oracle database (I think SYS is part of Oracle)? If it's Oracle then you'll need to use a different extension. I've got another video on how to use Oracle with VSCode on my channel.
sir mySQL is not showing me that exact icone which is appearing in your window on connection time, kindly help to access those icons so i can be able to connect it with VS code. I really have no time for wait, I've only one day, bcz my project's viva is almost on my head
@@DatabaseStar Sir my VS code is showing the error "Found that duplicate Database Client extensions are installed, please uninstall the duplicate!" Kindly guide me that how can I know that which is this duplicate extension???
how to create database in visual studio code to run sql how many times i try still get error in localhost server name i think make a video on how to create database and how to use it in vs code
I have a video coming out soon on exactly how to do that (for MySQL databases, as that's where it's a required field). You can use the Terminal or Command Prompt to create a database if you don't already have one.
I’m not sure. I did a quick search and it seems to be a timeout issue or something like that. Perhaps restarting your computer or VS code could fix it.
You can use an IDE to import the CSV into your database, and the process is different for each IDE. In Visual Studio Code, I'm not sure how it's done. I'm not sure if the extension has this feature.
You truly did a good job, but when following your steps, I stuck in this error: Failed to connect to localhost:1433 - Could not connect (sequence). Tell me how can I solve it
Depending on which database vendor you are using, you should be able to connect to the database using the command line or a different SQL editor and create a database. The username will also depend on which vendor you're using.
I think you'll need some kind of server-side programming language involved to connect HTML and JS to a database. You could use something like Node.js, or PHP, or .NET, or something else.
It’s whatever username and password is set up on your database already. This depends on what database you’re using, eg it could be root for MySQL or sa for SQL Server or something else.
Want to easily remember the SQL commands for your database? Get my free SQL Cheat Sheets here: www.databasestar.com/get-sql-cheat-sheets/?
Hi at your time stamp 4:46, the screen where it says "Use password", mine does not say that. It says "password mode" and gives the options 'SQLTools driver credentials' ,'Ask on connect', 'Use empty password', and 'Save as plaintext in settings'. When I attempted to try each of these it gave me an error once I clicked save connection. I tried uninstalling and reinstalling all of my extensions and even tried downloading different versions of vsc but it still shows this. Any idea how to fix this??
Oh that's strange, perhaps the authors have updated the extension. Is your password correct? If it is, I would suggest contacting the author or developer of the extensions.
same
This video is insanelly underrated... Amazing...🙏
I'm glad you think so!
In 4:23, when I tried the connection I have an error that says: Client option 'pooling.maxIdleTime' does not support value 'NaN'.
can someone help me with this.
I think you'll need to enter a value somewhere on the connection screen. There are some other comments on this error I believe.
@@DatabaseStar
Can you please make a video on this error how to resolve this
Hey man, your videos are super helpful. I just wanna ask, what do I do at 5:55 when I try to Test Connection it tells me ("Client option 'pooling.maxIdleTime' does not support value 'NaN'. ")
When I put a value of 30 like you said, it says ("The server has gone away") Yours came so quickly so I'm stumped
Thanks!
I’m not sure why you’re getting that error about the server going away. The NaN issue is mentioned in a few other comments and I think adding that value like you have would resolve it. Unsure about the other error thought.
@@DatabaseStar That's ok. Thanks for the reply. I'm sure I'll find a way.
@@unruly_ronin hey did you find the way ??
@@harshitkhandelwal9983 did you find a way? I need help too
I got the same error , change authentication protocol to default then it will be successful.
im trying to learn sql on my own through youtube. at 5:20 where you link the database you put new_app what does this mean and what do i need to do to create my own. thank you for the great video
Good question! The "new_app" is the name of an existing "database" that has been created on a MySQL server. If you have already installed MySQL on your computer, you probably won't have any databases yet. So, you'll have to open another tool such as MySQL Workbench and create a new database. This is what I did - I created a new database called "new_app" in MySQL Workbench, and then specified it here.
This needed to be done in another application (not VS Code) because this Database field is mandatory - unfortunately we can't just connect here and then create a database after we connect.
Hi, thanks for the great easy-to-follow-content! I only have one minor problem that bothers me, around 10:20 whenever I run any query, I don't see the green box even when it's successful, it does show errors, however a feedback on successful queries is essential for me. Any idea how to fix this? Thanks in advance
That's interesting. Is the query successful? I'm not sure why the box would not be appearing. Perhaps there's a setting that shows or hides this panel. Or perhaps it's a known issue in a certain version of the extension.
@@DatabaseStar The query is successful. I checked the settings and wasn't able to find it anywhere.
If you have been banging your head against your desk trying to get MySQL to work then you've found the correct video and the answer is at 4:50
Thanks!
Bro I'm gonna kiss you on the lips. You just saved me hours of work
Hahah thanks!
Ayo
Tf u gay
No no no this should only be done to your wife! NO EVEN YOUR MATURED DAUGHTER
Ayoooo 😂😂
ı thing you are god :D , I was constantly getting errors, no one explains it as well as you 👍
Thanks a lot! I’m glad you liked the video
6:54 I'm trying this on mac os and I'm stumped by what to put in the Database. SSMS isn't available for Mac so how do I create a database on my local machine for visual studio to access?
Ah good question. If you want to run SQL Server on your Mac, you could use a tool called Docker. That’s what I use and I have a video about it on my channel.
If you don’t necessarily need to use SQL Server, you could install either MySQL or Postgres, both of which work directly on Mac.
@@DatabaseStar Thanks for the response. I'll look into setting up docker. As for mysql and postgresql, I'm not sure about them. I'm not too educated about sql actually. But I've joined a course to learn it and I wanted to set it up on my MacBook beforehand. The instructor is just going to use SSMS so I doubt he will be able to help me
Hey, I love everything you showed me and although i had like 30 different errors i was able to work them all out except for one, where you talk about things at 11:15 , it keeps saying that it cannot find the table that I had just created, do I have to refresh it or what? I went into mysql and typed in the exact same things and it worked and went back into sqltools and was editting stuff there, but is there a delay or a refresh that has to happen? Thank you
Thanks! I'm not sure, perhaps there is a refresh that needs to happen. The object explorer that shows the tables may need to be refreshed, but if you write a query that refers to the table it should work. Did you happen to use square brackets or single quotes around your table name?
@@DatabaseStar hey, I figured it out, I needed to route my usenode thing in settings to my node application on my computer and it auto updates now!! Thanks for everything
it says ECONNREFUSED
using postgreSQL
I'm not sure why that would be the case. Did it work in another SQL editor (such as pgAdmin)?
Do i need to download MySQL before doing all these steps or is it usable with just the plugin? (Like an internal VSC sql server)
Yes, you'll need to have access to a database, such as MySQL. You can download and install MySQL on your computer. There is no internal database included with the plugin.
Hey,
I successfully added the database but when i try to connect i got the next error message:
Request connection/GetChildrenForTreeItemRequest failed with message: Handshake inactivity timeout
What should i do?
Hmm I’ve never heard of that message. Could you check the GitHub repo of this plugin to see if others have the same issue? Or some Googling if you have t some so already.
Me2
Hello Attila, please were you able to fix the problem?
Try this
ua-cam.com/video/wzdCpJY6Y4c/v-deo.html
If it does not work, you may have to use other sql extensons.
I use Jun Han's extension instead.
10:03 I dont have this button for running it :( Anyone knows the problem ?
h that's odd. Are you connected to the database?
i also had an error in 6:00 when i did test connection. it says, "client option 'prooling.maxIdleTime' does not support value 'NaN'." what does it mean? :
It means you need to enter a value into that field, and we can't leave it empty. A few other people had this issue in the comments.
Whenever I'm in the SQLTools Settings and I click on "Test Connection" I get a red error message saying "The server has gone away" I read that I can change the timeout time in the PHP document for SQL but I'm unsure of doing this, anyone knows another solution?
There's a setting on the connection screen about the timeout which you can increase to a higher number, and this may solve the issue. If not, then it may be a MySQL issue.
Good day. How to remove the "highlight" like you have in the video 10:02
I use postgresql and this glow never goes out
I solved this problem, I just had to remove the check mark in the extension settings
Oh good to know. Thanks for sharing your solution.
Hey mate - thanks for the video, very helpful! When you say you've just created a new database using MySQL workbench - any chance you could give some more detail on that please?
Thanks again!
No prolem! Sure, I mean that I used MySQL Workbench to create a database. I opened MySQL Workbench and connected to MySQL running on my computer. I then created a new database which is an area that can hold database objects such as tables.
Has anyone told you that you have a nice teaching voice, because you do
Thanks!
@Database Star i installed all there extensions from market place but in add new connection second one that is SQL Tool Post GRE is not visible.
Oh that's strange, perhaps there's an issue with the extension with Postgres not appearing.
6:52 I use mssql and I log in with windows authentication. How do I find the password for connecting it on vs code?
It should be the same password you use when connecting with other editors such as SSMS. The password depends on your database setup - e.g. the one you set when you installed SQL Server Express, or for a different user.
It was good but i just stop on 5:34 min😢😢😢 i don't understand what you said.
At this point, I'm entering the password to use for the root account to log in to MySQL. This is the same user and password you would use if you're accessing the database using MySQL Workbench or some other editor.
@@DatabaseStar Thank you for your response.
Have i understood that correctly, do i need to install the MySQL server on my laptop first, in order to create a MySQL Connection in VS Code Studio?
Yes that’s right!
At 5:56 I got an error "pooling.maxIdleTime" doesn't support nan
I think this was found and addressed by other comments and I think the solution is to put a number into that field.
how to allow each connection to show all db that the role is allowed to connect? For example, suppose I have a role named developer and allow to connect to these databases. postgres, myAppdb, myDB3, etc. how to show all these database after connecting to the connection? Pgadmin4 will show all the DBs that developer can connect to.
Good question. I'm not sure how to do that in this extension unfortunately.
Helped me run specific queries, thanks!
Glad it helped!
Hi Ben, as always, thank you for your teaching! On a different topic, can I run Postgresql on Visual Studio (not Visual Studio Code)? Would you please send some instruction? Thank you!!!
Thanks Tim! I'm not sure how, but I am guessing you can. There may be an extension for Visual Studio, just like the one in VS Code, that can be used to access a database. I'll create a video on this in the future.
I got 'failed to connect to localhost:1433 - could not connect (sequence)' . What should I do?
Hmm I’m not sure. Is the database running? What does Google say?
Have you resolved the problem? I am facing the same problem
Hey, I have installed the extension sqltools but I cant see it in the side bar. what might be wrong?
Maybe there is a setting in VS Code that needs to be adjusted? Or maybe you need to restart VS Code?
Hi, i faced to some problem when i add a new connection.
I fill in same information and click "TEST CONNECTION" button.
it shows error "Client option 'pooling.maxIdleTime' does not support value 'NaN'."
Do I create a database before i add new connection?
For this error I think you need to enter a value into the max idle time field rather than leave it empty.
And yes I think you need a database first.
Great video, thanks for creating it!
Glad you liked it!
I have a question. When I did this, I already made schemas and databases in the past. When I access them (such as Select/Desc), it returns with "No Data" even when the databases already have data. Is there a fix for this?
Or do I have to create all databases from the start again?
That's interesting. Do you see them if you access them using another editor such as SQL Developer? Do you see the tables in the object browser on the left panel?
Great Video!!!
but i have an issue/error... it say "Request connection/GetChildrenForTreeItemRequest failed with message: Client option 'pooling.maxIdleTime' does not support value 'NaN'."
Can you help me?
Thanks! I think others have left comments with this error. If that doesn't work then perhaps Google can help.
Hey, I had this same error
Can you please tell me how you fix this
I keep getting this error message when setting up a new connection: sqltools error error : connect econnrefused :: 1:33060
Hmm is the database running? I assume this is MySQL as it uses port 3306.
Please can you tell me how i can connect to multiple databases in the same time using sql server driver
Thanks in advance.
I think you can set up multiple connections in the connections panel?
@@DatabaseStar would you please tell me how?
Hi, I’m working on the Coursera Capstone project and I’m trying to figure out how to utilize .csv files. Is that possible?
Hey, you can import CSV files into your database as a table. I don't know if you can do this in the VS Code extension, but you can do it in most SQL Editors.
Well, my issue is I'm using a CA Certificate to authenticate to my Azure MySQL server, and this extensions appears to not have an option to select the path to it.
Oh that's a shame it's not available
Solid video, though how would you connect this and python together?
I imagine you would set up Python as normal, and then access it from within VS Code?
Hi Ben, thanks for the video, but i am getting a this error: 'Error opening connection Unknown database 'mysql_database'' . Not sure how to go about it
Hmm. Do you have a database with that name on your server? You can check which database are available in another IDE such as MySQL Workbench
Failed to connect localhost:1433 -could not connect (sequence)
same here!
Hmm I would suggest checking your username and password, or trying to connect using a different IDE to see if it's a problem with VSCode. Otherwise a Google search may give a solution.
@@DatabaseStar I got the same error and cant fix it. Any suggestion?
Companies actually allow people to connect to databases using random extensions from the internet?
Yeah, some do. Some would limit it to only one specific tool such as SSMS, but others have a more relaxed policy or a recommendation, especially if the extension an be assessed by the company’s security team.
Good point about trusting extensions though!
In the video you mentioned you'd be creating a video on how to use the orcale database VS Code extension, I have seen some videos where you use it with docker (I don't know what docker is), but have you created a similair style video to this were in the beginning you just run through how to connect properly, without brining any other technologies like docker.
Hey, that’s a good suggestion. I don’t have a video on using vs code with oracle on a regular database like Oracle Express. But I can create a video like that. The only difference would be the connection details.
5:57 Mine doesn't connect, shows error 😢
Oh what error are you getting?
@@DatabaseStar It shows Client option 'pooling.maxldleTime' does not support value 'NaN'.
No matter what driver i try, it gives me "error" when testing the connection. All default parameters, basically all that is changed are the names and the password. What am I supposed to do, considering that everyone has no issues by the looks of it.
Which database vendor are you using (Oracle, SQL Server, MySQL, Postgres, or something else)? Are you able to use the same connection details in another editor?
@@DatabaseStar managed to get it working, had to reinstall postgres...
edit: now my next question is how to stop the ''making a new tab for each SQL query'' part
edit2: nvm figured that one as well.. have a nice day
Will the work also for mac computers?
Yes, it should. I use VS Code all the time on a Mac.
What to enter in Database name in VsCode? I have installed mysql server on my Mac.
You can probably entere localhost
@@DatabaseStar same issue
Hi, what if I want to import the csv file directly into vscode instead of going through pgAdmin4, is that possible?
Good question, I'm not sure if VS Code allows you to do this!
@@DatabaseStar yeah you right, we have to import first on pgAdmin, thanks for answer my question sir. God bless you
Does MS SQL Extension enough to use SQL with Visual Studio Code? Thanks
Yes, it has enough of the basic functionality to let you write queries and see results. For more advanced stuff, you may want to use another IDE such as SSMS.
Hi Thanks for the video. When I try to test connection I keep getting this error "connect ECONNREFUSED ::1:3306" I don't know how to move past this. any help on how to fix this?
I’m not sure how to solve that one unfortunately
I installed my sql but couldn't get sakila and sys database in my work bench
The sys database should be already there by default. Sakila is a database I believe you have to download and install separately.
Very helpful and easy to understand, thank you so much.
Glad it was helpful!
Are Port Number and Process ID the same thing?
I believe they are different. Port number is like the gate that is used to communicate between two things. A process ID is a unique number for a process that runs on the computer.
Error opening connection Client option 'pooling.maxIdleTime' does not support value 'NaN'. why this error?
I think you may need to put a value in one of the fields on the screen. I think other commenters had the same issue.
I love the video. Is there by any chance a way i can connect to IBM informix???
Thanks! I’m not sure as I don’t have any experience with IBM Informix.
In SSMS I enter LAPTOP-QFUJTI9Q\SQLEXPRESS for the Server name. In SQL Tools where do I enter the server name?
I'm not sure. Could you try connect without it? Perhaps it's in the server name field.
SQLServer connection is not working on me. With SSMS yes, not with vsc
What issue are you having with it?
i have sql plus in my pc , so how do it in VS code
You can use this video to connect to your database using VS Code. SQL Plus is a command-line tool for Oracle.
hi,installing databases in visual studio codes met this problem, how can you help me please...
this error: Request connection/GetChildrenForTreeItemRequest failed with message: Client option 'pooling.maxIdleTime' does not support value 'NaN'.
Hi Mohamed, I'm not sure what this error means. I would suggest Googling it, if you haven't done so already. Or, set a value for Max Idle Time when you create the conneciton.
@@mohamednabe7203 Hi, I got the same error, did you manage to solve this problem?
@@mohamednabe7203 I got the same error too
Hi, thanks for this video but I got "read ECONNRESET" error could you help me out on this problem....
Hmm I’m not sure what that error means unfortunately
On testing the connection, I get this error-
Client option 'pooling.maxIdleTime' does not support value 'NaN'.
help
Hey, I think there are some other comments with the same question. I think you can enter a value in one of the fields on the connection and it should work.
add a connection Timeout = 15
is their a way to import an excel file using vscode?
I'm not sure - I'll have to take a look!
Hi, I have a problem in here. When I tried to create SQL server connect, I couldn't connect with "Login failed to user "testdb". Can someone help me fix this out? Tks
Is there a user called test db? Or is that the database name?
@@DatabaseStar no, thats just database name. Btw, I figure out to fix this.
@@DatabaseStar I just have subcribed your channel, very useful and great. Thank you
What about PostgreSQL databases that use SSH?
Is there an option to specify that when connecting?
Hi~I have a problem for my sql server 2008 using vscode to connect database ,I have no idea which one extension that I can use?any one can help ? Thank you guys assistance.
Hi, you should be able to use this extension mentioned in the video to connect to SQL Server.
@@DatabaseStar Thanks for you answer,but I'd tried to use SQL Server given connect String as like
"Data Source=,;Initial Catalog=;User ID=;Password=",
step by step...then I just could see the database cluster shown
,when I use sql code "select * top 1000 from ....",
it appeared :
This is likely caused by the extension that contributes mssql.scriptSelect....
So I thought that Sql2008 is the reason why ?and what's you opinion?
I'm having a problem adding a new contact, can you help me please?
Sure, what do you mean by a new contact?
Error opening connection Login failed for user 'sys' .......how to resolve this?
Is the password correct? Are you trying to connect to an Oracle database (I think SYS is part of Oracle)? If it's Oracle then you'll need to use a different extension. I've got another video on how to use Oracle with VSCode on my channel.
Hi boss, thanks very much for this wonderful tutorial, my question is, can I run this offline without internet connection??
Glad you like it! Yes, assuming you have a database installed on your own computer. You can connect to that and it should work.
My problem is that I don't see any of the buttons up top like "run on active connections". Can anyone help please?
Oh that’s strange. Have you connected to a database? If so which database vendor is it?
sir mySQL is not showing me that exact icone which is appearing in your window on connection time, kindly help to access those icons so i can be able to connect it with VS code.
I really have no time for wait, I've only one day, bcz my project's viva is almost on my head
Which icon are you missing? Is it the cylinder icon on the left panel? Or something else?
@@DatabaseStar Sir my VS code is showing the error "Found that duplicate Database Client extensions are installed, please uninstall the duplicate!"
Kindly guide me that how can I know that which is this duplicate extension???
how to create database in visual studio code to run sql
how many times i try still get error in localhost server name
i think make a video on how to create database and how to use it in vs code
I have a video coming out soon on exactly how to do that (for MySQL databases, as that's where it's a required field).
You can use the Terminal or Command Prompt to create a database if you don't already have one.
Not sure why but i got an ECONNREFUSED error when i tried running the MySQL connection
That’s strange. I’m not sure why either. Hopefully something on Google can help.
How do I solve the 'the server has gone away' error
I’m not sure. I did a quick search and it seems to be a timeout issue or something like that. Perhaps restarting your computer or VS code could fix it.
really like your video, waiting for the Oracle SQL video
Glad you like it! The Oracle one is coming soon.
Amazing tuto!
Thanks!
Nice tutorial! 🥰
Thanks!
Even though installed step by step I didn't get any connection assistant
Oh that’s strange, I thought it would come up correctly
Thank you soo much. This was so useful
Glad it was helpful!
best video!!! thanks a lot
You're welcome!
what if it doesnt connect?
You can try in another editor or resolve the connection issue, which depends on your database vendor and the error message.
Thank you for this.
No worries!
like new_app....how do i set my database
It depends on your vendor, but you could use the USE command.
how to dump data from csv to compact edition data base file.
You can use an IDE to import the CSV into your database, and the process is different for each IDE. In Visual Studio Code, I'm not sure how it's done. I'm not sure if the extension has this feature.
I keep getting this error "Failed to connect to localhost:1433 - Could not connect (sequence)" Plz Help !!
Oh I’m not sure how to solve that unfortunately. Other commenters may have had the same issue though.
heyyyy, thanks for such a great video.
You’re welcome!
self signed certificate in certificate chain how to fix this
What is the issue you're having?
sir am unable to install sql in vscoder please guide us
What issue are you having installing VS Code?
You truly did a good job, but when following your steps, I stuck in this error: Failed to connect to localhost:1433 - Could not connect (sequence). Tell me how can I solve it
Thanks! I'm not sure how to solve that one, perhaps you'll have to Google it.
you are my hero!
Thanks, glad it’s helpful!
hii, how to create a database? and username?
Depending on which database vendor you are using, you should be able to connect to the database using the command line or a different SQL editor and create a database.
The username will also depend on which vendor you're using.
"Add new connection" opens up a blank window for me. Trying it out on a linux vm.
Oh that’s not good. I would suggest contacting the plugin team for this. Not sure why it would show a blank screen.
Hi, Please i have been looking for a video tutorial of how I can link my HTML, CSS and JS to SQL file for web app
I think you'll need some kind of server-side programming language involved to connect HTML and JS to a database. You could use something like Node.js, or PHP, or .NET, or something else.
Thanks that was easy.
Glad you found it easy!
What username and password should I be using?
It’s whatever username and password is set up on your database already. This depends on what database you’re using, eg it could be root for MySQL or sa for SQL Server or something else.
My test connection is not matching 😢
What do you mean it is not matching?
I got a query error message on the right side
Ah what error message did you get?
You sir, are the Jesus of Database.
Thanks a lot!
how to know username ? i am writing root and it is not accepting .
Root should be the default admin username for MySQL. Which database are you using?
@@DatabaseStar using MYSQL
Wow thank you so much for this video! this works on windows with WSL2? I need something like that :(
Thanks, I'm glad you liked it. I don't know a lot about WSL2 so I don't know why it won't work.
@@DatabaseStar it works! Thanks so much