Post reply

odbc sql server driver sql server does not exist or access denied

  • April 27, 2015 at 5:23 am

    #147326

    Hello,

    For a few weeks now I have been trying to create an odbc connection with microsoft access and a myphpadmin 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.

  • April 29, 2015 at 12:03 am

    #1794181

    Hi. MS Access cannot connect to the webhost. When you connect with myphpadmin - what protocols do you use? SSH? The datasource you create should have the mysql driver so you configure the odbc to connect to the webhosted server. So when connecting to the webhost from MS Access you should connect to a MySQL datasource which is configured.

    http://dev.mysql.com/doc/connector-odbc/en/connector-odbc-examples-tools-with-access-linked-tables.html

    spids11 (4/27/2015)

    Hello,

    For a few weeks now I have been trying to create an odbc connection with microsoft access and a myphpadmin 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply