.htaccess forcing https breaks WA mySQLi functions

I commonly use .htaccess to force a site to use it's SSL cert so the entire site shows as https in the browser. When this is in play, I can't pull any data into the mySQLi behaviors in DW. They all fail to connect to the database. If I delete or blank out the .htaccess upon the server, then the Behaviors operate as one would expect. Any suggestions on how to manage this??

Make sure you use https:// in your testing server url in your Dreamweaver site definition.

Where in DW do I find a field to designate the testing server URL?? I can't find that as a configurable field anywhere.

Open up your site definition and click the Servers tab. Then go to the one you have selected as the testing server and the last field in the form is the url. That will need to start with https:// if you are forcing https with your .htaccess file.

Yes, I see where you were going with that, but doing so breaks my mySQLi connection. I now get that generic error saying that there is no testing server setup - though, clearly there is. I remove the https in favor of just http in that URL field, and i can connect again.

I'd have to debug it. I thought it wasn't working? I'm a bit confused at this point. If you have an SSL certificate installed it should work with or without https. However if you have an .htaccess file forcing https then the url would have to start with https.

If you attach your site definition privately I can test with it and see what is going on.

It's even worse now.. completely deleted the connection .php file, removed the .htaccess file from the root completely, set PHP version to 5.6 for this site, and I can't even get a database connection. Trying to build a connection file, I get:
1. There is no testing server running on the server machine.
2. The testing server specified for htis site does not map to....
Attaching .ste file...
..theoretically, SSL has been removed from the equation completely, and I still can't get connected.

I can't browse to the site you have listed as the web url. Perhaps your site is down or you have a typo.

Well that wouldn't help the problem. It WAS live as of yesterday, but it's failing to connect for me too. I'm see a 500 error - not 404, so something's hinky server side. I'll clean everything out there and try again.

Changed the URL to just http://fgmilive.com/ and now it appears I can retrieve the database tables. So weird.. I have no idea why.