| 144 |
| Synchronize and update ODBC components |
| Useing Open Database Connectivity Data Source Names (ODBC DSNs) to provide access to |
| databases hosted on a Windows 2000 Professional computer. ODBC connections are easy to set up |
| and maintain, and they offer an effective and inexpensive way for users to expose a database to |
| other users on the LAN or even on the Internet. |
| Although it's easy to set up a DSN, in some situations, you might find that your connections fail or |
| give odd results. For example, you might develop a Web application that uses an ODBC connection |
| to provide data to Internet or intranet users, only to find that you receive a server-side error each |
| time you try to open the page. This can occur even if your Web development application showed no |
| problems in opening the connection. |
| Many ODBC problems stem from unsynchronized ODBC component versions. To ensure proper |
| operation, update your system with the latest version of the ODBC components; also, verify that |
| there are no version inconsistencies among the components. |
| Microsoft provides a tool called the Component Checker that you can use to check a system's |
| ODBC components and determine if their versions match. You'll find the Component Checker on |
| Microsoft's Universal Data Access Web site, along with the latest version of Microsoft Data Access |
| Components (MDAC), which installs ODBC support. |
| http://www.microsoft.com/data/ |
First Previous Next Last |