The example in the manual and video are for localhost connections. I'm looking for an example of a remote host. I have set up connection files in the past and yet the database connection info I am entering brings up an error screen. Thanks.

Hello Hope,

There is no difference if you connect to a local server or a remote one.
Please provide the exact error message you are seeing? Are you sure you are using the right login detailes, provided by your hosting provider: ip/port/user/pass?

I am using exactly the same information that I use in the connection file (which is working) for this same database.

The error is: SQLSTATE[HY000][2002] php_network_getaddresses: getaddinfo failed. This is usually a temporary error during hostname resolution and means that the local server did not receive a response from an authoritative server.

When I use localhost the setup is OK.

What is your PHP version? Do you have PDO installed/enabled on your server?

Please create an info.php file with the following code inside it:

<?php phpinfo(); ?>

Then send us a link to this page.

Thank you so much. It turned out that my webhost did not have PDO enabled for my server. Now that it is enabled, the connector worked perfectly on one of my server.

Unfortunately on a second server which is set the same, it did not.
Both info.php listings show the "with-pdo-mysql" listed under the Configure Command. Both servers are using PHP Version 5.3.13

Where should I send the info.php file? Don't really want to post it publicly

Please send the link to

This reply was removed on 9/27/2013 4:25:50 PM.
See the changelog

Both my connections work correctly for localhost. They now both have PDO enabled, as can be seen in the info.php files.

I am still unable to create a database connection.
By the way, I am able to use the HTML Data Bindings successfully with a Public Feed.

Any suggestions of what to try next?

Hope

Please describe your problem a little more detailed - what do you mean by:
"I am still unable to create a database connection. " ?
Are there any error messages? Are you sure you upload all of the files to your remote/testing server when you create the connection?

When I try to create the database connector and fill in the screen with the appropriate server address, database, username and password, and then click test connection, it appears to get 25% across and then I get the error message. I am posting that error screen on the website .
No files get uploaded.

I also tried editing the localhost screen with the remote server differences and putting that up on the website but that does not seem to work. When I try that I get a Server Response: SQLSTATE[HY000][2002]php_network_get_addresses:getaddrinfo failed

Tonight I went back to the database connector to try again, and it works perfectly. Have no idea what is different but I am happy it is working.

Thanks for your helpful advice along the way. The main issue was the need to get the web host to enable PDO.

I have a somewhat similar issue on remote MYSQL ( 1and1). I can connect to the database using PHP database connector. I am not able however to do MySQL binding so as to upload records from a form in my browser...According to 1&1 they do not allow remote MySQL connection but I do not understand then how come I can connect with the DMXZone PhP Database connector?