I've been given access to a SQL Server and I wrote a VBA script (in excel) to query the DB and do some calculations/graph with the retrieved data.
Everything works fine on my computer (windows 7). When I gave my excel document to co-worker (on XP), it won't connect and timeout. I tried it on a virtual machine I have (windows xp) and I have the same problem, it won't connect.
I created a file called test.udl in which I configured the connection parameter as follow:
Provider: Microsoft OLE DB provider for SQL Server
Server name: 10.62.250.77\sqlserveraccept (which is a local IP)
I used the user/pass I was given
I selected the right database
and when I click "Test Connection", it is successful on windows 7. I then copy the exact same file over to my XP VM, and it timeouts.
Any idea what it could be? I disabled the firewall on the XP machine.