Alright guys, this is probably a really stupid question. Rough day trying to find solutions for this. This is what I need...
I have several mdb's sitting in a directory in apache. I want phpCodeGenie to have at it. I load it up and I don't see Access on the list. I obviously haven't worked with doing database stuff before. Can someone PLEASE point me in the right direction? I really hope this forum isn't defunct. I know I'm missing something.
Thanks in advance.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Try to be a little bit more descriptive ... you are trying to see your database and tables via PCG? This is an Access database? What is your set-up like?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
-
2005-06-29
Okay, I'm running a Fedora Core 3 Box. My boss was previously depending on some bunk ASP making program. Now that we're doing our hosting ourselves and using Linux, and don't want to pay for the commercial ASP support, I thought of converting to PHP. The original databases were stored using Access on our local Windows machines. Then he'd run ASPMaker (the program we used) to generate the code then upload the directory to the old server.
So now I found phpcodegenie and it says it can read Access databases. What are the steps I need to take to have PCG generate code from the access databases? Or even, how do I get PCG to SEE the databases? Thanks!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
How big are your tables? Since you're running Linux have you guys thought about switching out to MySQL or Firebird? Both would seem a logical choice and depending on the size of the company, it may scale much better in the long run.
But back to your point - You may want to try the ODBC option. If you were to decide to convert to MySQL, you should be able to export your data to CSV - if not you can export a table to Excell. From there you can export a CSV and then upload the file through MySQL. Just stack out your field names in the top row.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Alright guys, this is probably a really stupid question. Rough day trying to find solutions for this. This is what I need...
I have several mdb's sitting in a directory in apache. I want phpCodeGenie to have at it. I load it up and I don't see Access on the list. I obviously haven't worked with doing database stuff before. Can someone PLEASE point me in the right direction? I really hope this forum isn't defunct. I know I'm missing something.
Thanks in advance.
Try to be a little bit more descriptive ... you are trying to see your database and tables via PCG? This is an Access database? What is your set-up like?
Okay, I'm running a Fedora Core 3 Box. My boss was previously depending on some bunk ASP making program. Now that we're doing our hosting ourselves and using Linux, and don't want to pay for the commercial ASP support, I thought of converting to PHP. The original databases were stored using Access on our local Windows machines. Then he'd run ASPMaker (the program we used) to generate the code then upload the directory to the old server.
So now I found phpcodegenie and it says it can read Access databases. What are the steps I need to take to have PCG generate code from the access databases? Or even, how do I get PCG to SEE the databases? Thanks!
How big are your tables? Since you're running Linux have you guys thought about switching out to MySQL or Firebird? Both would seem a logical choice and depending on the size of the company, it may scale much better in the long run.
But back to your point - You may want to try the ODBC option. If you were to decide to convert to MySQL, you should be able to export your data to CSV - if not you can export a table to Excell. From there you can export a CSV and then upload the file through MySQL. Just stack out your field names in the top row.