This was a really good explanation. No extra information, just everything you actually need to know to start writing queries to access your DB from python.
bro i am getting error like this while installing package , ERROR: Could not build wheels for cx_Oracle, which is required to install pyproject.toml-based projects
What is the difference between driver and connector. Also is there any difference between python libraries for database connection and the odbc driver itself.
what if you get message that says: we can't locate the 64 bit oracle client.... I downloaded cx_Oracle package.... I thought it should match directly the operating system running? Can you please explain how to resolve this issue? Thanks. Great lesson and tutorial by the way. It was very clear and straight forward. best regards.
Make sure you have the same python env and cx_oracle as your os . Eg if os is 64 bit, install 64bit python and 64 bit cx_oracle version... maybe you have 32bit of python installed instead of 64. I face the same issue earlier in my career.
Hi Kishan, thanks for all your good video tutorials, one quick question: i'm not seeing suggestions/IntelliSense with cx_Oracle. This is making me to search for the syntax, any suggestions please?
What is the structure of the string you pass into the connection function? In the video you had 'HR/HR@//localhost:1521/orcl" is this '{username}/{password}@//{hostname}:{port}/{SID}'?
Hello Sir, able to connect Oracle to python but while accessing time getting this error, pls help me to solve this " cx_Oracle.DatabaseError: DPI-1072: the Oracle Client library version is unsupported"
Hello , it is very helpful keep it up, and can we deploy the .sql scripts (pl/sql and Structure change requiest(SCR) and Data change request(DCR) files) in daily bases into oracle database by using python language.(for automating deployment process). if yes could you suggest the python script or link of website.
Hi, is it possible to create a script using python to connect to oracle SQL Developer and read a DDL script to a txt file on my pc? if yes, do you have a video on how its done or links to check out?
Hii sir it shows database error : DPI-1047 : cannot locate a 64-bit Oracle client library....I am facing this type of error sir....please give me solution
Hello Amazing video i must say. Keep coming up with such more content. My one concern is what if i have Cutom JDBC URL, what should i do in that case to get HOST, USERNAME & PASSWORD. Please help
You need to have the same but version across OC, python interpreter and the cx_oracle package. If the os is 64 bit, install a 64 bit python and 64 bit cx_oracle package. If they miss match then you will get the mentioned error.
I have a doubt. Connecting to already existing database is good but how do I create new database using python programming only like the way u created table. Please answer this it will be really helpful.
Even I have the same issue. pls. let me know if you get any solution my property file like: host="hostname" user="username" password="passwd" I want to use these details in one of the python script to copy the data to remote server.
cx_Oracle.DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: "The specified module could not be found". See cx-oracle.readthedocs.io/en/latest/user_guide/installation.html for help
Make sure you have the same python env and cx_oracle bit version as your os bit version . Eg if os is 64 bit, install 64bit python and 64 bit cx_oracle version... maybe you have 32bit of python installed instead of 64 bit.
Thank you. It is really helpful video! After i applied all processes i got below error: May it occur because of firewall permissions? Do you have any suggestion about it? Traceback (most recent call last): File "", line 1, in cx_Oracle.DatabaseError: ORA-12170: TNS:Connect timeout occurred
This was a really good explanation. No extra information, just everything you actually need to know to start writing queries to access your DB from python.
Awesome explanation. Just as you need. Keep it up man. Really helpful
Glad it helped!
Very Very Nice Explanation,Sir. Needs More.
Will upload soon
Nice, keep uploading
this video is freaking amazing , thanks a lt for this bro
Glad you liked it!
@@KishanMashru also the way of talking is very relaxed , amazing
Very well explained thx
bro i am getting error like this while installing package ,
ERROR: Could not build wheels for cx_Oracle, which is required to install pyproject.toml-based projects
What is the difference between driver and connector. Also is there any difference between python libraries for database connection and the odbc driver itself.
Thank you, Amazing
what if you get message that says: we can't locate the 64 bit oracle client....
I downloaded cx_Oracle package.... I thought it should match directly the operating system running?
Can you please explain how to resolve this issue?
Thanks.
Great lesson and tutorial by the way.
It was very clear and straight forward.
best regards.
Make sure you have the same python env and cx_oracle as your os . Eg if os is 64 bit, install 64bit python and 64 bit cx_oracle version... maybe you have 32bit of python installed instead of 64. I face the same issue earlier in my career.
Hi Kishan, thanks for all your good video tutorials, one quick question: i'm not seeing suggestions/IntelliSense with cx_Oracle. This is making me to search for the syntax, any suggestions please?
do pip install cx_orcale
Good work bro!!!
What is the structure of the string you pass into the connection function? In the video you had 'HR/HR@//localhost:1521/orcl" is this '{username}/{password}@//{hostname}:{port}/{SID}'?
Exactly!!!
In line cur.execute (sql _create) I am getting missing double quotes identifier wt shd I do plz help as soon as possible?
Hi I get the error no listener. What could be the problem?
your oracle database is down
When I try cur.execute(), there is no method of execute(). What would be the issue ?
cx_Oracle.DatabaseError: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA error
You are doing an amazing job... Please keep up the good work...
Hello, this was useful, I just wanted to suggest, can u add how can we do the same when we need to put a password to connect to DB.
I'm getting getting DPI-1047 database error with DSN connection string. How do I solve it?
simple and clear
. i successfully installed pip install cx_Oracle but still got an error "ModuleNotFoundError: No module named 'cx_Oracle'" .... please help
Hello Sir, able to connect Oracle to python but while accessing time getting this error, pls help me to solve this " cx_Oracle.DatabaseError: DPI-1072: the Oracle Client library version is unsupported"
Hello , it is very helpful keep it up, and can we deploy the .sql scripts (pl/sql and Structure change requiest(SCR) and Data change request(DCR) files) in daily bases into oracle database by using python language.(for automating deployment process). if yes could you suggest the python script or link of website.
Kishan, thank you for your excellent content! Just one question: How can I execute a Select From Query and save it in a JSON?
the error is cx oracle database error dpi cannot locate the 64 bit oracle client library how can solve it plz help me
bhai i need your help related to how to insert stock price in database using cx_oracle
Hi, is it possible to create a script using python to connect to oracle SQL Developer and read a DDL script to a txt file on my pc? if yes, do you have a video on how its done or links to check out?
Hii sir it shows database error : DPI-1047 : cannot locate a 64-bit Oracle client library....I am facing this type of error sir....please give me solution
Thanks! Sir
How to connect as sysdba without password with python 'cx_Oracle' the way we do in shell script 'sqlplus -s / as sysdba' ?
Pass in the password as '' it will use the os authentication
Hello Amazing video i must say. Keep coming up with such more content. My one concern is what if i have Cutom JDBC URL, what should i do in that case to get HOST, USERNAME & PASSWORD. Please help
Try passing in the custom url in the connection object
@@KishanMashru cool Thank you, let me try 😃
Can someone help me for connecting oracle remote database with python? much appreciated.
It should be the same username/password@server
I am getting an error when I try to connect to the database saying " cx_Oracle.DatabaseError :DPI-1047 : Cannot locate a 32 but client library"
did you find any solution?
You need to have the same but version across OC, python interpreter and the cx_oracle package.
If the os is 64 bit, install a 64 bit python and 64 bit cx_oracle package. If they miss match then you will get the mentioned error.
Sir I hv schemaname, password,hostname, service name and port. How to connect
user/password@hostname:port/servicename
I have a doubt. Connecting to already existing database is good but how do I create new database using python programming only like the way u created table. Please answer this it will be really helpful.
try using sqlite3, it allows you to create a local, flat file db
How are you able to configure your editor to display the tips after a component and a period (conn.???) Thanks
you have to set up intellisense
Awesome video!!!
Don't we need to close database connection in python like as in other languages?
We should close both connection and cursor. If we use with statement.. no need to specify explicitly..
Have you tried dumping pandas dataframe to oracle db?
df.to_sql() explore this method
Awesome video. Is it possible to pass the connection string from a config. file?
This python script is support for all versions or not?
Share similar one for Linux, does it requires Oracle Client
Irrespective of the OS the steps would remain the same!!!
I want to pass the username and password as parameters to cx_oracle.makedsn , how to pass them ?
Even I have the same issue. pls. let me know if you get any solution
my property file like:
host="hostname"
user="username"
password="passwd"
I want to use these details in one of the python script to copy the data to remote server.
@@guravaiahe509 build the connecting string.
username + '/' + password +'@' + database and then pass the same
cx_Oracle.DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: "The specified module could not be found". See cx-oracle.readthedocs.io/en/latest/user_guide/installation.html for help
Make sure you have the same python env and cx_oracle bit version as your os bit version .
Eg if os is 64 bit, install 64bit python and 64 bit cx_oracle version... maybe you have 32bit of python installed instead of 64 bit.
Thank you. It is really helpful video! After i applied all processes i got below error: May it occur because of firewall permissions? Do you have any suggestion about it?
Traceback (most recent call last):
File "", line 1, in
cx_Oracle.DatabaseError: ORA-12170: TNS:Connect timeout occurred
error for connecting oracle database to python
Where is pwd