Insert Record and Yahoo Hosting mysql Access

I purchased WebAssists User Registration Pack and I am having difficulty getting the registration form to record the form data to my sql database.

I utilize Yahoo Web Hosting and when I am attempt to access the mysql database through Dreamweaver, I am met with no connection. It is as if Dreamweaver is unable to communicate with my sql database with Yahoo. I have already created an sql database with Yahoo and have copied the "users" database to it - provided by the user registration pack.

When I go into the server behaviors and open up the insert record variable, DataAssist is unable to detect the Yahoo's server and thus the sql database; though I have provided Dreamweaver the correct host, username and password.

I need to be able to get access so that I can get data from my registration form to my database. Can you assist with my issue?

It is possible that Yahoo does not allow outside connections to the MySQL server.

You will need to contact them to see if it is possible for your computer to establish a connection to their MySQL server.


You don't need to use Dreamweaver to get registration information into the Database.

Registration information is saved to the database when the user browses to your website, the fills out the registration form.

I will call Yahoo to learn more about possibly connecting to their mysql server. However, if it is not possible, it may be difficult to use some of webassist's extensions that reqly on a valid connection to a mysql database, such as DataAssist, SecurityAssist, etc. Any thoughts on this issue?

in this case you should install a local testing server.


There are tutorials for this on the following page for both Mac and PC:
resources.php

I have installed a local testing server already...XXAMP. With XXAMP, the connections are working fine; just as they should. However, when it comes to connecting with Yahoo...that is not possible (talked with Yahoo this afternoon). Yahoo states that it is not possible for me to establish connections with Yahoo's sql server through DW. They further stated that it is up to me to ensure the coding and scripting is done proper so that a connection is possible when files are uploaded to Yahoo's hosting server.

Going back to the testing server, are you suggesting that I get my connections up and running through the testing server first? What then?

Yes, you would set your site up on the local server.


What I end up doing for the connection is editing it in Dreamweaver, insert the correct details for the remote yahoo MySQL server, then upload it to the server.

Once it is uploaded to the server, Set the View drop down in the Dreamweaver files panel to Remote Server. Right click the connection file and select the Set Permissions option. In the permissions panel clear the Write attribute for all users.

Now change the files View option back to local, and edit the connection back to your local settings.

This way the remote connection will connect to the remote server, the local connection will connect to the local server and by clearing the write attribute, Dreamweaver will not be able to overwrite the connection.

You may get warning messages that Dreamweaver failed putting the connection, but those can be ignored.