Data Access

Check our collection of high-quality articles, on a variety of Data Access topics. The collection is being regularly updated with new articles.

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

by

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…

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

by

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…

Infographic: An Introduction to Entity Framework

by

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…

A connection was successfully established with the server, but then an error occurred during the login process.

by

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…

MY-TG SQL Server Community Series‏ – Session Review (Sync Framework)

by

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…

24 Hours of PASS – Session Review (18 – ADO .NET Data Services)

by

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…

Mysore PASS Chapter SQL Server Webcasts Series

by

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…

Accessing SQL Azure Using ADO.NET

by

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…

ADO .NET Data Services for the Web / Visual Studio 2010: A First Look

by

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…

Upcoming CDNUG Event, June 18th – ADO .NET Data Services for the Web / Visual Studio 2010: A First Look

by

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…

Screencast: Using Inheritance in the ADO .NET Entity Framework

by

Welcome to another screencast dedicated to SQL Server 2008 Programmability! This screencast again features the ADO .NET Entity Framework. The screencast demonstrates how the developer can create an entity data model in Visual Studio 2008, and goes one step further, thus demonstrating a simple way of using inheritance in the entity data model.   Watch … Read more…