You are here:-2019

How to configure Oracle ODBC driver on CentOS/Redhat | MVSourceCode

In this tutorial I will be configuring Oracle ODBC driver on CentOS/Redhat server and go true typical issues you might face and also explain how you can fix it. I have Oracle database 11g running on the same Redhat server, if your database is running on a different server then you need to download

By |2019-03-07T08:20:30+00:00March 7th, 2019|Categories: Linux|Tags: , , |0 Comments

Python How To Get Date Range From Week Number – MVSourceCode

I had a project where I had to get  a date range based on year and week number. After quick Google around I couldn't find anything good at that time, so I decided to write a small function myself. Function takes two parameters Year and Week number   and returns two results First Day of

By |2019-02-15T14:43:33+00:00February 15th, 2019|Categories: Python|Tags: , |0 Comments

Python – How to connect to Microsoft Database using ODBC driver (pycharm)

Before creating python connection to SQL database from windows computer we need to ensure we have correct driver installed. The quickest ways to do this is by opening ODBC Data Source Administrator and selecting Drivers tab as per screenshot below. In my case I will be connecting to SQL server 2017 therefore I

By |2019-02-05T13:45:04+00:00February 5th, 2019|Categories: Python|Tags: , , , |0 Comments