connecting SQL from MS Access

[rock]

Dear All,

I am working on a VBA (MS Access) application, which connects Remote
SQL Server by ODBC Connection. When I open this application on my
workstation the error "Connection timeout' or "ODBC - failed"
will occur, But when I open it on the remote desktop it will run.

Can you suggest me what is going wrong.

Regards,
Shital

 

[Lucas Kartawidjaja]

There could be quite a lot of reasons for this. I think the first
troubleshooting step that you want to try is to test your ODBC connection set
up. You can do this by going to the ODBC property window and there should be
test connection button near the final step or something.

 

[Sylvain Lafontaine]

Possibilities would include a firewall blocking the port 1433 or a wrong
Login. You should tell us what type of authentification you are trying to
use to connect to the remote SQL Server and if it's located on the local LAN
or a VPN or if it's located somewhere else over the WAN (Wide Area Network -
Internet).

 

[hitchhiker]

I actually ran into this same issue last week. I solved it by using a
"System" ODBC connection instead of a "File".

 

[hitchhiker]

Err....That should read "System DSN" and "File DSN".... Still asleep

I actually ran into this same issue last week. I solved it by using a
"System" ODBC connection instead of a "File".

Dear All,

[quoted text clipped - 7 lines]

Regards,
Shital