Can I ask for some clarification here? I might be misunderstanding.
Right now, I do have FTP set for "Connect using:" This is what I have always used.
I have not been able to change it to SFTP and I just learned from my server company that I have to activate SSH for each cPanel that I want to use SFTP. I'm not familiar with activating shell access and I don't want to do something that would be a security risk. They have "Jailed Access" which I might try first, but before I do that I wanted to check to see what you meant because it looks like you are saying that I should use the FTP to connect.
One other thing I wanted to clarify from my end is that the FTP works fine for files. I can upload and download files no problem. But when I try to access the database through a binding or recordset it just won't show anything. And if I open the connection window and click "Test" it says there is an "An undefined error has occurred".
This is just so weird since I have been doing this for years and all of my sites work that don't have SSL. I've missed something somewhere I think. Could it be some kind of SNI issue since I have shared IP addresses with SSL certificates? Just a thought.