The database is created using a Windows software (Delphi language) which
uses Paradox database. A special module is used to prepare some data from
this database for internet. The program uses "libmySQL.dll" and would
connect directly to server via a dialup line. Instead 'localhost' it would
have the server's IP. It then updates the Mysql database with new data. This
Mysql database is then used only for reading and PHP scripts on homepage
take care of that. I am just wondering if anyone has ever done this and are
there any problems (firewalls...)?
Thanks,
Marko.
""Beau Lebens"" <[EMAIL PROTECTED]> je napisal v sporocilo
[EMAIL PROTECTED]">news:[EMAIL PROTECTED] ...
> if the computer where the writable copy of the database is stored is
> permanently connected to the other one, then you could just create a new
> user for that database using mysqls security features which only has
access
> to read information, no change or delete.
>
> and yes you can connect using an ip, to any database which allows external
> connections (firewalls etc notwithstanding)
>
> // -----Original Message-----
> // From: Marko Lesnik [mailto:[EMAIL PROTECTED]]
> // Sent: Monday, 30 April 2001 10:40 PM
> // To: [EMAIL PROTECTED]
> // Subject: [PHP-DB] Updating Mysql database from a remote computer
> //
> //
> // The database will be created on a local computer and it only
> // needs to be
> // transferred to the server (it's a read-only database when it's
> // on the net).
> // The problem is that the database itself isn't located in
> // directory, where we
> // could access it with Ftp client and simply owerwrite it with the new
> // version.
> // Is it possible to connect via a IP number instead
> // 'localhost' like this:
> // mysql_connect("100.10.20.30","username","password")
> // and then update record by record. It should be slower but our
> // main interest
> // is to get the data to server. Are there any free servers where
> // this can be
> // tested?
> //
> // Thanks,
> // Marko.
> //
> //
> //
> // --
> // PHP Database 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]
> //
>
>
> --
> PHP Database 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]
>
--
PHP Database 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]