close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Insert Record and Yahoo Hosting mysql Access

Thread began 4/30/2010 9:58 pm by mora398588 | Last modified 5/04/2010 10:10 am by Jason Byrnes | 1424 views | 5 replies |

mora398588

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?

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

mora398588

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?

Sign in to reply to this post

Jason ByrnesWebAssist

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

Sign in to reply to this post

mora398588

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?

Sign in to reply to this post

Jason ByrnesWebAssist

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.

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...