[RESOLVED] connecting to NON LOCALhost

mrjoeblack

what if i want to pass data from a webpage on one server to an sql database on another server?? NOT therefore the localhost. How would I script that??? in the connection?

Derokorian

change localhost to the address of the sql server... after all that's why the host parameter exists - to specify a host!

mrjoeblack

hhmmm yeessss I thought I'd done that tho and it errored. can you give an example of what a server address might look like. Do I need to make the originating server a user on the dbase? The error seemed to deny access to the domain.

jeepin81

remote access might not be enabled. what error are you getting and what type of database is the remote database you're trying to connect to?

here's an example of a recent attempt I tried - the database db2 w/ remote access enabled:



$server = "xxxxx";
$db = "xxxxxxx";
$user = "xxxxxx";
$password = "xxxxxxx";

$conn = odbc_connect($server,$db,$user,$password)
			or die("connect error: ". db2_conn_errormsg());

jeepin81

also the server address could be the domain name, local ip or public ip - depending were the server is located.

examples:
- yourdomain.com
- 10.1.1.2
- 60.60.60.125

mrjoeblack

 $server = "xxxxx"; 
$db = "xxxxxxx"; 
$user = "xxxxxx"; 
$password = "xxxxxxx";

Jeepin thanks for that, ok maybe I had something in the script wrong here.

I had, $localhost=something.blablabla.com ... it should be server right??

I have to go try that now.

johanafm

mrjoeblack;10996962 wrote:
and it errored

jeepin81;10996963 wrote:
what error are you getting?

You might want to actually start by providing your error messages, not just stating that you have them. And you also might want to at least provide these messages when someone is kind enough to ask for them.

mrjoeblack;10996966 wrote:

I had, $localhost=something.blablabla.com ... it should be server right??
[/QUOTE]
Personally I wouldn't use $localhost for anything other than ... localhost.

mrjoeblack

sorry if I haven't done things correctly ... I didn't actually get any error messages, where would I find those???

mrjoeblack

ok had another look and found this error:

databaseAccess denied for user 'domain'@'localhost' (using password: NO)

here's the script I'm using now, I've xxx out the detail, but no luck so far...

<?php
$server="mysql2.**********.com";
$username="xxxxxxxx";
$password="xxxxxxxx";
$database="xxxxxxxxxx";


mysql_connect($server,$username,$password);
@mysql_select_db($database) or die( 'Unable to select database' . mysql_error());

?>

jeepin81

according to the error the user you're attempting to log in with doesn't have permission.

I would look into that as my next step.

bradgrafelman

In addition, the error seems to suggest that you attempted to log in without providing a password. Thus, I would ask how well the above code snippet represents what your code actually looks like.

mrjoeblack

The code above works perfectly when the database resides on the same domain as the php script, it is only when I tried to have the data from the form sent via the php to be inserted into a dbase residing at another domain location, the deny error happens.

I should say, I used $localhost instead of $server when php and dbase are in the same place and that's works good.