Hi,
i need to read some old DBISAM tables (version 3.00 format) using .NET C#; i tried with 4.33 but it can't open the tables, so i installed the 3.30 version (configuring the DNS via C:\Windows\SysWOW64\odbcad32.exe), and i finally succeded to access them.
The problem is that reading the records is really slow (like 5 second to read 10 records); i tried the same application on a windows XP machine and it worked fine.
Is there any compatiblity issue between version 3.30 and windows 7?

Hi Rizzoli,

I am using some DBISAM version 3 tables with Windows7 (64 bit) and I
have no speed problem via the ODBC driver.
What are you using to read the tables?

Chris Holland [Team Elevate]

On 10/07/2012 11:06, Rizzoli wrote:
> Hi,
> i need to read some old DBISAM tables (version 3.00 format) using .NET C#; i tried with 4.33 but it can't open the tables, so i installed the 3.30 version (configuring the DNS via C:\Windows\SysWOW64\odbcad32.exe), and i finally succeded to access them.
> The problem is that reading the records is really slow (like 5 second to read 10 records); i tried the same application on a windows XP machine and it worked fine.
> Is there any compatiblity issue between version 3.30 and windows 7?
>

This is the code i used for my test :

        try
        {
           string queryString = "SELECT * FROM FOR_BlackBox";
           OdbcCommand command = new OdbcCommand(queryString);

           string connectionStg = "DSN=TestDBIsam;UID=admin;PWD=;";

           using (OdbcConnection connection = new OdbcConnection(connectionStg))
           {
              command.Connection = connection;
              connection.Open();
              OdbcDataReader reader = command.ExecuteReader();

              DateTime st = DateTime.Now;
              int fCount = reader.FieldCount;
              while (reader.Read())
              {
                 for (int i = 0; i < fCount; i++)
                 {
                    Console.WriteLine(reader.GetValue(i).ToString());
                 }
              }
              DateTime end = DateTime.Now;
              TimeSpan ts = end - st;
              MessageBox.Show(ts.TotalSeconds.ToString());

              reader.Close();
              command.Dispose();
           }
        }
        catch (Exception ex)
        {
           MessageBox.Show(ex.Message);
        }

Am i doing something wrong?

I am having the same problem!

PS: I'm using the trial version (if it matters)

UPDATE: I've tried to run the same test program on a Wiondows 7 Virtual Machine and it seem to work fine, same speed as Windows XP; for further confirmation i've also tried on my colleague's PC and again it works with no problem... So is something wrong with my PC, but i can't figure what...

Rizzoli,

<< UPDATE: I've tried to run the same test program on a Wiondows 7 Virtual
Machine and it seem to work fine, same speed as Windows XP; for further
confirmation i've also tried on my colleague's PC and again it works with no
problem... So is something wrong with my PC, but i can't figure what... >>

I would verify that you don't have any AV software actively scanning the
DBISAM table files.  That could cause an issue like this.

If you have any other questions, please let me know.

Tim Young
Elevate Software
www.elevatesoft.com