32-bit ODBC driver on 64-bit SQL Server I am unable to use an ODBC 64-bit driver with SSMS 2012 running on a SQL Server 2012 64-bit instance. However, I believe that the 32-bit driver works.

My question is can I use SSMS 2005 32-bit to create a linked server using ODBC on a 64 bit instance of SQL Server 2012? I tried to do this, but when I clicked on OK to create the linked server I got the message:


  Index was outside of the bounds of the array


Is what I am doing completely wrong or is there somehow a way to create this linked server using a 32-bit ODBC connection?
No, you cannot load a 32-bit ODBC driver into the 64-bit SQL Server address space (reference). From your flurry of recent questions, it seems you are having continuing problems accessing a Pervasive database using their 64-bit driver. Have you considered contacting Pervasive support for assistance or an updated driver? You could also ask a question on their forum.