Question

odbc怎么连接sql 2008数据库

Answer 1

sql server安装完成基本就可以使用了，不用设置和配置。
你打开ODBC，添加一个系统或是用户的，选择联接的时候，驱动选择SQL server。
到点完成，就进入到配置界面，基本就是设置一下，下一步，一直到完成。

Answer 2

1. Setting up an ODBC Data Source
STEP 1: First, find the icon labeled Data Sources in the Administrative Tools folder in Control Panel. (In Windows 98, it will be labeled ODBC Data Sources (32 bit) and will be present in the Control Panel.)
STEP 2: Click on the Data Sources Icon to start the setup process. This will produce a window where we can add ODBC data sources. If the System DSN tab is not selected, select it. To add a data source, click the Add... button.
STEP 3: After clicking the Add... button, a list of drivers will be presented which are used to create the data source. Scroll down until you find the driver for the database to be accessed. (In this case, SQL Server.)
STEP 4: In this case, we'll select SQL Server as the driver to use because we'll be connecting to a SQL Server database. After selecting SQL Server from the list above, click the Finish button to specify how the connection will be made to the SQL Server database.
STEP 5: In order to make the connection to the database, the Name, Description, and Server name have to be specified. (NOTE: These values will be obtained from the database administrator.) After entering the connection details, click the Next> button to specify how the database server will verify the authenticity of the login ID.
STEP 6: Now select the bottom radio button (With SQL Server authentication using...) as the method used to authenticate. Use the Login ID and Password obtained from the database administrator and then click the Next> button. This will open a window to allow specification of the default database.
STEP 7: Check the checkbox next to "Change the default database to" and select the database as given by the database administrator. Click the Next> button to open the next window.
STEP 8: When the window opens, just accept the defaults and click the Finish button. This will produce another window with a summary of the settings for the data source.
STEP 9: Test the data source by clicking the Test Data Source button. If everything works as expected, then the results window will appear.
STEP 10: When the test has been completed successfully, just click the OK button to close the window. The ODBC data source has been successfully created.

2. Connect using ODBC Data Sources
STEP 1: Once an ODBC data source has been created, it can be used by other programs (Access, PowerBuilder, etc...) to gain access to database servers. In Microsoft Access, go to the File menu and select Get External Data and choose Link Tables... from the resulting menu.
STEP 2: This action will produce a window which will allow you to choose the database with which to link. For ODBC database, choose ODBC Databases from the Link window.
STEP 3: After choosing ODBC Databases, the Select Data Source window will open with a list of data sources. Select the Machine Data Source tab to view installed data sources. Select the data source to be used from this list.
STEP 4: When the appropriate data source is selected, click the OK button to connect to the database server. A login prompt will appear and the login information supplied will be used here.
STEP 5: After successfully connecting to the database server (using a correct Login ID and Password), the Link Tables window will appear with a list of the tables available to choose from. Select the tables to which you have access and click OK to start opening your tables.
STEP 6: The selected tables are now available through Microsoft Access.