sir i have a mac intel processor and i tried with verison 17 pyodbc , it shows this error, could you tell me what could be the reason? pyodbc.InterfaceError: ('28000', "[28000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Login failed for user
This type of error looks like your database credentials are wrong. Check your database username and password. Are you using cisdbss.pcc.edu for the server with IMDB as the database and 275student for both user and password?
You just need to rename your local variable so that it's named something different. It means you have something in your module named target_word_idx and also a local variable named target_word_idx. So you fix that by renaming the local variable.
@@marcgoodman4862 thank you, got it fixed. If you don't mind. Can you please help me with this one also! I'm getting this message on my code; To enable the following instructions: AVX2 AVX512F AVX512_VNNI FMA, in other operations, rebuild TensorFlow with the appropriate compiler flags. how can I fix this?
Yes, it is, and it's about the the 30th video in a series from the third course in a sequence of courses :) So this will have 0 relevance for you. Given that I just put this video up 2 days ago, and it only has 6 views so far, I can't imagine why this showed up on your recommended list. But if you know some python, and you want to go back to the first video in the series and implement your own list manager application, and then you want to give Portland Community College tuition for a 4 credit hour class, I'll be happy to take a look at your program and give you college credit for it if you meet all the requirements :)
You're a LIFESAVER!!! Thank you! I didn't even think what I wanted was possible. I have a docker container which is running SQL Server that I connected to my database in Azure Data Studio. But I couldn't figure out why I couldn't connect my Jupyter notebook(in VS Code) to the database... But when I ran the commands you suggested and added the driver file path and 'encrypted=no', everything worked out! encrypt = 'no', driver = '/opt/homebrew/lib/libmsodbcsql.18.dylib' sudo ln -s /opt/homebrew/opt/openssl@1.1 /opt/homebrew/opt/openssl@3 sudo ln -s /opt/homebrew/opt/openssl@1.1 /opt/homebrew/opt/openssl
A version of this tutorial for those with Community Edition would be fantastic. I assume a lot of PCC students are using the free edition since funds are already tight just being in school! As is, I was not able to follow the tutorial.
The good news is that if you're a student with access to a .edu mail account, you can register for a free 1-year license to all the JetBrains products, and the license is renewable as long as you have the account. But if you're not a student (or teacher), that's not an option. There is no database tab in PyCharm Community, but everything else works. For connecting to MS SQL Server, there's a free product available from Microsoft called SQL Server Management Studio (SSMS) if you're on Windows. If you're on Mac, then probably your best bet is VS Studio Code with the SQL Server plug in, but I personally found that more complicated to get set up correctly.
Hello Marc. Thank you for you video. Can you, please, explain me how those sub selects work? From 7:30. I don't understand how that works in Microsoft Server, I think that not work in other systems. Those sub selects can return multple rows. Thank you!
Thanks for share, in my research seem to be the most complete lesson about IntelliJ and Swing UI! Really helped me to develop the skills that I'm looking for. Cheers!
Sir, I am getting this error: pyodbc.Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'ODBC Driver 18 for SQL Server' : file not found (0) (SQLDriverConnect)") Do you have any suggestions?
Please don't say that. You better share what you did and we can help you to find a solution. This video was REALLY useful. I'm using a MacBook Pro (M3 Pro) and there was a small difference at the end, so I had to execute the following: sudo ln -s /opt/homebrew/opt/openssl@1.1 /opt/homebrew/opt/openssl@3 sudo ln -s /opt/homebrew/opt/openssl@1.1 /opt/homebrew/opt/openssl The error is gone now and I was able to connect to SQL Server on a remote server.
One more problem due to this being outdated content from years ago. On MacOS/Linux, for the import from .jsx file to work, such as shown below. import MentorBlock from "./MentorBlock"; webpack.config.js has to be updated to include a resolve directive. This is because webpack does not know to resolve .jsx files implicitly. module.exports = { entry: './main.jsx', output: { path: __dirname, filename: '.bundle.js', }, module: { rules: [ { test: /\.jsx?$/, exclude: /node_modules/, use: { loader: 'babel-loader', options: { presets: ['@babel/preset-env', '@babel/preset-react'] } } } ] }, resolve: { extensions: ['.js', '.jsx'] } };
For MacOS or Linux based systems, the file that gets generated is not bundle.js, but .bundle.js (notice the dot before "bundle"). So, when you add the script in KYM.html, you have to add ".bundle.js" with the dot at the front.
I feel like you are generating alot of views overall from students who are going to PCC, as they desperately try to decrypt this recycled material for the new homework problems (there feels like a huge disconnect between the content and course). I hope your not getting monetized. Its bad enough that every CIS teacher @PCC uses your videos instead of actually teaching, but if you were profiting on it as well it would truly be disgusting and crooked.
Use pymssql instead. The syntax for executing parameterized statements is a little different, but it's an easy change to learn, and the installation for pymssql is often easier on Mac because it doesn't go through the MS ODBC drivers.
Hi Marc, great tutorial! I was wondering if you think it's best to learn Tkinter by building/designing everything in code first or prior to learning 'Pygubu' designer. Is that how you started out?
I think it's important to understand how tkinter works so that you can debug problems when your interface isn't working as expected, and because the pygubu interface won't mean anything to you unless you know the tkinter interface. However, I don't think building and maintaining a complicated interface directly in tkinter is practical. So, I'd definitely recommend building some simple interfaces in tkinter first, so that you get the hang of it, and can also write one-off code when you want to test something directly in tkinter, but that you transition to a reasonable GUI development tool as quickly as possible. I've worked in several different environments, and they're all pretty much the same as far as the split between the GUI development library (like tkinter, Swing or AWT for Java, or the Windows API) and the WYSIWYG GUI development tool (like the GUI designer in IntelliJ, or the Windows Forms interface in Visual Studio, or a tool like pygubu designer). Once you understand how to do that in one environment, a lot of those skills transfer to other environments you might learn later on, just like understanding how event-driven user interface development works. The first time, it's a challenge to understand how the pieces fit together, but once you get it, it's pretty much the same in most of the environments you'll be working in.
sir i have a mac intel processor and i tried with verison 17 pyodbc , it shows this error, could you tell me what could be the reason? pyodbc.InterfaceError: ('28000', "[28000] [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Login failed for user
This type of error looks like your database credentials are wrong. Check your database username and password. Are you using cisdbss.pcc.edu for the server with IMDB as the database and 275student for both user and password?
@@marcgoodman4862 no sir, it my private database. with credentials,
Hi! Can you please assist with minor error on PEP 8; Shadows name 'target_word_idx' from outer scope. How do I fix this?
You just need to rename your local variable so that it's named something different. It means you have something in your module named target_word_idx and also a local variable named target_word_idx. So you fix that by renaming the local variable.
@@marcgoodman4862 thank you, got it fixed. If you don't mind. Can you please help me with this one also! I'm getting this message on my code; To enable the following instructions: AVX2 AVX512F AVX512_VNNI FMA, in other operations, rebuild TensorFlow with the appropriate compiler flags. how can I fix this?
Is this a University course lecture or something? TH-cam recommended it to me and I am very confused.
Yes, it is, and it's about the the 30th video in a series from the third course in a sequence of courses :) So this will have 0 relevance for you. Given that I just put this video up 2 days ago, and it only has 6 views so far, I can't imagine why this showed up on your recommended list. But if you know some python, and you want to go back to the first video in the series and implement your own list manager application, and then you want to give Portland Community College tuition for a 4 credit hour class, I'll be happy to take a look at your program and give you college credit for it if you meet all the requirements :)
Hi Marc, I don''t find opt folder in /usr/local Any idea why this might be the case. Also in my system it says openssl 1.1.1.w - is that okay?
You're a LIFESAVER!!! Thank you! I didn't even think what I wanted was possible. I have a docker container which is running SQL Server that I connected to my database in Azure Data Studio. But I couldn't figure out why I couldn't connect my Jupyter notebook(in VS Code) to the database... But when I ran the commands you suggested and added the driver file path and 'encrypted=no', everything worked out! encrypt = 'no', driver = '/opt/homebrew/lib/libmsodbcsql.18.dylib' sudo ln -s /opt/homebrew/opt/openssl@1.1 /opt/homebrew/opt/openssl@3 sudo ln -s /opt/homebrew/opt/openssl@1.1 /opt/homebrew/opt/openssl
can you please help me with this? I'm stuck in the same scenario
Amen
Thank You!!
The most annoying keyboard sound.
Really interesting, and I can kind of keep up, but I guess I need more direct experience with OOP in order to really understand this.
very very good🍃🍀
how to change App Icon ?
Me acabas de ayudar de una manera que no tienes idea, buenisimo tu video.
Hola, me pide que actualice version de 275student
if only my professor can explain this easily! Ur such a life saver, thank you!
A version of this tutorial for those with Community Edition would be fantastic. I assume a lot of PCC students are using the free edition since funds are already tight just being in school! As is, I was not able to follow the tutorial.
The good news is that if you're a student with access to a .edu mail account, you can register for a free 1-year license to all the JetBrains products, and the license is renewable as long as you have the account. But if you're not a student (or teacher), that's not an option. There is no database tab in PyCharm Community, but everything else works. For connecting to MS SQL Server, there's a free product available from Microsoft called SQL Server Management Studio (SSMS) if you're on Windows. If you're on Mac, then probably your best bet is VS Studio Code with the SQL Server plug in, but I personally found that more complicated to get set up correctly.
Hello Marc. Thank you for you video. Can you, please, explain me how those sub selects work? From 7:30. I don't understand how that works in Microsoft Server, I think that not work in other systems. Those sub selects can return multple rows. Thank you!
Great content, thank you!
Promo_SM
10 volts at 3 ohms are 10V/3ohms = 3.33Amps You meant 10 volts at 2 ohms = 5 amps. Dispite this minor error, great tutorial.
Thanks for share, in my research seem to be the most complete lesson about IntelliJ and Swing UI! Really helped me to develop the skills that I'm looking for. Cheers!
need help i already install the driver and config in php ini but it still dont have sqlsrv in registered php streams
Did you follow the previous video which had you install the MS ODBC driver, or just the php_pdo_sqlsrv drivers?
@@marcgoodman4862 yes sir i follow all the steps
@@marcgoodman4862 im using php 8.2 driver is 5.11 i already put the extension and follow your video but it still not working
Sir, I am getting this error: pyodbc.Error: ('01000', "[01000] [unixODBC][Driver Manager]Can't open lib 'ODBC Driver 18 for SQL Server' : file not found (0) (SQLDriverConnect)") Do you have any suggestions?
Are you sure you installed version 18 of MSODBC? If you installed a different version, it wouldn't be able to find Driver 18.
@@marcgoodman4862 Sir: Not sure, I will re-install ODBC on Mac and try again. Thank you.
Thank you
Thanks💕
Can we use the configured datsource that you have created inside the python without using the connection string
I guess PysimpleGui is faster and produces less code... But this seems to me promise
Thank you so much man, my brain was broken before this
good thing thank you!
Useless and doesn't work
Please don't say that. You better share what you did and we can help you to find a solution. This video was REALLY useful. I'm using a MacBook Pro (M3 Pro) and there was a small difference at the end, so I had to execute the following: sudo ln -s /opt/homebrew/opt/openssl@1.1 /opt/homebrew/opt/openssl@3 sudo ln -s /opt/homebrew/opt/openssl@1.1 /opt/homebrew/opt/openssl The error is gone now and I was able to connect to SQL Server on a remote server.
This does not work
One more problem due to this being outdated content from years ago. On MacOS/Linux, for the import from .jsx file to work, such as shown below. import MentorBlock from "./MentorBlock"; webpack.config.js has to be updated to include a resolve directive. This is because webpack does not know to resolve .jsx files implicitly. module.exports = { entry: './main.jsx', output: { path: __dirname, filename: '.bundle.js', }, module: { rules: [ { test: /\.jsx?$/, exclude: /node_modules/, use: { loader: 'babel-loader', options: { presets: ['@babel/preset-env', '@babel/preset-react'] } } } ] }, resolve: { extensions: ['.js', '.jsx'] } };
At 27:45, the updated option is --color, not --colors
For MacOS or Linux based systems, the file that gets generated is not bundle.js, but .bundle.js (notice the dot before "bundle"). So, when you add the script in KYM.html, you have to add ".bundle.js" with the dot at the front.
To get the following webpack command working { "name": "rkym", "version": "1.0.0", "main": "main.jsx", "devDependencies": { "@babel/core": "^7.20.5", "@babel/preset-env": "^7.20.2", "@babel/preset-react": "^7.18.6", "babel-loader": "^9.1.0", "jquery": "^3.6.1", "react": "^18.2.0", "react-dom": "^18.2.0", "webpack": "^5.75.0", "webpack-cli": "^5.0.1", "webpack-dev-server": "^4.11.1" } } required changes the webpack.config.js to be module.exports = { entry: './main.jsx', devtool: 'source-map', mode: 'development', output: { path: __dirname, filename: '.bundle.js', }, module: { rules: [ { test: /\.jsx?$/, exclude: /node_modules/, use: { loader: 'babel-loader', options: { presets: ['@babel/preset-env', '@babel/preset-react'] } } } ] } }; Also required not using -d option on the webpack cli
mime.lookup doesn't work in mime 2. It has been replaced with mime.getType
thanks homie
god bless you and thx 4 de highest mark i've ever achieved in the java classes of my uni excelsior tutorial thxthxthx
I feel like you are generating alot of views overall from students who are going to PCC, as they desperately try to decrypt this recycled material for the new homework problems (there feels like a huge disconnect between the content and course). I hope your not getting monetized. Its bad enough that every CIS teacher @PCC uses your videos instead of actually teaching, but if you were profiting on it as well it would truly be disgusting and crooked.
Not monetized.
thank u sir, this really helpfull... after more than 20 videos i finally find something that help me god bless u
Hi Marc, I'm still getting the same error. Do you have any other recommendations?
Use pymssql instead. The syntax for executing parameterized statements is a little different, but it's an easy change to learn, and the installation for pymssql is often easier on Mac because it doesn't go through the MS ODBC drivers.
@@marcgoodman4862 Thanks!! That worked for me!
link please
thank's guy
thanx a lot!
Hi Marc, great tutorial! I was wondering if you think it's best to learn Tkinter by building/designing everything in code first or prior to learning 'Pygubu' designer. Is that how you started out?
I think it's important to understand how tkinter works so that you can debug problems when your interface isn't working as expected, and because the pygubu interface won't mean anything to you unless you know the tkinter interface. However, I don't think building and maintaining a complicated interface directly in tkinter is practical. So, I'd definitely recommend building some simple interfaces in tkinter first, so that you get the hang of it, and can also write one-off code when you want to test something directly in tkinter, but that you transition to a reasonable GUI development tool as quickly as possible. I've worked in several different environments, and they're all pretty much the same as far as the split between the GUI development library (like tkinter, Swing or AWT for Java, or the Windows API) and the WYSIWYG GUI development tool (like the GUI designer in IntelliJ, or the Windows Forms interface in Visual Studio, or a tool like pygubu designer). Once you understand how to do that in one environment, a lot of those skills transfer to other environments you might learn later on, just like understanding how event-driven user interface development works. The first time, it's a challenge to understand how the pieces fit together, but once you get it, it's pretty much the same in most of the environments you'll be working in.
A truly life saver! thank you, it was reMARCkable!
That's amazing , this is most helpful video i've ever seen in the youtube universe
Marc. Please make a new video for the instructors using your materials. This code is 5 years old. PCC is ripping me off using the same code in 2022.
Awesome explanation...keep up the good work...subscribed.
Thank you for the great video!
Very usefull, thanks