PB中自动注册ODBC数据源后,为什么总是连接不上SYBASE数据库?
我用PB9+SYBASE做了个程序,采用自动注册ODBC数据源,可是就是连接不上数据库,每当运行时总是弹出创建ODBC数据源的设置画面.数据库文件与程序文件放在同一目录,而且在注册表也能看到相关设置,应该没有错误的.请高手指点下,谢谢.
大家帮我看下这个自动注册得代码有问题麽?
自动注册数据源代码:
string ls_key,ls_key1
ls_key = 'HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\' +'guest'
ls_key1 = 'HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\ODBC Data Sources'
//数据库文件叫guest.db
Registryset(ls_key,'Driver',"dbodbc8.dll")
Registryset(ls_key,'Description',"自动注册ODBC数据源")
Registryset(ls_key,'UID',"dba")
Registryset(ls_key,'PWD',"sql")
Registryset(ls_key,'Start','dbeng8.exe -Q')
Registryset(ls_key,'DatabaseFile','guest.db')
Registryset(ls_key,'DatabaseName','guest')
Registryset(ls_key,'AutoStop',"Yes")
Registryset(ls_key1,as_odbc_name,"Adaptive Server Anywhere 8.0")
连接数据库代码:
SQLCA.DBMS = "ODBC"
SQLCA.AutoCommit = False
SQLCA.DBParm="Connectstring='DSN=guest;UID=dba;PWD=sql'"