IndexError: list index out of range – How to Resolve it in Python

Hi friends, in this post, we will be discussing about, how you can easily resolve the “IndexError: list index out of range” error when coding in Python. This is a common runtime error message you might get under certain circumstances, when coding in Python.   Reproducing the “IndexError” Python Error In order to better understand … Read more…

Mastering Python & SQL Server: Best Practices

Hi there! In this article, we’ll be discussing about some of the best practices, for when combining Python with SQL Server for your data-driven applications.   Establishing a Solid Foundation It’s essential to establish a strong foundation in order to ensure a seamless integration of Python with SQL Server. Learn about the basic concepts of object-oriented … Read more…

Python Data Access Fundamentals

Hi friends, in an older article, we have talked about how you can connect to SQL Server databases from a Python program. In this article, we will be discussing about the Python Data Access fundamentals, that is how you can connect to different databases from within your Python code. In general, Python provides the capability … Read more…

Missing parentheses in call to ‘print’. did you mean print(…) – How to Resolve in Python

Hi friends, in this short tip, we will be discussing how you can easily resolve the error message: missing parentheses in call to ‘print’. did you mean print(…). This is a common syntax error message you might get, when coding in Python.   Reproducing the “Missing Parentheses” Python Error In order to better understand the … Read more…

IndentationError: expected an indented block in Python – How to Resolve it

Hi friends! In this post, we will be discussing about the “IndentationError: expected an indented block” in Python and how to easily resolve it, as well as, how to resolve the “IndentationError: unexpected indent” error.   What is Indentation in Python? Generally, in programming, indentation is when you leave empty spaces in the beginning of … Read more…

How to Resolve: [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)

This article, provides useful troubleshooting tips, for the following error which you might get, under certain circumstances, when trying to connect to SQL Server from Python, using pyodbc: [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect). Prior to sharing our tips for troubleshooting the issue, let’s discuss … Read more…

Useful Python Programming Tips

In this post, I will be regularly posting useful Python programming tips. These tips will be organized in different categories, in order to make it easier to read it.   Hello World in Python The below command, prints a “Hello World” message from within a Python script: print(“Hello World from Python”)   Code Indentation in … Read more…

Working with Python on Windows and SQL Server Databases (Course Preview)

In this post, we are announcing the general availability of our online course: “Working with Python on Windows and SQL Server Databases“. Note that the course is currently available on Udemy.   What is this course all About? Python is a very popular programming language. Due to its simplified syntax, Programmers can develop a wide … Read more…