Connection error non-www versus www

domain is 62ndcacrc.com
my connection code is<?php
# FileName="Connection_php_mysql.htm"
# Type="MYSQL"
# HTTP="true"
$hostname_connadmin = "localhost";
$database_connadmin = "database_name";
$username_connadmin = "myusername";
$password_connadmin = "mypassword";
$connadmin = mysql_pconnect($hostname_connadmin, $username_connadmin, $password_connadmin) or trigger_error(mysql_error(),E_USER_ERROR);
?>

when i go to url www.62ndcacrc.com, i have no problem
when i go to url 62ndcacrc.com i get an error
Warning: mysql_pconnect(): Access denied for user 'hostjb_rollieh'@'localhost' (using password: YES) in C:\vhosts\62ndcacrc.com\Connections\connadmin.php on line 9

you should contact your host to determine why the connection works with the www domain but not without. this isn't a code problem but a server setup problem, the host will be able to help with that.

the only suggestion I would be able to makes to use mod rewrite to force the www address:
http://www.htaccessbasics.com/force-www-nonwww-domain/

Thanks Jason, it was actually on my pc where i had placed duplicate entries for www and non-www in my local apache bin and also in my system32 drivers.

Please see private message

Instead of Creating a standard DW Connection, use Dynamic Connections.

the Dynamic Connection tool allows you to create one connection, and specify the local information and the remote information and it will connect to the correct server based on the address.

see private message

Do you have Data bridge installed?

if so when you go to the Database tab to create a new Database connection, choose the option to use the Dynamic MySQL connection.

in the Dynamic MySQL connection, you will be able to specify the local server details on the initial tab, then on the Additional Servers tab, you can specify the remote server details.


If you don't have Data Bridge / Dynamic Connections, then the next best thing is to upload the connection with the remote details to the server, then use file villa or another FTP program to access the server and set the Connection file on the server to be read only.

now you can set the connection in DW up for the local server, and the next time it tries to upload the local details, it won't be able to because it is read only on the server.

Great, Jason!
I had not used the dynamic connection that way, duhh!
I had used a work around with a connection for local and another connection for remote.
This will save me a tremendous amount of time.

see private message

you're welcome

Thanks, Jason.