e******e
发帖数: 44 | 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****N
发帖数: 430 | 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.
|
|
