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

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

An unidentified error has occured - Dynamic MySQLi Connection

Thread began 1/21/2015 8:20 am by Nathon Jones Web Design | Last modified 12/21/2016 1:41 pm by Ray Borduin | 1867 views | 15 replies |

Nathon Jones Web Design

An unidentified error has occured - Dynamic MySQLi Connection

I'm trying to get my site connected to my remote MySQL database but when I run the Dynamic MySQLi Connection wizard, enter my MySQL server information and click "Test" it responds with a pop-up dialog box stating:

"An unidentified error has occured"

FTP details and MYSQL database connection information provided privately below. Thank you.
NJ

Sign in to reply to this post

Nathon Jones Web Design

Details below...

Sign in to reply to this post

Jason ByrnesWebAssist

This is an issue with the Testing Server settings in the Site Definition.

Where you are trying to connect tot he remote MySQL server, set the testing server to use FTP.

And if the ftp connection is made to a folder under the site files root, make sure to enter the correct root directory, for example it may be:
/public_html

on testing the FTP info you sent in file zilla, it says:
"Please note: files for your website must be stored under the htdocs directory."

so it looks like the root directory in your case should be:
/htdocs

Also make sure the URL Prefix is entered correctly.

Sign in to reply to this post

Nathon Jones Web Design

Ok, let's start again on this...I've provided new FTP and MySQL information below. I'm now receiving the error:

MySQL Error#: 2002
No connection could be made because the target machine actively refused it.

My testing site is within the directory called "newsite".

Hope you can help, thank you.
NJ

Sign in to reply to this post

Jason ByrnesWebAssist

the error suggests that the MySQL host, user, password, database combination that you are using is not correct. most likely the host name since the target server is actively refusing the connection. If you are sure the settings are correct, you should contact the host.

Sign in to reply to this post

Nathon Jones Web Design

Thing is, the website itself still connects with those details it's only Dreamweaver that's throwing the error. The website is:
www.jb-graham.co.uk/newsite/index.php

Sign in to reply to this post

Jason ByrnesWebAssist

what are the settings in your site definition for the testing server?

Sign in to reply to this post

Nathon Jones Web Design

Below...

Sign in to reply to this post

Jason ByrnesWebAssist

I'm not able to reproduce.

Using the FTP settings you sent for the both the remote and testing server in a DW site, I can connect t the database without an error

Sign in to reply to this post

Nathon Jones Web Design

The username was the issue. Read, re-read and then read again...sorry Jason!

So, my next issue with this is that I want to connect to a new MySQL database which is hosted elsewhere (in preparation for moving the website to our servers). I have provided the connection details for that below.

When I try and create the MySQLi Connection for it, I get the following error:

"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 should be able to connect to an external database, shouldn't I?
Thank you.
NJ

Sign in to reply to this post
loading

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