Hi Simon

Straight from their site:-

"NOLOH facilitates connections to all major commercial and open-source databases and encourages developers to modularize their data handling and has streamlined support for calling views, stored procedures, and prepared statements.

NOLOH has native classes for connecting to MySQL, PostgreSQL, DB2, MSSQLServer, Oracle, and any other ODBC connection. Furthermore, NOLOH can connect to databases other than these using the corresponding PHP (e.g, ADOdb), C, or a native driver for an otherwise unsupported database."

and a couple of links to articles about their database stuff:-

http://www.noloh.com/Docs/#/section=articles&article=Databases
http://www.noloh.com/Docs/#/section=articles&article=Data%3A%3A%24Links

The database side of things is not a million miles away from ADO.Net inasmuch as, there a quite a few similarly named classes that have parity with their namesakes in ADO.Net. In my case, I am talking to the database using stored procedures but you can use straight SQL commands if you like.

I have talked to the NOLOH developers in the past about VFP and they certainly weren't averse to considering the idea of making NOLOH Fox-data "aware". The main reason I did this was because my experience using NOLOH reminded me a lot of my Fox experience. Obviously, the PHP syntax is C-like so, after using C# and JavaScript, I found PHP syntax quite intuitive. But, the NOLOH guys originally discouraged me from learning too much PHP so as to not muddy the experience with NOLOH. As long as you have a reasonable understanding of OOP, it is fairly easy to get to grips with NOLOH.

HTH


>Hi Gary
>
>Thanks for the information about NOLOH. Do you have any experience with the database side of things with this product if so would you care to share some strengths/weaknesses.
>
>Simon
>
>
>>>It sounds really interesting indeed.
>>
>>It is a very interesting product.
>>
>>>But why using this versus NET, in which you already invested quiet a bit of time, and have been presummably sucessfull ?
>>
>>I am building a SaaS product and using open source technologies, hosting costs are cheaper as I would not be paying to licence Windows server, SQL server and so on.
>>
>>I have never liked ASP.Net. Silverlight is very new and it is a plugin, like Flash (I am not keen on proprietary plug-ins). I really like the idea of the open web, web standards and I think that Ajax has really matured in recent times. There are loads of excellent Javascript libraries and what with the browser vendors constantly trying to out-do each other with fast and faster Javascript execution, the future has never looked better for fat-client/thin-server type JS applications. NOLOH is a tremendous balance of both. Ajax right out of the box without doing anything but balanced usage of server side technology too. Very secure and a really nice development workflow with everything in one language. So, you don't have to worry about HTML, JS, CSS - you just design your application in an object oriented fashion and NOLOH takes care of the rest. Of course you can become more granular and low level if you want but if you haven't too much experience with web technologies, you are insulated from the complexities.
>>
>>I find PHP to be straightforward to use and with the NOLOH OOP approach, you only need to know a little bit of PHP. The OOP structure of NOLOH is not a million miles away from VFP.
>>
>>Well worth checking out.
>>
>>>Why change ?
>>
>>Why not! :)