close ad
 
Important WebAssist Announcement
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Adding more then 1 database connection

Thread begun 10/21/2015 7:23 pm by DonaldV | Last modified 11/06/2015 10:21 am by Ray Borduin | 3455 views | 9 replies |

DonaldV

Adding more then 1 database connection Error

I am trying to add a second database connection that will work at the same time as the primary. If I add it to additional connections, it wants to use one or the other depending on what domain you are on. If I add it as another dynamic connection, it shows file activity with a blank screen, and eventually times out. You can't view the tables, etc... just won't connect to that second DB.

Is there anyway to get it to take a secondary DB?

I am using another server that holds a bunch of content I want to retrieve, via search parameters. This database is on another server, and is not part of the main database for the application.

Sign in to reply to this post

Ray BorduinWebAssist

You should be able to add as many connections as you want. I'm not sure why the connection isn't working, but it doesn't have anything to do with it being the second one. Maybe the IP address or credentials are wrong.

Sign in to reply to this post
Did this help? Tips are appreciated...

DonaldV

The information is correct for the database server. Even did it from command line and connected to the remote host. The first connection is also working fine. What happens is, every time I try and view the tables for the database, it will open a file activity window that is just blank...

It will timeout after awhile and say:

----------------
A server timeout has occured. Here are the possible reasons.
1. make sure that the webserver is up and running
2. make sure that the odbc.dsn exists on the server <--- not sure what it is saying that for
----------------

This is mysqli server behaviours 1.0.3 and Dreamweaver CC 2014.1.1

But, like I mentioned, the other connection is fine, that was there initially.

Thanks

Sign in to reply to this post

DonaldV

And yes my monitor is turned on ;)

Sign in to reply to this post

Ray BorduinWebAssist

I'll have to debug it. Do you have a dollar sign in the password? That can cause issues.

Can you export the site in Dreamweaver and attach it as a private file to this thread? I'm going to have to see the problem myself to debug it and that means getting the URL and FTP information that would be included in the exported Dreamweaver site.

Sign in to reply to this post
Did this help? Tips are appreciated...

DonaldV

It is an application that I would not be able to give access to unfortunately. The password has exclamation points in it, but that is it.
Wish I could export it and let you take a look, but it is an application that there is nothing like in our sector, and very private. Dreamweaver was used for the UI stuff, and a bunch of handcoding in there as well. Since DM isn't exactly the greatest thing in the world for actual applications like we have. But it is quick for making a UI/CRUD setup for the app.

If I recall, wasn't there a cache file DW used to have that you could delete that solved some issues. Do you know if that is still the case in CC? Maybe it is a dreamweaver issue in that respect.

Sign in to reply to this post

Ray BorduinWebAssist

That isn't one of the errors commonly associated with cache. You could try clearing the server scripts from the menu option Site->Advanced->Remove Connection scripts.

I haven't seen the issue you are reporting, so I can only guess. If the other connection works, then it wouldn't seem to be an issue with your site settings, but usually connection problems are issues with the URL in the site settings.

What about screen sharing? Could we set up a screen sharing session so I could debug it from your computer without getting direct access?

Sign in to reply to this post
Did this help? Tips are appreciated...

DonaldV

Ray I am sending you a private message.

Sign in to reply to this post

Ray BorduinWebAssist

The error implies that your server is unable to connect to the database server you have specified. Does the connection work when viewed on the testing server? I'd have to do screen sharing to fully debug this, but my guess is that the database server doesn't allow remote connections.

Sign in to reply to this post
Did this help? Tips are appreciated...

DonaldV

Just remembered something, that I thought I had already looked at... csf didn't have the port open. Having a dumb moment... all set now. Can't believe the things I tried and then went into the csf config, swearing I had opened that port. Sorry for the wasted time there Ray.

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