Creating a Data Source Name (DSN)
Before you can get into the actual programming of ADO, you first have to enter information about your data store by creating a DSN through the ODBC Data Sources applet in the Control Panel. This DSN, in combination with ADO, will allow you to easily connect to your data stores. When you create a DSN in this applet, you are not making a connection to the data, but entering information about the connection you will make. There are three different types of DSNs that you can make. Figure 6.1 shows the ODBC Data Source Administrator and the tabs of the three DSNs you can create. First, you will learn about each of the three DSN's. Next, you will create a System DSN. Fortunately, the steps you use to create a System ...
Get Sams Teach Yourself Microsoft® Windows® DNA Programming in 21 Days now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
