Nice video. Clear and to the point. 🚀 Keep growing 🚀🚀
@carterhenderson1648
3 жыл бұрын
Excellent video! This video saved me, and many others it appears, a bunch of time.
@izzyanalytics4145
3 жыл бұрын
Great to hear!
@mounikapathuri8606
6 ай бұрын
Thank you so much. This video helped me a lot.
@janivimal
Жыл бұрын
Wonderful !! very informative , thank you for sharing !
@chriskeo392
2 жыл бұрын
I am using a dash flask application deployed on azure apps. I've tried to use close and dispose but it does not close the SPID connection. It just accumulates.
@rajkumarrajan8059
Жыл бұрын
Hey Lizzy, When i try it on my computer there are several methods which i am not able to view properly, I dont know what am i missing
@boaretto28
3 жыл бұрын
Thank Thank Thank Thank Thank Thank Thank you.... This video saved my life :)
@izzyanalytics4145
3 жыл бұрын
Glad to help
@gowthamankamalanathan9447
2 жыл бұрын
Hi Izzy, I tried your method to connect SQL Server with python and it worked out very well eventually got the result but I have been getting an error when i create a connection, This Code: conx = pyodbc.connect(conx_string); I get an error message, TypeError: argument 1 must be a string or unicode object it doesn't affect the result but if you could help me with the error i would be grateful thank you
@andreshernandocerquerameji2148
Жыл бұрын
you rock, Kudos.
@vinayakparab6260
4 жыл бұрын
Thanks for the video. helped me a lot
@izzyanalytics4145
4 жыл бұрын
Glad to help
@lolliepoep
3 жыл бұрын
Great video, clear and to the point
@renatocorreaarrieche
3 жыл бұрын
Very good video! Thank you for sharing
@hardcode1136
3 жыл бұрын
Thanks sir 🙏 from ur new subscriber.
@izzyanalytics4145
3 жыл бұрын
Thanks!
@hardcode1136
3 жыл бұрын
@@izzyanalytics4145 respected sir, can u plz make a series on react js? I hope u'll take my request under ur consideration.
@loing9900
2 жыл бұрын
I faced an error "Data source name not found and no default driver specified (0) (SQLDriverConnect)". Could you tell me how to fix that?
@surendarsakthivel38
2 жыл бұрын
Hi Izzy, I am trying to connect to remote host sql server located on windows server 2019 using pyodbc. But eventually end up getting an error. Is there any parameter to specify the remote host ip address and connect to sql server present on remote host ? Please advice
4 жыл бұрын
Thank you so much. This video helped me a lot!
@rbrtsparkman
4 жыл бұрын
I subscribed from this video
@JeffersonCanedo
2 жыл бұрын
Super
@maratpopov5119
3 жыл бұрын
Hello IZZY, I have such an error: module 'pyodbc' has no attribute 'connect'. Previously I have installed pyodbc on my PyCharm.
@izzyanalytics4145
3 жыл бұрын
There could be several issues. It's hard to say without seeing the code. Try this: www.reddit.com/r/Python/comments/82p09n/bizarre_pyodbc_issue_why_did_my_code_work/
@rajkumarrajan8059
Жыл бұрын
Hey Lizzy, How can we create a Database in SQL Server?
@z.r.777
2 жыл бұрын
Thank you... I had forgotten the trusted connection thing... I even uninstalled and reinstalled SQL Server 😒
@JoshuaDHarvey
4 жыл бұрын
Hey Izzy, thanks for a great video, appreciate you taking the time to publish these for our benefit. I read over the list comprehension docs but I was wondering is there any way to look at the data structure of cursor.columns() so it's a little more intuitive what is being called by row.column_name as row iterates over the cursor.columns()?
@izzyanalytics4145
4 жыл бұрын
I'll check on this
@izzyanalytics4145
4 жыл бұрын
`cursor.columns()` returns a row object. It's a class defined by pyodbc, but it most closely resembles a `NamedTuple` which you can find from the `Collections` package in the python standard library. If you do `help(cursor.columns)` you'll see all of the column names available in each row returned by the columns method.
@JoshuaDHarvey
4 жыл бұрын
Izzy Analytics ok awesome I should have checked the help docs first but I appreciate you responding with that info. Thanks again!
@tyl9680
Жыл бұрын
How to connect to the database using the SSH tunnel with the public key?
@cmi42u
4 жыл бұрын
Hey can i insert the JSON data output as values, like they are also a kind of tuples, they are actually a list ! will that work?? but I must say you made a nice video. it was much helping
@izzyanalytics4145
4 жыл бұрын
I just want to make sure I understand the question. So, you have JSON formatted data and you want to put it into an INSERT statement? Is that correct?
@cmi42u
4 жыл бұрын
@@izzyanalytics4145 yes
@izzyanalytics4145
4 жыл бұрын
@@cmi42u have you already converted the json file to a python data type... such as a list of tuples or dictionaries? What does the structure look like. For example: [(1, 'blue'), (2, 'red')] or [{'id': 1, 'color': 'red'}, {'id': 2, 'color': 'blue'}]
@izzyanalytics4145
4 жыл бұрын
@@cmi42u I've posted a few examples here that might help with what you are trying to do. If not, just let me know.. There are a lot of different ways to do this. github.com/israel-dryer/Python-Tutorials/blob/master/pyodbc-tutorials/pyodbc-insert-examples.ipynb
@cmi42u
4 жыл бұрын
@@izzyanalytics4145 Man, Thanks that works for me :)
@yasirmalik198
2 жыл бұрын
my drivers list is empty. Can somebody help me?
@tye3852
Жыл бұрын
Did you ever resolve this because I'm also fkd...
@captain-black-1
3 жыл бұрын
Help!! After importing how to change it to a dataframe
@saicigna6719
5 жыл бұрын
hi, can you help me understand how to connect to hive like what changes should i do to connect to hive instead of sql server i presently use hue to access. P.S I am a beginner.
@izzyanalytics4145
5 жыл бұрын
I'm not familiar with Hive, but you might check out this source github.com/mkleehammer/pyodbc/wiki/Connecting-to-Hive-from-Ubuntu-Debian
@asharanichandra5196
3 жыл бұрын
Plz tell which python version?
@izzyanalytics4145
3 жыл бұрын
3.7
@asharanichandra5196
3 жыл бұрын
3.7.8 or something else
@izzyanalytics4145
3 жыл бұрын
@@asharanichandra5196 it was probably 3.7.7 when I did the video, but I think I've used it on 3.6, 3.7.7, and 3.8.3
Пікірлер: 47