My application supports Access, SQL Server, MSDE and oracle.
Some porion of code is in VB
and some of it is in C.
For C I am using ODBC calls to make entries in the database.
i am using ADO.
In case of oracle, SqlServer, MSDE there is no problem but in case of
Access ODBC calls seems to be slow. See the following code
See the following piece of code
// at_DB_insert uses ODBC calls to insert data in database
// Adding data through vc
if (at_DB_insert (pDbHandle, AT_PROJECTDB_DOCREG_TABLE, m_pDocData) == AT_DB_SUCCESS)
// GetDocIDFromFileName is written in VB
and using ADO
// We now want to read the entry made in database through VC above
// Try to read it through VB
. In case of oracle it takes less
// then a second but in case of Access it takes 3-6 seconds.
while (!(pDocID = GetDocIDFromFileName (documentFileName)))
Sleep (500) ;
Any help is appreciateable.