int answer,answer1,answer2,answer3,answer4,answer5,answer6
string ls_driver,ls_trans,app_path,db_path
//获取应用程序路径
app_path=GetCurrentDirectory()
ls_driver=app_path+"\"+as_driver+"\DBODBC7.dll" //驱动程序路径
ls_trans=app_path+"\"+as_driver+"\DBODTR7.dll"
if not fileexists(ls_driver) then
MessageBox("错误","没有ASA7.0驱动程序,系统将终止运行!",StopSign!)
return false
end if
//设置ODBC=ODBCINST.INI\ODBC DRIVERS
string tmp
answer=RegistryGet("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers",&
"Adaptive Server Anywhere 7.0",RegString!,tmp)
if answer=-1 then
answer=RegistrySet("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers",&
"Adaptive Server Anywhere 7.0",RegString!,"Installed")
if answer=-1 then
MessageBox("错误","应用程序无法设置ODBC DRIVERS,系统将终止运行!",StopSign!)
return false
end if
end if
//设置ODBC\ODBCINST.INI(1)
answer2=RegistrySet("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Adaptive Server Anywhere 7.0",&
"Driver",RegString!,ls_driver)
answer3=RegistrySet("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Adaptive Server Anywhere 7.0",&
"Setup",RegString!,ls_driver)
if answer1=-1 or answer2=-1 or answer3=-1 then
MessageBox("错误","应用程序无法设置ODBCINST.INI,系统将终止运行!",StopSign!)
return false
end if
//设置ODBC\ODBCINST.INI(2)
answer1=RegistrySet("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Adaptive Server Anywhere 7.0 Translator",&
"Translator",RegString!,ls_trans)
answer2=RegistrySet("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Adaptive Server Anywhere 7.0 Translator",&
"Driver",RegString!,ls_trans)
answer3=RegistrySet("HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\Adaptive Server Anywhere 7.0 Translator",&
"Setup",RegString!,ls_trans)
if answer1=-1 or answer2=-1 or answer3=-1 then
MessageBox("错误","应用程序无法设置ODBCINST.INI,系统将终止运行!",StopSign!)
return false
end if
//设置ODBC DATA SOURCE名称(as_datasource为数据源)
answer=RegistrySet("HKEY_CURRENT_USER\software\odbc\odbc.ini\ODBC Data Sources",&
as_datasource,Regstring!,"Adaptive Server Anywhere 7.0")
if answer=-1 then
MessageBox("错误","应用程序无法设置ODBC DATA SOURCE,系统将终止运行!",StopSign!)
return false
end if
//设置ODBC.INI的细节
db_path=app_path+"\"+as_datasource+".db" //数据库文件
answer1=RegistrySet("HKEY_CURRENT_USER\software\odbc\odbc.ini\"+as_datasource,&
"driver",Regstring!,ls_driver)
answer2=RegistrySet("HKEY_CURRENT_USER\software\odbc\odbc.ini\"+as_datasource,&
"Integrated",Regstring!,"No")
answer3=RegistrySet("HKEY_CURRENT_USER\software\odbc\odbc.ini\"+as_datasource,&
"Autostop",Regstring!,"yes")
answer4=RegistrySet("HKEY_CURRENT_USER\software\odbc\odbc.ini\"+as_datasource,&
"DataBaseFile",Regstring!,db_path)
answer5=RegistrySet("HKEY_CURRENT_USER\software\odbc\odbc.ini\"+as_datasource,&
"PWD",Regstring!,"SQL")
answer6=RegistrySet("HKEY_CURRENT_USER\software\odbc\odbc.ini\"+as_datasource,&
"UID",Regstring!,"DBA")
if answer1=-1 or answer2=-1 or answer3=-1 or answer4=-1 or answer5=-1 or answer6=-1 then
MessageBox("错误","应用程序无法设置ODBC.INI的细节,系统将终止运行!",StopSign!)
return false
else
//MessageBox("信息","ODBC注册成功!",Exclamation!)
return true
end if
你是用什么连接的数据库啊,如果odbc的话,你在其他计算机上需要重新配置一下odbc,另外看看计算机名称一样吗???你最好在连接数据库的connect后加上
if sqlca.sqlcode<>0 then
messagebox("提示","数据库因为'"+sqlca.sqlerrtext+"'连接失败!")
end if