/** * 生成ODBC数据源 * @param sServer [IN]数据库服务器名 * @param sDBName [IN]数据库名 */ bool CQQMiserApp::CreateSqlDSN(char * sServer,char * sDBName) { char *szDriver = "SQL Server"; char szAttributes[300],*p; ZeroMemory(szAttributes,200); char temp[100];
//生成名值对 p = szAttributes; strcat(p,"DSN=miser"); p+=strlen("DSN=miser")+1; strcat(p,"DESCRIPTION=miser数据源"); p+=strlen("DESCRIPTION=miser数据源")+1; sprintf(temp,"SERVER=%s",sServer); strcat(p,temp); p+=strlen(temp)+1;
sprintf(temp,"ADDRESS=%s",sServer); strcat(p,temp); p+=strlen(temp)+1;
strcat(p,"NETWORK=dbmssocn"); p+=strlen("NETWORK=dbmssocn")+1; sprintf(temp,"DATABASE=%s",sDBName); strcat(p,temp);
SQLConfigDataSource(NULL,ODBC_ADD_SYS_DSN,szDriver,szAttributes);
return true; } 
|