asked on

how to solve time out connection to SQL server from access VBA

I am getting this error while trying to connect and link in tables from Access vba to SQL Server.
Connection Failed:
SQLState: '01000'
SQL Server Error: 53
[Microsoft][ODBC SQL Server Driver][DBNETLIB][ConnectionOpen(Connect()).
Connection Failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not
exist or access is denied.
I found solution on the link below, but i am not sure how to implement it.

stackoverflow.com/questions/15120143/handling-a-sql-server-login-error-msg-with-vba/15277960#15277960

Any help would be apreciated.

ASKER CERTIFIED SOLUTION

Zberteoc

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Dr. Thomas Henkelmann

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Bitsqueezer

Hi,

another possible error is if you do not use the FQDN (full qualified domain name) of the server. If you are working in a different domain and you only use the short name of the server itself then it can happen that the server name cannot be resolved (depending on the quality of your local DNS).
So instead of "YourServer" use something like "YourServer.domain.domain.com". If you have a named instance, add that at the end like: "YourServer.domain.domain.com\MyInstance"

Cheers,

Christian

maximyshka

ASKER

I actualy misspelled rthe server name. We have very long server names so I wrote o insteadof 0 :-(