readme.txt

来自「pb所需编程技巧和事例」· 文本 代码 · 共 76 行

请在运行案例程序前，根据以下档案进行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'"