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.
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.
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.
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.
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.
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.
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?
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
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.
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.
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 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?
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.
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.
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
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!
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.
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? :
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?
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, 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.
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
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
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.
Hello Thanks for this amazing video. I am complete beginner I lost my $sa_password so I am not able to connect to sql server. How can I change it or retrieve it? Thanks for your help and all the content you are providing
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?
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???
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, 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
Hey, thank you for the video, it helps a lot. but i have recived "Login failed for user 'sa'", any reason for that? (P.S: i entered the corrected password)
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.
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.
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.
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.
Bro great explanation but can you please try to lessen the ptchh and tss sounds when you speak, they are so irritating to my ears, if I sound bad m sorry but its me genuinely asking you.
@@DatabaseStar Thanks for taking this in a positive way. Love your work, I would understand you not being able to fix it, I only asked cause I liked your explanations and would like to hear this here than search for a new channel, I do understand its specific to me and not many native speakers would feel so.
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.
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.
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.
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.
Want to easily remember the SQL commands for your database? Get my free SQL Cheat Sheets here: www.databasestar.com/get-sql-cheat-sheets/?
This video is insanelly underrated... Amazing...🙏
I'm glad you think so!
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
ı 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
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 😂😂
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.
Has anyone told you that you have a nice teaching voice, because you do
Thanks!
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.
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!
Helped me run specific queries, thanks!
Glad it helped!
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.
Very helpful and easy to understand, thank you so much.
Glad it was helpful!
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.
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)?
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
ruclips.net/video/wzdCpJY6Y4c/видео.html
If it does not work, you may have to use other sql extensons.
I use Jun Han's extension instead.
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.
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?
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
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.
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.
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.
Great video, thanks for creating it!
Glad you liked it!
@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.
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.
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
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!
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.
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
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
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
You sir, are the Jesus of Database.
Thanks a lot!
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!
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.
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.
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.
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
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
really like your video, waiting for the Oracle SQL video
Glad you like it! The Oracle one is coming soon.
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?
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?
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.
heyyyy, thanks for such a great video.
You’re welcome!
Thank you for this.
No worries!
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.
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!
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
best video!!! thanks a lot
You're welcome!
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
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
Amazing tuto!
Thanks!
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.
Thanks that was easy.
Glad you found it easy!
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.
Hello Thanks for this amazing video. I am complete beginner I lost my $sa_password so I am not able to connect to sql server. How can I change it or retrieve it?
Thanks for your help and all the content you are providing
Thanks! I’m not sure how to change it unfortunately. But there is probably some helpful Stack Overflow posts about it.
Jsut to let you know that Oracle is now supported
Oh that’s good to know!
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
Nice tutorial! 🥰
Thanks!
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?
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???
SQLServer connection is not working on me. With SSMS yes, not with vsc
What issue are you having with it?
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.
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.
This is a great tutorial, but can't get it to work with MSSQL using MFA. There's no option for it :(
Oh that’s strange. I’m not sure how to fix that so I hope there’s something on Google
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
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?
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.
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
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.
Hey, thank you for the video, it helps a lot. but i have recived "Login failed for user 'sa'", any reason for that? (P.S: i entered the corrected password)
Hmm it could be the database is not running. Are you able to connect using another tool such as SSMS? It could also be the server name is incorrect
@@DatabaseStar yes, I can connect to the database with SSMS, I am not sure what is going on…
Even though installed step by step I didn't get any connection assistant
Oh that’s strange, I thought it would come up correctly
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.
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.
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.
Request connection/GetChildrenForTreeItemRequest failed with message: Unknown database 'myshop' i got this error please help me😭😭😭
Does the database "myshop" exist on your database server?
What about PostgreSQL databases that use SSH?
Is there an option to specify that when connecting?
"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,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
is their a way to import an excel file using vscode?
I'm not sure - I'll have to take a look!
hi,i get this error when creating mysql Client option 'pooling.maxIdleTime' does not support value 'NaN'.
CAN YOU HELP ME @! THANKS A LOT
I think there are some other commenters that had the same issue. You could try entering a value into that field on the connection tab.
Bro great explanation but can you please try to lessen the ptchh and tss sounds when you speak, they are so irritating to my ears, if I sound bad m sorry but its me genuinely asking you.
Thanks for the feedback! I'll work on that for my future videos.
@@DatabaseStar Thanks for taking this in a positive way. Love your work, I would understand you not being able to fix it, I only asked cause I liked your explanations and would like to hear this here than search for a new channel, I do understand its specific to me and not many native speakers would feel so.
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.
🙏 Thank you for your a great work .
You're welcome!
The error i keep getting is just "The server has gone away" and not matter what i set the time out value to, it errors straight away
That's strange. I haven't seen that before. It might be something that Google/StackOverflow could help with (unless you've already tried that)
I encountered the same problem too...pls help
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.
Thank you!
You're welcome!
10:03 I dont have this button for running it :( Anyone knows the problem ?
h that's odd. Are you connected to the database?
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.
awesome tools but not sure how to use this with ssh.
Good point, I'm not sure how to use it either. Do you mean ssh within VS Code, or separately?
@@DatabaseStar yes ssh within vscode to access mysql.
like new_app....how do i set my database
It depends on your vendor, but you could use the USE command.
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
Thank you sir
You're welcome!
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.
I can't thank you enough 🥰🥰.
Glad you liked it!
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.