For a few weeks now I have been trying to create an odbc connection with microsoft access and a mysql database on webhost server with no luck whatsoever.
I have no problem connecting to the database with workbench or other third party software's but they don't do what I need.
When I try to connect I receive these errors.
Connection Failed;
SQLState:'01000'
SQL Server Error:10060
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen
(Connect()).
Connection failed;
SQLState:'08001'
SQL Server Error:17
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied
I have been searching forums for possible solutions but none have worked. I have made very little progress.
Really hope someone here can help me.
Server does not exist or access denied
- Have you verified the server name or ip address that you're trying to connect to? Have you verified the identity that you're trying to connect with? What have you tried and what were the results? Your question, as it stands, is poor. In fact, it really isn't a question, it's a statement. If you've put as much effort into solving your problem as you've put into this question then I'm not surprised that you haven't resolved it.