带密码的mdb的创建，

[wuchuncai]

我在用vc++,ado写程序时，用_CatalogPtr创建数据库时，不带密码正确，带上就会出
“找不到可安装的ISAM”,那位高手帮帮忙。

::CoInitialize(NULL);

_CatalogPtr m_pCatalog = NULL;

char strcnn[255];
lstrcpy(strcnn,"Provider=Microsoft.JET.OLEDB.4.0;Data source =");
lstrcat(strcnn,FileName);
lstrcat(strcnn,";uid=sa;pwd="); //要此句会出错
try
{
VARIANT _result;
m_pCatalog.CreateInstance(__uuidof (Catalog));
m_pCatalog->Create(_bstr_t(strcnn));
}

catch(_com_error &e)
{
AfxMessageBox(e.Description());
}

catch(...)
{
AfxMessageBox("数据库创建出错");
}
::CoUninitialize();

[wuchuncai]

高手都死了吗？

[ithc]

全D了

[wuchuncai]

我估计可能是我的ado不支持创建带密码的mdb,各位还有什么高见？

[FC_BI1ADI]

光修改连接串还不行，还有ADO控件的属性中也有password也要改才行

[wuchuncai]

我只好自己来增加人气了

[ahphone]

locale
A string expression that specifies a collating order for creating the database, as specified in Settings. You must supply this argument or an error occurs.


You can also create a password for the new Database object by concatenating the password string (starting with ";pwd=") with a constant in the locale argument, like this:


dbLangSpanish & ";pwd=NewPassword"


If you want to use the default locale, but specify a password, simply enter a password string for the locale argument:


";pwd=NewPassword"