I have 5 workstations and 4 are working properly (two are Vista Ultimate and 2 are Windows 7 Pro) to run an ACCDE program on my “TED” server 2008 R2.
Workstation #5 is “TIM” Vista Ultimate and is only one not working. On TIM and using SYSWOW\Odbcte32.exe to test the connection I enter TED\SQLESPRESS and it fails (as if Server not listening) because if I change to add port as follows: TED\SQLEXPRESS, 1433 it will connect. As ACCDE (is DSNLess) and uses only TED\SQLEXPRESS I would like all 5 to work the same.
Following suggestions in article re: listening problems …. In Windows Firewall on TIM I added a custom inbound rule to add the IP address of my server “TED” to allow this connection. That did not help. I also blindly added MSACCESS.EXE outbound rule, but that did not help either.
Anybody have any ideas??? Thanks….