September 2011
-
UDL Files: How to Create and Configure Universal Data Link Files
UDL files can be incredibly useful for a variety of reasons (please see my earlier post for details). In this article I will explain the steps for creating and configuring a UDL file. Creating a UDL file is quite straightforward. Here are the steps: First create a new text document in Windows Explorer and give…
-
UDL Files: Centralizing your DataSource Connections – Overview
I have not had much use for UDL (Universal Data Link) files in the past, but recently I found out just how useful they can be. Today I encountered an issue with Crystal Reports 9 calling SQL Server with a blank password when the connection was set within Crystal Reports. After much research and testing I found…
-
SQL Server Linked Servers: Linking Instances of SQL Server Step-by-Step
In most places hosting instances of SQL Server, you will likely find older and newer versions of SQL Server running side-by side. This can of course become a challenge when you are writing code to make the servers communicate with each other. When writing a SQL query on one server, how can one tie together…