[RESOLVED] DB Selection

[LakshmiP]

Hi

We are going to develop windows application(VB.NET) for Articles full text search .

Client is going to distribute this application through CD-ROM.

Actually my doubt is which database is good for this application?

This database can’t install in user system it will access from CD-ROM only?

Please Guide me any one. Thanks for any Help

[Krishnaa]

I guess MS-Access would be perfect here, if you try to use any other, you will have to first load it in DB and then use it, which is not so good considering that MS-Access files can be used as DB just like that, simply create the connection string with proper path.

[davide++]

Well, it depends on which kind of application you're going to develop.
If the application is a mono-user program with a little amount of data to manage, I agree with Krishnaa, Access is the best choice.
If the application is a multi-user system and it have to process a large set of data probably you should consider other products, for example Sql Server (that is more complex of course)

[Krishnaa]

With SQL server, you will have to load the DB file into SQL server first, without that you can not make connections, that was the only point I wanted to convey. :)

[LakshmiP]

Thanks for ur replies.

its not small amount of data.and this application is mono-user purpose only ,who have the CD-ROM they only execute the application.

"This database can’t install in user system it will access from CD-ROM only"

at that time also we can go for SQL SERVER?

what about flatfiles(textfiles) is it good?

[Krishnaa]

Flatfiles would be the worst, but if your application do not demand performance over read then it's alright. Why not use MS Access MDB file ?

[LakshmiP]

Actually I’ve doubt if user system doesn't have MS Access, it will work?

(my system have OpenOffice.org 3.0)

[Krishnaa]

You do ODBC, MS Access as an installed application is not needed.

[LakshmiP]

Thank u Krishna.

I’ll go for MS Access.

Thanks once again.