RegEx search with a DB?

[Stilgar]

Hi,

 

I'm coding a desktop application to virtualy view articles of an institue, and allow for saving bookmarks and searching. Currently, I'm using an Access DB as the beckend DB, which where all data is taken from. To make a long story short, I need to allow my users to use advanced search properties, and the best way to programmatically do this is using RegEx, of course. Problem is, there seems to be NO support for RegEx with Access (I'm using 2000 format), and the LIKE command allows for a very limited filtering of content. My question is divided into 3 parts:

 

1. Is there an Add-On I can install to make the search using RegEx possible? It is with MsSQL and MySQL...

2. Can I use some other DB to make such search possible? For example, can I 'mount' a MySQL DB on a disc and work with it?

3. If both questions are answered as no, what would be the best solution you'd use? I've been thinking on creating a search thread to load the text from the DB and run .NET's regex object on each row, or maybe using XML. Both ways are too slow, considering it should load from a CD...

 

Most important: Whatever solution is advised, it should be easy for installation and use. The ppl using this app may not have much knowledge on computers.

 

Thanks in advance,

Stilgar.

[michael_hk]

You can find the answers with these two searches in Google

 

1. Sql Server regular expression

2. Oracle regular expression

[Stilgar]

No, I actualy couldn't. I'm currently using MS-Access as the beckend DB, and unless you'd recommend moving to another DB, I will need to find a solution related to Access, and not Oracle or MsSQL. Just to make sure, I rolled those searches, and nothing related came up. I'm not a newbie, really, I just haven't had such a need before with MsAccess.

 

Stilgar.

[jmcilhinney]

Does that SQL Server add-on work with MSDE? If so, that might be your best bet. I don't know for sure but I doubt that functionality does exist for Access.

[Stilgar]

I guess I could check, but MSDE won't really help. I need the DB to be a file which I can put on a disk and connect to easily, without having to install a server application in order to use it with my desktop app. AFAIK MSDE is not really helping here, as it does require an installation of it's server application. Am I wrong here?

 

Stilgar.

[FZelle]

That's correct, you need to install the Serversoftware.

 

But if you use FireBird than you can use the embedded server, and than

it's as easy to use as Access but as powerfull as the big Servers.

 

http://www.dotnetfirebird.org/embedded/