December 14, 2016 at 7:45 am
Hello!
With in visual studio on our DEV Server i can't connect to the live listener, it just times out. But from management studio it works fine.
From the Test server, it connects fine in visual studio and in management studio.
From my Machine it works fine in visual studio and management studio, but from a colleagues it only works via management studio but not visual studio!
It must be a driver issue somewhere but i can't find any differences between the versions or set ups.
Anyone seen this before or have any idea what it could be?
We are always using multisubnetfailover=true within the connection properties as its across 2 subnets. Using the server\instance name on every environment machine works fine too.
December 14, 2016 at 8:20 am
I have just created an ADO.net connection to the listener which worked fine, then all of a sudden the OLE DB started working fine.
Tried with this multiple people and it has resolved the issue.
Its as if creating the ADO.net connection opened up the channel and now OLE DB can work. Very strange!
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy