1、运行数据库服务
Run(apppath+"dbsrv7.exe -n " + servername+ " " + dbname)
其中apppath:dbsrv7.exe的安装路径,servername:数据库服务名,dbname:数据库名(最好全名)
2、随系统启动
dos命令:reg add "HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Windows/CurrentVersion/Run" "pbdbserver" "[apppath]dbsrv7.exe -n [servername] [dbname]"
3、注册odbc数据源
String regodbc
String odbcdsnname//odbc数据源名称
String apppath//odbc驱动所在路径
String EngineName//数据库服务器名。即1中的servername
regodbc="HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBC.INI/"+odbcdsnname
RegistrySet(regodbcdatasource,"Driver" , RegString!, apppath+"dbodbc7.dll")
RegistrySet(regodbcdatasource,"EngineName", RegString!, EngineName)
RegistrySet(regodbcdatasource,"UID" , RegString!, "dba")
RegistrySet(regodbcdatasource,"PWD" , RegString!, "sql")
RegistrySet(regodbcdatasource,"AutoStop" , RegString!, "NO")
RegistrySet(regodbcdatasource,"Integrated", RegString!, "NO")
RegistrySet(regodbcdatasource,"Debug" , RegString!, "NO")
RegistrySet(regodbcdatasource,"DisableMultiRowFetch" , RegString!, "NO")
RegistrySet(regodbcdatasource,"CommLinks" , RegString!, "TCPIP{},SharedMemory")//允许tcp/ip访问网络
4、连接数据源与连接本地odbc数据源一样
5、注意事项
DBENG7.EXE 数据库服务程序不响应网络请求,只能用于单机版