![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM ODBC Driver » View Thread |
Messages 1 to 7 of 7 total |
![]() |
Tue, Jul 10 2012 6:06 AM | Permanent Link |
Rizzoli | 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? |
Tue, Jul 10 2012 7:55 AM | Permanent Link |
Chris Holland SEC Solutions Ltd. ![]() | 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? > |
Tue, Jul 10 2012 8:07 AM | Permanent Link |
Rizzoli | 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? |
Tue, Jul 10 2012 9:58 AM | Permanent Link |
Alexandre Luis Mancini | I am having the same problem!
|
Tue, Jul 10 2012 10:02 AM | Permanent Link |
Rizzoli | PS: I'm using the trial version (if it matters)
|
Wed, Jul 11 2012 4:12 AM | Permanent Link |
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...
|
Thu, Aug 2 2012 3:05 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | 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 |
This web page was last updated on Wednesday, August 14, 2024 at 03:12 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |