VC++数据库连接字符串

//初始化Com组件
if(!AfxOleInit()) 
{  
 AfxMessageBox("OLE初始化出错!");  
 return   FALSE;  
}

 

//连接SQL2000的字符串
CString retVal;
retVal.Format("Driver=SQL Server;Server=%s;Database=%s;UID=;PWD=",strServer,strDataBase);

 

//连接Oracle的字符串
retVal.Format("Provider=OraOLEDB.Oracle;User ID=%s;Password=%s;" "Data Source='(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)" "(HOST=%s)(PORT=1521)))(CONNECT_DATA=(SID=%s)))'",strUserName,strPassword,strServer,strDataBase);