home // Computers and Internet // Databases
How to Use ODBC to Connect from MS Access on Your PC to the Data ...
Source: dwr.ais.columbia.edu
File Size: 134.7 KB
Category: Computers and Internet
Last Download : 24 days 13 hours 28 minutes ago
Share this info:
Click Image to enlarge
Short Description: Open MS Access, and either create a new database file or open an existing database file. Go to the Database window for the open file. ...
Content Inside: How to Use ODBC to Connect from MS Access on Your PC to the Data Warehouse
ODBC (Open Data Base Connectivity) is a standard database access method that makes it possible to access any data from any application, regardless of which database management system (DBMS) is handling the data. ODBC inserts a middle layer, called a database driver, between an application and the DBMS. The purpose of this layer is to translate the application's data queries into commands that the DBMS understands. For this to work, the application must be capable of issuing ODBC commands, and the DBMS must be capable of responding to them. ODBC Connection Setup 1. 2. 3. 4. 5. Check if the Sybase ODBC driver is installed on the PC. Check if a sql.ini file exists on the PC with a reference to the Sybase server housing the Data Warehouse. Create a data set name (DSN) referring to the Data Warehouse server. Connect to Data Warehouse server in Microsoft Access, and link desired Data Warehouse tables into MS Access. Create a query.
Step 1: Check if the Sybase ODBC driver is installed on your PC. Click on the Start button, point to Settings, and then click on Control Panel. Double-click on Administrative Tools, and then double-click on ODBC Data Source Administrator. Click on the Drivers tab. Scroll down the list and look for "Sybase System 11, as indicated in Figure 1 below.
This line indicates that the Sybase ODBC driver is installed.
Figure 1 If you do not see the Sybase Driver, you will need to download the driver from http://www.columbia.edu/cu/sis/Downloads/downloads.html, which will install SYSYBNT.DLL, the Sybase ODBC driver on your PC. Step 2: Check if a "sql.ini" file exists on your PC with a reference to the Data Warehouse Server. The sql.ini is usually found in the c:\sql\ini folder. (If you downloaded the SDR package, a sql.ini file should have been created.) Once you have
Sponsored Links
Related Search Terms: