Check our collection of high-quality articles, on a variety of Data Access topics. The collection is being regularly updated with new articles.
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…
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…
In this article, we are going to see, step by step, via an example, how we can connect to SQL Server from a Python program using an ODBC connection and the pyodbc module. For this article’s example, I will be using Visual Studio Code, with the MS Python extension. Prior to start reading the article, … Read more…
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…
Hi friends! In this post, I’m sharing with you a useful infographic I created for my Online Course “Entity Framework: Getting Started (Complete Beginners Guide)“. This infographic, provides a quick overview of the Entity Framework in .NET, it describes what it is, how it works and what are its workflows that allow you to build … Read more…
When you try to connect to a SQL Server database from a client application, under certain circumstances, you might get the below error message: A connection was successfully established with the server, but then an error occurred during the login process. (provider: Named Pipes Provider, error: 0 – No process is on the other end of the … Read more…
A few days ago we had our second user group meeting for 2016 at Cyprus .NET User Group and it was all about data access. I was the speaker at the event and I presented Entity Framework and more specifically the “Code First” development approach. What is Entity Framework? Entity Framework is an Object/Relational … Read more…
It’s been a while since my last post but I’ve changed job a few weeks ago and I was in the process of adapting to the new environment 🙂 OK! It is time to sit back, relax a bit, have a cold beer, put some music on, and start writing! A few weeks ago the … Read more…
On September 19, 2009, I delivered a session with topic the Microsoft Sync Framework, during the Mysore SQL Server Community Series. The exact topic was: “Flexible data synchronization with Microsoft Sync Framework”. Further below I provide a short review for my session and I also provide the PowerPoint presentation along with the source code (C#) … Read more…
On September 2, 2009, I had the pleasure to deliver a session on ADO .NET Data Services, during that great SQL Server Marathon; 24 Hours of PASS! This great event was a series of 24 non-stop live, free webcasts dedicated to pure SQL Server knowledge. The exact topic of my session was: “Building Flexible Data … Read more…
Newsflash: More free SQL Server training is on the way! The Mysore/Mandya Technology Group (MY-TG) organizes a series of SQL Server Webcasts which started on Saturday, September 12th, 2009 and will be taking place every Saturday for the next few weeks. To this end, every Saturday, two sessions are presented. Topics include SQL Server 2008 … Read more…
In my first post on SQL Azure (SQL Azure: A First Contact) I talked about how you can access SQL Azure using SQL Server 2008 Management Studio (SSMS). In this post, the journey continues with “walking” on the cloud using ADO .NET 🙂 Here’s the recipe! Ingredients: A valid SQL Azure account Visual Studio … Read more…
I got asked to present a one-hour SQL Server development session during the “24 Hours of PASS” event which starts on September 2, 2009, 00:00 GMT. The “24 Hours of PASS” is a series of live one-hour webcasts broadcast over a 24 hour period that focus on various SQL Server topics. The event is free … Read more…
Another Cyprus .NET User Group special event took place a few days ago (June 18th, 2009). This event was somehow “celebratory”. It was the last offline event before summer holidays. The next offline event (within the series of Community Nights) will take place after two months time, in September 2009. During the summer months (July … Read more…
It is time for another CDNUG event! This event will probably be the last event of CDNUG before summer holidays. The next event will take place next September. To this end, the CDNUG committee decided that this event should feature a variety of .NET and SQL Server Technologies thus providing a taste of all their … Read more…