RegEx search with a DB?

S

Stilgar

New member
Joined
Jun 28, 2005
Messages
3
Hi,

Im coding a desktop application to virtualy view articles of an institue, and allow for saving bookmarks and searching. Currently, Im 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 (Im 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 youd use? Ive been thinking on creating a search thread to load the text from the DB and run .NETs 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.
 
You can find the answers with these two searches in Google

1. Sql Server regular expression
2. Oracle regular expression
 
No, I actualy couldnt. Im currently using MS-Access as the beckend DB, and unless youd 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. Im not a newbie, really, I just havent had such a need before with MsAccess.

Stilgar.
 
Does that SQL Server add-on work with MSDE? If so, that might be your best bet. I dont know for sure but I doubt that functionality does exist for Access.
 
I guess I could check, but MSDE wont 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 its server application. Am I wrong here?

Stilgar.
 
Back
Top