各個(gè)參數(shù)的意義: DBServer: 數(shù)據(jù)庫所在主機(jī) DBName: 數(shù)據(jù)庫名稱 DSN: 數(shù)據(jù)源名稱 UID: 登陸用戶 返回值: -1: 沒有安裝SQL Server驅(qū)動程序 -2: 其他錯誤 0: 成功
實(shí)現(xiàn)函數(shù): int MakeSQLServerODBCDSN(LPCTSTR DBServer,LPCTSTR DBName,LPCTSTR DSN,LPCTSTR UID) { BOOL bInstallDriver=TRUE; CRegKey regKey;
LONG lRet=regKey.Open(HKEY_LOCAL_MACHINE,"Software\\ODBC\\ODBCINST.INI\\SQL Server"); if(lRet!=ERROR_SUCCESS) { bInstallDriver=FALSE; } else { char szDirverPath[MAX_PATH]=""; DWORD dwCount=100; lRet=regKey.QueryValue(szDirverPath,"Driver",&dwCount); if((lRet!=ERROR_SUCCESS)||(dwCount<1)) { DWORD dwErr=GetLastError(); bInstallDriver=FALSE; } regKey.Close(); } if(!bInstallDriver) { return -1; } CString strKeyValueName="Software\\ODBC\\ODBC.INI\\"; strKeyValueName+=DSN; lRet=regKey.Create(HKEY_LOCAL_MACHINE,strKeyValueName); if(lRet!=ERROR_SUCCESS) { return -2; } regKey.SetValue(DBName,"Database"); regKey.SetValue("SQLSrv32.dll","Driver"); regKey.SetValue(DBServer,"Server"); regKey.SetValue(UID,"LastUser"); regKey.m_hKey=HKEY_LOCAL_MACHINE; regKey.SetKeyValue("Software\\ODBC\\ODBC.INI\\ODBC Data Sources","SQL Server",DSN); regKey.Close(); return 0; }
|