Adding more then 1 database connection

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.

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.

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

And yes my monitor is turned on ;)

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.

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.

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?

Ray I am sending you a private message.

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.

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.