I set an OBDC Connector on my Microsoft SQL server to set up a linked server to a MySQL database. The driver worked fine, and has always worked, but just recently we upgraded the web server to an SSL connection and everything goes through HTTPS. Since then the OBDC driver has been unable to connect at all. Any help or advice on how to deal with this would be great, thank you.
Asked
Active
Viewed 45 times
-1
-
A linked server connection over ODBC would not be using http or https, Which database was hosted on the web server? Perhaps some of the necessary ports were closed – Mike Jun 15 '16 at 20:27
-
Have you tried [updating the driver as well](https://www.microsoft.com/en-us/download/details.aspx?id=36434)? Maybe that will help. – BJones Jun 15 '16 at 21:01
-
Check the answer, turned just using the IP instead of the domain name worked, weird how it worked before without a problem, but now it works just how it used to, thanks guys – Iqbal Khan Jun 16 '16 at 15:20
1 Answers
0
Turned out the solution was using an IP address to connect to the server instead of the domain name. I was using sql.example.com to connect to the server, but when I changed it to the actual ip ex: 192.168.1.254 it then started working oddly
Iqbal Khan
- 363
- 2
- 6
- 22