//定义变量
Int answer,answer1,answer2,answer3,answer4,answer5,answer6,answer7,answer8,answer9,answer10,answer11
String LS_DATASOU
//设置ODBC DATA SOURCE名称
answer=RegistryGet('HKEY_current_user\Software\ODBC\ODBC.INI\ODBC Data Sources','jxc',RegString!,LS_DATASOU)
IF answer=-1 THEN
//设置ODBC.INI的细节
answer=RegistrySet('HKEY_current_user\Software\ODBC\ODBC.INI\ODBC Data Sources','jxc',RegString!,'Adaptive Server Anywhere 7.0')
answer1=RegistrySet('HKEY_current_user\software\odbc\odbc.ini\jxc','driver',RegString!,"DBODBC7.DLL")
answer2=RegistrySet('HKEY_current_user\software\odbc\odbc.ini\jxc','DisableMultiRowFetch',RegString!,'NO')
answer3=RegistrySet('HKEY_current_user\software\odbc\odbc.ini\jxc','autostop',RegString!,'yes')
answer6=RegistrySet('HKEY_current_user\software\odbc\odbc.ini\jxc','Integrated',RegString!,'NO')
answer7=RegistrySet('HKEY_current_user\software\odbc\odbc.ini\jxc','Debug',RegString!,'NO')
answer8=RegistrySet('HKEY_current_user\software\odbc\odbc.ini\jxc','UID',RegString!,'DBA')
answer9=RegistrySet('HKEY_current_user\software\odbc\odbc.ini\jxc','PWD',RegString!,'sql')
IF answer=-1 OR answer1=-1 OR answer2=-1 OR answer3=-1 OR answer6=-1 OR answer7=-1 OR answer8=-1 OR answer9=-1 THEN
Messagebox('错误','应用程序无法设置细节,系统将终止运行!',StopSign!)
RETURN
END IF
1。第一步,在你的application的open里加入如下语句
//声明变量
Int answer,answer1,answer2,answer3,answer4,answer5,answer6,answer7,answer8,answer9,answer10
string lal
//设置ODBC DATA SOURCE名称;判断系统有无注册odbc源gdc2000即为数据源名称,换成你自己的名称就行了,以下相同
answer=RegistryGet('HKEY_current_user\software\odbc\odbc.ini\ODBC Data Sources','gdc2000' ,RegString!,lal)
IF answer=-1 THEN
//配置源
answer=RegistrySet('HKEY_current_user\software\odbc\odbc.ini\ODBC Data Sources','gdc2000' ,RegString!,'Adaptive Server Anywhere 8.0')
IF answer=-1 THEN
Messagebox('错误','程序无法设置ODBC DATA SOURCE名称,系统将终止运行!',StopSign!)
halt
END IF
IF answer1=-1 OR answer2=-1 OR answer3=-1 OR answer4=-1 OR answer5=-1 OR answer6=-1 OR answer7=-1 OR answer8=-1 OR answer9=-1 OR answer10=-1 THEN
Messagebox('错误','程序无法设置ODBC.INI细节,系统将终止运行!',StopSign!)
halt
END IF
end if
// 连接数据库
SQLCA.DBMS = "ODBC"
SQLCA.AutoCommit = False
SQLCA.DBParm = "ConnectString='DSN=gdc2000'"
connect using sqlca;
if sqlca.sqlcode <> 0 then
messagebox("连接失败","数据库不能连接")
halt
else
open(w_main) //打开你的程序主界面
end if
[HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\ODBC Data Sources]
[HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\ODBC Data Sources]
"ldshop" = "Adaptive Server Anywhere 8.0"