1,079
社区成员
发帖
与我相关
我的任务
分享
//***********************************************
// 函数名: gf_setodbc_mysql
// 功能: 完成mysql数据源的注册功能
// 输入参数:
// as_server 服务器名称
// as_database 数据库名
// as_user 用户名
// as_pwd 密码
// 返回值:
// true 表示自动配置成功
// false 表示自动配置失败
//***************************************************
boolean lb_rtn
string ls_root,ls_root_dsn,ls_root_Jet,ls_root_Engines
integer li_rtn
string ls_dsnname,ls_dbfullname,ls_driver,temp,ls_version
string ls_apppath
//
//integer rtn
//生成驱动程序所在路径gs_appdir为应用目录
ls_driver = gs_appdir + "\myodbc5.dll"
lb_rtn = true
ls_root = "HKEY_LOCAL_MACHINE\software\odbc\odbc.ini"
//数据源名字为:文件名字+“_DT”
ls_dsnname = as_database + "_DT"
ls_root_dsn = ls_root + "\" + ls_dsnname
//ls_root_Engines = ls_root_dsn + "\" + "Engines"
//ls_root_Jet = ls_root_Engines + "\" + "Jet"
ls_dbfullname = as_database
//注册数据源的名字
li_rtn = registryset(ls_root,ls_dsnname,regstring!,"")
if li_rtn= - 1 then
return false
end if
//注册数据库名字
li_rtn = registryset(ls_root_dsn,"DATABASE",regstring!,ls_dbfullname)
if li_rtn= - 1 then
return false
end if
//注册数据库驱动程序
li_rtn = registryset(ls_root_dsn,"Driver",regstring!,ls_driver)//"C:\Program Files\MySQL\Connector ODBC 5.1\myodbc5.dll")//"C:\WINNT\system32\odbcjt32.dll")
if li_rtn= - 1 then
return false
end if
//注册端口号
li_rtn = registryset(ls_root_dsn,"PORT",regstring!,"3306")
if li_rtn= - 1 then
return false
end if
li_rtn = registryset(ls_root_dsn,"Description",regstring!,"Demo_AutoDSN")
if li_rtn= - 1 then
return false
end if
//注册数据库服务器
li_rtn = registryset(ls_root_dsn,"SERVER",regstring!,as_server)
if li_rtn= - 1 then
return false
end if
//注册数据库用户名
li_rtn = registryset(ls_root_dsn,"UID",regstring!,as_user)
if li_rtn= - 1 then
return false
end if
//注册数据库密码
li_rtn = registryset(ls_root_dsn,"PWD",regstring!,as_pwd)
if li_rtn= - 1 then
return false
end if
//OPTION
li_rtn = registryset(ls_root_dsn,"OPTION",regstring!,"4096")
if li_rtn= - 1 then
return false
end if
return lb_rtn