Friday, January 4, 2008

Access a WinDev/HyperFile DB from ASP.Net

I spent some time figuring this out, so this might be useful to someone else...

Mission: access a WinDev DB through ODBC from a C# Web Service

Steps:

This should be it ;-)

Thanks WinDev for making our work so complicated...

6 comments:

google said...

Thanks for the tip! Only one problem: the access is read-only, any idea what could be the reason?

Frédéric Mauroy said...

Indeed, it is 'by design', as far as I know. In our case it was not a problem, but it may in other scenarii...
I haven't heard about PCSoft making a read-write version of their ODBC driver, so I guess you are out of luck on this one.

Stijn Verrept said...

Good article, one question though: where and how can you specify the password?

Frédéric Mauroy said...

In our case, there was no password... Did you try using the "PWD=..." tag in the ConnectionString?

unpeudetoutmontreal said...

Hi Frédéric, I just found this blog googling but just be sure and understand it as well I would like to explain you what I really need:

I have an ASP.NET/Visual Basic Framework 4.0 web page and I need to get data from HyperFile DB and show it on my web page.

Does it work for me? It's the first time I'm going to do something like this, i'm a little bit lost.

Thank's in advance.

Christian

Frédéric Mauroy said...

Hi Christian,

yes, what we did is basically the same thing you are trying to do.

Remember that the connection is read-only, so as long as you don't attempt to add data to the DB, you'll be fine.

Cheers
fred