When creating a DSN's.
I can create a DSN to our SQL Server (Windows Server 2003 with MS SQL Server 2005). With the SQL Server Native Client 11.0, however when i try to do the same thing with the ODBC Driver 11 for SQL Server (i believe this driver will solve some of my issues). I cannot connect. I have tried typing the IP directly to aviod a DNS issue, also have tried IP + port etc.
I often get odd and weird errors, when testing the connection. Usually a timeout error but sometimes [Microsoft][ODBC Driver 11 for SQL Server]TCP Provider: An existing connection was forcibly closed by the remote host.
Authentication is in mixed mode, and the OS of the computer trying to connect using this driver is Windows Server 2008 R2 (Hosting a PHP application etc).
Any help would be appreciated!