аǰµODBCá

Adaptive Server Anywhere 7.0

ODBCụ̀
ODBC:
   data source name: DSN, rate
Login:
   User Id : dba
   Password: sql
Database:
   database file: d:\x\y\xyz.db

DATABASEָӦݿ
,SQLCA.Database="xyz"; ðõݿΪĿ¼µxyz.dbļ


1
//Profile studentinfo
SQLCA.DBMS="ODBC";
SQLCA.Database="studentinfo"; 
SQLCA.DBParm="Connectstring='DSN=studentinfodb;uid=dba;pwd=sql'";

2
//Profile rate
sqlca.dbms = "ODBC"
SQLCA.Database="rate"; 
sqlca.dbparm = "ConnectString='DSN=rate;UID=dba;PWD=sql'"

3
//Profile book
SQLCA.DBMS = "ODBC";
SQLCA.Database="bookManage"; 
SQLCA.DBParm = "ConnectString='DSN=book;UID=dba;PWD=sql'";
ϵͳʼԱΪ     user:adm  password:isgood

4
//Profile house
SQLCA.DBMS = "ODBC"
SQLCA.Database="house"; 
SQLCA.DBParm = "ConnectString='DSN=house;UID=dba;PWD=sql'"

5
// Profile hospital
SQLCA.DBMS = "ODBC"
SQLCA.Database="hospital"; 
SQLCA.DBParm = "ConnectString='DSN=hospital;UID=dba;PWD=sql'"

6
// Profile archieve
SQLCA.DBMS = "ODBC"
SQLCA.Database="archieve"; 
SQLCA.DBParm = "ConnectString='DSN=archieve;UID=dba;PWD=sql'"

7:
[DBMS_PROFILES]
Profiles=EAS Demo DB V4
[Profile EAS Demo DB V4]
DBMS=ODBC
DBParm=ConnectString='DSN=EAS Demo DB V4;UID=dba;PWD=sql'

8
// Profile merchant
SQLCA.DBMS = "ODBC"
SQLCA.Database="merchant"; 
SQLCA.DBParm = "ConnectString='DSN=merchant;UID=dba;PWD=sql'"
ϵͳУʼ½ username = admin , password = 123456

9
// Profile labdata
SQLCA.DBMS = "ODBC"
SQLCA.Database="LabData"; 
SQLCA.DBParm = "ConnectString='DSN=labdata;UID=dba;PWD=sql'"


