Help---access Server. - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

Help---access Server.

Help---access Server.# Database - 数据库

e*e2000-12-04 08:12

1 楼

Remote server is SQL. HOw to set up from control panel ODBC
and connect to the SQL Server.
After set up, HOw to create table and connect to it?
Thank you in advance.

D*N2000-12-04 08:12

2 楼

Control Panel/ODBC Data Source
Setup a new SQL data souce (from the "system" tab)
You'll have to know the server ip/name and ur username/password.
Then it'll be accessible to all programs with ODBC connectivity.
Say you want to look at the table in Access:
You can open a file, under "Tables"
Create new linked table... Again select SQL datasource
Then select your odbc data source and one of the table associated with it.
So if your datasource is "TestDB" and the table is "dTest"
You'll be selectin

【在 e******e 的大作中提到】

: Remote server is SQL. HOw to set up from control panel ODBC
: and connect to the SQL Server.
: After set up, HOw to create table and connect to it?
: Thank you in advance.