//Function Uint GetDriveTypeA (String drive) Library "kernel32.dll"
cur_dir=Space(256)
//GetCurrentDirectoryA(256,cur_dir) //取当前目录
if answer=-1 then
ls_location=cur_dir
ls_driver=ls_location+'dbodbc6.dll'
ls_start=ls_location+'dbeng6.exe'
if not (FileExists(ls_driver) AND FileExists(ls_start)) THEN
Messagebox('错误',ls_location+'目录中没有安装dbeng6.exe和dbodbc6.dll文件!',StopSign!)
return -1
else
RegistrySet(ls_apppath + "dbeng6.exe","path",RegString!,ls_location)
RegistrySet(ls_apppath + "dbeng6.exe","",RegString!,ls_start)
end if
else
ls_driver=ls_location+'dbodbc6.dll'
ls_start=ls_location+'dbeng6.exe'
if not (FileExists(ls_driver) AND FileExists(ls_start)) THEN
Messagebox('错误',ls_location+'目录中没有安装dbeng6.exe和dbodbc6.dll文件!',StopSign!)
return -1
end if
end if
//设置ODBC\ODBCINST.INI\ODBC DRIVERS
answer=RegistryGet(ls_odbc1 + 'ODBC DRIVERS','Adaptive Server Anywhere 6.0',RegString!,ls_value)
if answer=-1 THEN
answer1=RegistrySet(ls_odbc1 + 'ODBC DRIVERS','Adaptive Server Anywhere 6.0',RegString!,'Installed')
answer2=RegistrySet(ls_odbc1 + 'Adaptive Server Anywhere 6.0','Driver',RegString!,ls_driver)
answer3=RegistrySet(ls_odbc1 + 'Adaptive Server Anywhere 6.0','Setup',RegString!,ls_driver)
IF answer1=-1 OR answer2=-1 OR answer3=-1 THEN
Messagebox('错误','应用程序无法设置ODBC DRIVERS,运行不能继续!',StopSign!)
RETURN -1
END IF
end if
//设置ODBC DATA SOURCE名称
answer=RegistryGet(ls_odbc2 + 'ODBC Data Sources',s_dsn,RegString!,ls_value)
if answer=-1 THEN
db_path=cur_dir+'\'+db_name+".db"
answer=RegistrySet(ls_odbc2 + 'ODBC Data Sources',s_dsn,RegString!,'Adaptive Server Anywhere 6.0')
answer1=RegistrySet(ls_odbc2 + s_dsn,'driver',RegString!,ls_driver)
answer2=RegistrySet(ls_odbc2 + s_dsn,'start',RegString!,ls_start+' -d -Q -c1024')
answer3=RegistrySet(ls_odbc2 + s_dsn,'autostop',RegString!,'yes')
answer4=RegistrySet(ls_odbc2 + s_dsn,'DataBaseFile',RegString!,db_path)
answer5=RegistrySet(ls_odbc2 + s_dsn,'DataBaseName',RegString!,db_name)
answer6=RegistrySet(ls_odbc2 + s_dsn,'uid',RegString!,"dba")
answer7=RegistrySet(ls_odbc2 + s_dsn,'pwd',RegString!,"sql")
answer8=RegistrySet(ls_odbc3 + s_dsn,"Driver", RegString!,ls_driver)
answer9=RegistrySet(ls_odbc3 + s_dsn,"uid", RegString!,"dba")
answer10=RegistrySet(ls_odbc3 + s_dsn,"pwd", RegString!,"sql")
answer11=RegistrySet(ls_odbc3 + s_dsn,"Start", RegString!,ls_start+' -d -Q -c1024')
answer12=RegistrySet(ls_odbc3 + s_dsn,"DatabaseFile", RegString!,db_path)
answer13=RegistrySet(ls_odbc3 + s_dsn,"DatabaseName", RegString!,db_name)
answer14=RegistrySet(ls_odbc3 + s_dsn,"AutoStop", RegString!, "yes")
answer15=RegistrySet(ls_odbc3 + "ODBC Data Sources",s_dsn, RegString!, "Adaptive Server Anywhere 6.0")
if answer=-1 or 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 or answer11=-1 or &
answer12=-1 or answer13=-1 or answer14=-1 or answer15=-1 THEN
Messagebox('错误','应用程序无法设置ODBC DATA SOURCE,运行不能继续!',StopSign!)
RETURN -1
end if