Hi,
I'm used to developing in the PHP/MySQL platform. But a client has come to me recently with a strange development oppurtunity. Not only will I need a backend with it's own database, I need to fetch information from an Access database and a Progress database.
I was intending on using MySQL for the backend of the software, but considering Access is set up, I might just use an Access database.
I've read in to progress a little (I hadn't heard of it before), but it still confuses me a little, It seems to be more than just a database (suchas MySQL is). So if anyone could give me a brief explanation there, that would be great, especially how it is used in an ODBC connection. I know they have some internal application for accessing the database too - hopefully this won't conflict.
At the moment I'm thinking, a few things. Firstly, will the SQL be the same for Access and Progress and MySQL? Or does it differ? If I'm using ODBC that is going to save me time as far as doubling up on different coding (once more reason to dump MySQL for this project).
Any advice would be much appreciated.
Spode
I'm used to developing in the PHP/MySQL platform. But a client has come to me recently with a strange development oppurtunity. Not only will I need a backend with it's own database, I need to fetch information from an Access database and a Progress database.
I was intending on using MySQL for the backend of the software, but considering Access is set up, I might just use an Access database.
I've read in to progress a little (I hadn't heard of it before), but it still confuses me a little, It seems to be more than just a database (suchas MySQL is). So if anyone could give me a brief explanation there, that would be great, especially how it is used in an ODBC connection. I know they have some internal application for accessing the database too - hopefully this won't conflict.
At the moment I'm thinking, a few things. Firstly, will the SQL be the same for Access and Progress and MySQL? Or does it differ? If I'm using ODBC that is going to save me time as far as doubling up on different coding (once more reason to dump MySQL for this project).
Any advice would be much appreciated.
Spode