ODBC Windows Server 2008 / Filemaker Pro 10 Server Advanced

[ejpvi]

Greetings,

We are trying to install Filemaker Pro Server 10 Advanced onto our new Windows 2008 Server.

That worked fine... everything is connecting properly.

But now I need to Re-create my System DSN that connects to our SQL 2005 SP2 database.

This worked on our Windows 2003 Server... but the driver I need isn't compatible with 2008.

Is there a driver that will work with 2008 server 64 bit and FMP will see it as a possible DSN?

I believe the one 10 needs is: SQL Native Client 2005.90.3042.00

[ejpvi]

Nevermind... A solution has already been discovered!

In case anyone else is having a problem with this...

Filemaker Pro 10 Advanced Server running on Windows 2008 Server 64 bit

Trying to create ODBC connection to SQL 2005 sp2

Follow what Tissot did in this post.

I didn't find it necessary to delete the 64 bit driver, the 32 bit worked just fine (it was already installed, and a newer version than what is specified in the docs). You just have to make sure you use the 32bit ODBC manager (WindowsSysWOW64odbcad32.exe). NOT the Control Panel one (64 bit)

http://fmforums.com/forum/showtopic.php?tid/209825/post/340465/hl/tissot/fromsearch/1/#340465