Mission: access a WinDev DB through ODBC from a C# Web Service
Steps:
- download the ODBC drivers from windev: http://www.pcsoft.fr/st/telec/modules-communs-11/wx11_54b.htm;
- decompress the ZIP-encoded installer (twice) like this: http://www.vbfrance.com/infomsg_WINDEV-VB_34754.aspx;
- copy the DLL files to "%winroot%\system";
- manually create the ODBC driver in the registry like this: http://www.developer.com/db/print.php/3712461. Don't forget to also create an entry in the "CustomDriver" key under "HKEY_LOCAL_MACHINE\Software\ODBC\ODBCINST.INI\ODBC Drivers". The DLL to use in the registry is "WD110hfo.dll";
- create a DSN in the ODBC control panel using the newly created driver;
- in your code, use the traditional OdbcConnection object to use the DSN created above;
This should be it ;-)
Thanks WinDev for making our work so complicated...
6 comments:
Thanks for the tip! Only one problem: the access is read-only, any idea what could be the reason?
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.
Good article, one question though: where and how can you specify the password?
In our case, there was no password... Did you try using the "PWD=..." tag in the ConnectionString?
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
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
Post a Comment