| View previous topic :: View next topic |
| Author |
Message |
timbo
-
Joined: 06 Aug 2003
Posts: 9
Location: external web server
|
 Posted: Thu Sep 18, 2003 4:36 am Post subject: Accessing an outside mysql database |
 |
|
Does ayone know the code to access an outside database. I have my site on an outside service but when calling the database for iformation, I would like to have it access the database on my computer running mysql and abyss.
In ohter words the script would be on host.domain and when ran it would have to go to my.domain to access the database.
Thanks |
|
| Back to top |
   |
 |
aprelium
-
Joined: 22 Mar 2002
Posts: 6800
|
| Posted: Fri Sep 19, 2003 3:56 pm Post subject: Re: Accessing an outside mysql database |
|
|
When linking to a database in a script, you usually supply its location. Instead of "localhost", put your computer's IP or DNS.
_________________
Support Team
Aprelium - http://www.aprelium.com |
|
| Back to top |
 |
|
timbo
-
Joined: 06 Aug 2003
Posts: 9
Location: external web server
|
| Posted: Fri Sep 19, 2003 11:31 pm Post subject: Accessing an outside mysql database |
|
|
I went and changed mysqlhost form localhost to domain ip address.
When I tried it I got this :
Software error:
install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC (@INC contains: D:/Abyss Web Server/Scripts/lib D:/Abyss Web Server/Scripts/site/lib .) at (eval 5) line 3.
Perhaps the DBD::mysql perl module hasn't been fully installed,
or perhaps the capitalisation of 'mysql' isn't right.
Available drivers: ExampleP, Proxy.
I checked the installtion of mysql and it follows exactly as laid out i the tutorial. One problem is I can't find the mysql.pm file anywhere on my machine.
HEEEEELP |
|
| Back to top |
|
|
aprelium
-
Joined: 22 Mar 2002
Posts: 6800
|
| Posted: Mon Sep 22, 2003 12:49 am Post subject: Re: Accessing an outside mysql database |
|
|
This is a Perl error meaning that DBD::mysql module is missing. You'll have to install it or ask the system admin for that.
_________________
Support Team
Aprelium - http://www.aprelium.com |
|
| Back to top |
|
|
timbo
-
Joined: 06 Aug 2003
Posts: 9
Location: external web server
|
| Posted: Tue Sep 23, 2003 1:07 am Post subject: |
|
|
| where do I get this module. I have been all over mysql.com and canot fid it anywhere. |
|
| Back to top |
|
|
aprelium
-
Joined: 22 Mar 2002
Posts: 6800
|
| Posted: Tue Sep 23, 2003 4:09 pm Post subject: |
|
|
| timbo wrote: | | where do I get this module. I have been all over mysql.com and canot fid it anywhere. |
This module is a Perl module. You can get it from http://www.cpan.org .
_________________
Support Team
Aprelium - http://www.aprelium.com |
|
| Back to top |
|
|
|
