create pro-grammatically Connection string

Question

how to create pro-grammatically connection string usinf sqlconfigdatasource() in mfc vc++ ? plz reply my mail id: kg.patel@merillife.com

kinjal patel · Answer

CString strServer; strServer.Append(_T(DSN=EIQUANT# DATABASE=DBEIAQUANT# SERVER=(local)# Trusted_Connection=Yes#)); /*=(local); strServer.Append();*/ strServer.Replace('#''\0'); if (!SQLConfigDataSource(NULL ODBC_ADD_DSN_T(SQL Server)strServer)) { MessageBox(_T(Failed)); } else { MessageBox(_T(Success)); }