ole 8332 (10/11/2012)

---

Hello, hope someone can sort this out..

I have this strange issue in my setup.

In my connection string I cannot connect with "SQL Server" driver but I can connect with "SQL Server Native Client 10.0"

Both drivers are visible from within ODBC Administrator

"Driver={SQL Server Native Client 10.0};Server=dbMirror1,777;Failover_Partner=dbMirror2,777;Database=MyDB;Uid=dbuser;Pwd=password;Network=dbmssocn"

Setup:

I have three Windows 2008 R2 servers

All servers are in a workgroup

2 servers are running SQL 2008 R2 and have database-mirror setup

1 server running as withness

I want to be able to use the "SQL Server" driver....

Where should I start looking to solve it?

/Ole