yyg1107

命令行创建ODBC数据源

命令行创建ODBC数据源

odbcconf CONFIGSYSDSN "驱动程序名" "DSN=数据源名|SERVER=服务器名|Database=数据库名"
REG Delete "HKLM\SOFTWARE\ODBC\ODBC.INI\数据源名" /v "LastUser" /f
REG ADD "HKLM\SOFTWARE\ODBC\ODBC.INI\数据源名" /v "LastUser" /t "REG_SZ" /d "sa" /f

odbcconf CONFIGSYSDSN "sql server" "DSN=heatnet|SERVER=192.168.1.199|Database=pubs"
REG Delete "HKLM\SOFTWARE\ODBC\ODBC.INI\heatnet" /v "LastUser" /f
REG ADD "HKLM\SOFTWARE\ODBC\ODBC.INI\heatnet" /v "LastUser" /t "REG_SZ" /d "sa" /f

posted on 2007-04-29 11:28 young 阅读(1526) 评论(0)  编辑  收藏 所属分类: other