close ad
WARNING PC USERS: Do Not Install the DREAMWEAVER CC 2017 Update »
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Unable to "test" recordset to see data ... need guidance on DW config?

Thread began 8/25/2016 10:49 am by Henry | Last modified 8/29/2016 5:10 pm by Ray Borduin | 802 views | 7 replies |

Henry

Unable to "test" recordset to see data ... need guidance on DW config?

I can create a recordset via WA MySQLi but am unable to "test" it ie. see the resultant data. I get the following error message:" A server timeout has occured . Here are the possible reasons. 1.Please make sure that the web server is up and running. 2. Please verify that the ODBC DSN exists on the testing server."

I'm guessing this is a DW config issue. Please provide guidance ... I've researched this a lot to no avail.

Thanks, Henry

Sign in to reply to this post

Ray BorduinWebAssist

It is probably an issue with the testing server setting in your dreamweaver site definition. Make sure that the server url is correct and working.

Sign in to reply to this post

Henry

I can't find any connection config issues. I checked the server url. I am using an external hosting server as the testing server ... would this be a problem? Am I only able to test on a local server?

Also, from the Dreamweaver database panel I am able to see all database names, all the tables, all the fields residing on the external hosting server ... but I am just not able to view any table data (keep getting an error - the same one when I access a recordset from WA MySQLi tool

Sign in to reply to this post

Henry

I though about this a little more. I have a sense my hosting provider will not provide access to the data for security reasons (re: Dreamweaver is local on my personal computer and not in hosting service domain) ... I am asking the hosting provider now to confirm that. PS. I could access data via Dreamweaver in the past (that was a while ago) and things have likely changed with this provider/

Sign in to reply to this post

Ray BorduinWebAssist

It wouldn't be an issue with the server blocking it. Dreamweaver puts up a web page and gets the data from a php page. If you can access the data from a php page then Dreamweaver should be able to access it.

Sign in to reply to this post

Henry

Re: "DW putting up a web page and gets the data from a php page" ... I am not familiar with this, and tried to search to find out more about this but couldn't find anything ... where would I find these DW created pages? (I am familiar with the DW connectivity files created and placed in _mmServerScripts folder).

Also, I checked with my hosting provider "Our server configuration does not allow remote access to our MySQL servers" ... this is why I think I can't access the data via DW from my hosting provider.

Sign in to reply to this post

Ray BorduinWebAssist

Try downloading and re-installing the latest version of the MySQLi Server Behaviors. I recently made an update that might fix this problem. It uses the same _mmServerScripts folder. It doesn't need a remote connection, so that isn't the issue.

If the new update doesn't address your issue, please send me FTP access and I'll test it on your server to find out what is going wrong.

Sign in to reply to this post

Henry

I downloaded and re-installed MySQLi Server Behaviors ... still get same errors as before, cannot access table data and WebAssist database tools are not working.

I set up a local MySQL / PHP (on my computer) and accessing table data now works! And WebAssist data base tools (eg. create recordset) now works!

For now I'll pass on providing you FTP access to external hosting server to test. I may take you up on this in the future.

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...