John,
thanks for the link, but isn't it a bit of overkill in my case?
What I need is to write PHP pages which manipulate a MS Access DB
via ODBC, because this is what the hosting company makes available
(and it's not going to change because of several reasons)
So, I am looking for explanation on how to do ONLY the testing
of suche pages on a STAND-ALONE Linux box. I want to run some DB
engine on it which is accessible through ODBC, so that I can
say "if my ODBC call was OK here, it will work also when I upload
on the NT/IIS server, because the interface is the same".
Keep in mind that performance is not an issue here. On the linux
PC I would only do testing, and the site on the real server currently
has ~4000 visits/month querying a DB with some hundreds of entries.
What do you think?
mweb
On Sat, Nov 10, 2001 13:02:14 at 01:02:14PM +0800, John Lim wrote:
> See http://php.weblogs.com/adodb_csv
>
> "ADODB also supports SQL communications through HTTP as a database proxy. In
> plain English, if you have a FoxPro or Access database that you need to
> connect to from Unix, you can do so via HTTP (eg. Apache talking to IIS,
> which talks to a small PHP program [the proxy] that queries the database,
> packs it into serialized text and sends it back to Apache).
>
> PHP client -- Apache ------------ IIS -- PHP server -- Database
>
> Or if you have to go through a firewall to access your database, this
> solution allows you to stream SQL queries as HTTP through the firewall."
>
> [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote in message
> GMJD1G$[EMAIL PROTECTED]">news:GMJD1G$[EMAIL PROTECTED]...
> Hello,
>
> For reasons not worth discussing here, I have to develop and test on
> Linux/Apache some PHP pages that will have to access via ODBC a MS Access
> database on an NT/IIS/PHP server.
>
> I would like to do it by writing PHP pages that access via ODBC
> some mysql or other database on my linux box, in such a way that,
> if it works there, I just change some general setting, upload the pages
> and they work for sure on the MS Access thing (something like:
> ifdef LINUX then ODBC_ACCESSES_MYSQL
> ifdef NT then ODBC_ACCESSES_MS_Access)
>
> I am sure that this must be possible, but would really appreciate some
> examples/pointers to specific tutorial/similar stories/etc.
>
> TIA,
> mweb
>
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
Never let your sense of morals prevent you from doing what is right
Salvor Hardin , "Foundation"
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
