<< Click to Display Table of Contents >> Navigation:  »No topics above this level« C Examples: DbiOpenDatabase

Example 1: Open a standard database using an alias name.

This example uses the following input:
         fDbiOpenDatabase1(&hDb, "MyAlias");

DBIResult fDbiOpenDatabase1(phDBIDb phDb, pCHAR alias)

{

   DBIResult    rslt;

   rslt = Chk(DbiOpenDatabase(alias, NULL, dbiREADWRITE, dbiOPENSHARED,

            NULL, 0, NULL, NULL, phDb));

   return rslt;

}

 

Example 2: Open a standard database with no alias name.

To access tables in a directory other than the current, you must call DbiSetDirectory. This example uses the following input:
         fDbiOpenDatabase2(&hDb, "C:\\MyDir\\Tables");

DBIResult fDbiOpenDatabase2(phDBIDb phDb, pCHAR Directory)

{

   DBIResult   rslt;

   rslt = Chk(DbiOpenDatabase(NULL, NULL, dbiREADWRITE, dbiOPENSHARED,

                               NULL, 0, NULL, NULL, phDb));

   if (rslt != DBIERR_NONE)

      return rslt;

   rslt = Chk(DbiSetDirectory(*phDb, Directory));

   return rslt;

}

 

Example 3: Open a remote database with alias and password..

This example uses the following input:
         fDbiOpenDatabase3(&hDb, "MyAlias", "MyPswd");

DBIResult fDbiOpenDatabase3(phDBIDb phDb, pCHAR alias, pCHAR password)

{

   DBIResult    rslt;

   rslt = Chk(DbiOpenDatabase(alias, NULL, dbiREADWRITE, dbiOPENSHARED,

            password, 0, NULL, NULL, phDb));

   return rslt;

}

Example 4: Open a remote database with a different user name than what is specified on the alias.

This example uses the following input:
         fDbiOpenDatabase4(&hDb, "IBPerfect", "USER1", "password1");

DBIResult fDbiOpenDatabase4(phDBIDb phDb, pCHAR alias, pCHAR UserName, pCHAR password)

{

   FLDDesc      UserNameDesc;

 

   memset(&UserNameDesc, 0, sizeof(UserNameDesc));

   UserNameDesc.iOffset = 0;

   UserNameDesc.iLen = (UINT16)(strlen(UserName) + 1);

   strcpy(UserNameDesc.szName, "USER NAME");

   return Chk(DbiOpenDatabase(alias, NULL, dbiREADWRITE, dbiOPENSHARED,

            password, 1, &UserNameDesc, (pBYTE)UserName, phDb));

}