Im about to be fired!!!!

Bananna man

Ok,

I have s script that works fine on my testing server but i have now loaded it up to the remote server and i cant seem to connect to the database. The script i am using is the same as other scripts i have used and they work fine.

The error im getting is:

Warning: mysql_query(): Access denied for user 'ODBC'@'localhost' (using password: NO) in \hosting\washtec.ie\httpdocs\washtec_scripts\transact_user_upload_job.php on line 13

Warning: mysql_query(): A link to the server could not be established in \hosting\washtec.ie\httpdocs\washtec_scripts\transact_user_upload_job.php on line 13
Could not look up user information; Access denied for user 'ODBC'@'localhost' (using password: NO)

The database connection script is:
[PHP]<?php

define('SQL_HOST','localhost');
define('SQL_USER','username');
define('SQL_PASS','password');
define('SQL_DB','database_name');

$conn = mysql_connect(SQL_HOST,SQL_USER,SQL_PASS)
or die('Could not connect to the database; ' . mysql_error());

mysql_select_db(SQL_DB,$conn)
or die('Could not select database; ' . mysql_error());

?>[/PHP]

The hosting company are saying its a problem with my code but i cant see how seeing as how its the same script im using on my testing server and other sites that work fine.

Has anyone got any ideas?

Bananna man

Got it sorted, 5 hours later. The bloody file reuest was pointing to the domain url instead of pointing to the folder with a ../ infront of it. Why this makes a difference i dont know!!!!

Gordon

Freelance job or full time job?

Bananna man

Gordon wrote:

Freelance job or full time job?

Freelance. i was being melodramatic when i said i was going to be fired but i was getting it from all angles. Anyway, alls well that ends well.

Adam

As long as you get the money man, who gives a f*ck?!

tom-thebox

fade_to_grey wrote:

As long as you get the money man, who gives a f*ck?!

hehe, i like it

rsynnott

fade_to_grey wrote:

As long as you get the money man, who gives a f*ck?!

That's, erm, a dreadful attitude.