🚀 go-pugleaf

Hi everyone,

My team is now developing an application with SQL Server 2000 as the backend 
database. We are trying to minimize the lock level in order to fine-tune the 
database, but we still have no clue on it. Would anyone please give me some 
insights how to acheive it? The following is the source code used to 
establish the connection.

    AnsiString connStr = "Provider=SQLOLEDB.1;Persist Security Info=False;";
    connStr += "User ID="+ strLoginName+";";

    if(strLoginPwd != "")

        connStr += "Password="+ strLoginPwd+";";



    connStr += "Initial Catalog=Mutation;Data Source=";

    connStr += strDBServName;



    ADOConnection->Close();

    ADOConnection->Connected = false;

    ADOConnection->ConnectionString = connStr;

    ADOConnection->LoginPrompt = false;



    try

    {

        ADOConnection->Open();

    }

    catch(...)

    {

        lbDBResult->Caption = "Failed!";

    }




Thanks a lot,
Leo