Working with DBISAM Using Microsoft .NET: ASP Alliance

Print Add To Favorites Email To Friend Rate This Article
Working with DBISAM Using Microsoft .NET

page 4 of 7

by Bhuban Mohan Mishra
Feedback

Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 47654/ 71

Article Contents:

Working with DBISAM

After knowing a bit about database structure, let us put our hands on the programming part with relation to .NET. As every database has accepted SQL as the standard language for querying, so too has DBISAM. We do not need to worry about syntax; our same old concept on SQL will work fine here. Now to connect to the DBISAM Database from our application, we need the DBISAM ODBC driver. It is an ODBC level 3 driver. The driver works with Microsoft Data Access Components (MDAC) version 2.7 or higher and many other applications including .NET Applications.

Missing Features

There are still a few things missing from the driver like support for bulk operations and a few ODBC extended scalar functions (UNION, INTERSECT, LIKE, etc).

Using ODBC Driver

To use the ODBC Driver we can either setup a DSN which we access from our application or can directly access the database through a connection string from our application.

« (Page 3)

View Entire Article

(Page 5) »

User Comments

Title: Re: new extension db4
Name: Bhuban M Mishra
Date: 2008-03-24 11:56:12 AM
Comment:
Hi Nicola,

I went through the Eleviate Software site, but I did not found the details about .db4 files. Might be they have not updated the details of the new version.

According to the following link,
http://www.elevatesoft.com/manual?action=mantopic&id=dbisam4&product=b&version=2005&category=1&topic=1

It says that the files still have .dat extension. I do not have access to the latest DB. I think, the way .dat files are accessed, the .db4 files can also be accessed in the same manner.

If possible, you can search for the updated drivers if available for the db4 files.

Thanks,
Bhuban

Title: new extension db4
Name: Nicola
Date: 2008-03-14 6:21:54 AM
Comment:
Hallo! i have new version dbisam with new versione.. extension file data is .db4 and not .dat... can u help me?? with new versione.. i want use this code..
thank u soo much
nicola

Title: GOOD ARTICLE
Name: ADAM
Date: 2007-07-16 12:29:55 PM
Comment:
I looked for a few hours about information about some unkown database file types I had and didnt find anything until I found this article. This article and the help it provided is greatly appreciated. Thanks.

Title: Re: Where do I find DBISAM ODBC Driver?
Name: Bhuban
Date: 2006-11-03 9:00:08 PM
Comment:
The ODBC Driver provided by Elevate Software is the only driver available as per my knowledge. I have also used the same. As per your problem is concerned, each table that has BLOB fields must have a .blb file which remains in the same folder as the table. Though I have not worked with BLOBs, there are certain DBISAM viewers available that shows the structure and data in the tables. You can use one of them to check whether the data in the BLOB field is intact.

Title: Where do I find DBISAM ODBC Driver?
Name: TLR
Date: 2006-11-03 10:30:48 AM
Comment:
I have found one ODBC Driver from Elevate Software, but it seems to choke whenever I try a select that includes a BLOB column. Can you recommend some other ODBC Driver?

Title: Very Informative Article
Name: Prasanjit Ahuja
Date: 2006-10-06 5:23:33 AM
Comment:
Very Informative article. Keep it up.

Title: Panda
Name: Supriti
Date: 2006-10-05 11:10:09 AM
Comment:
Hi,
Thanks for the information about a new database.This may be helpful for me in future.

Title: Working with DBISAM Using Microsoft .NET
Name: Himanshu Sahoo
Date: 2006-10-03 6:18:10 AM
Comment:
Nice Article.Well done.