Filemaker and ODBC integration with MS SQL server 2008 R2

I have a database running on a MS SQL server 2008 R2 with Windows server 2008 that i want to access with filemaker 11.  I created a Timematters User DSN, File DSN & System DSN using the MS SQL Server ODBC driver version 06.01.7601 I ran the test connection and the tests complete successfully.  my problem is that when i try to add a ODBC external data source it is not listed in the available list of sources
ODBC.jpg
leslie leeAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Will LovingPresidentCommented:
I believe you need to use a different driver. See: http://help.filemaker.com/app/answers/detail/a_id/6420  and scroll down to the FileMaker 11 section.
screen shot of ODBC drivers for FM 11
0
pcelbaCommented:
I suppose you are talking about FileMaker Windows version not OS X version.

In such case the problem is in the 32/64 bit compatibility. FileMaker as 32 bit application requires 32 bit MS SQL ODBC driver and such driver is visible in 32 bit ODBC Administrator only.

The 32 bit ODBC administrator is available in  C:\Windows\SysWOW64\ODBCAD32.exe  (please change the Windows folder if necessary).

If you don't see any MS SQL driver under 32 bit ODBC Administrator then download and install 32 bit drivers from e.g. here.

Remember that various MS SQL drivers can be slightly incompatible to older 32 bit software. E.g. SQL Server Native client cannot work with varchar(max) data type directly from VB and Visual FoxPro and the possible solution is to use older driver etc. etc.
1
leslie leeAuthor Commented:
My desktop is running Windows 7-64.   my ODBC data source admistrator is 32 bit.
I am unable to locate the ms sql native client 2007.100.2531.00 to download.  i tried installing the ms SQL server 2008 native client but got an error Installation of this product failed because it is not supported on this operating system. i have attached screenshots of the odbc administrator about tab and the driver tab
ODBC.jpg
odbc1.jpg
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

pcelbaCommented:
I cannot recognize whether the ODBC administrator is 32 or 64 bit from your pictures. This is visible e.g. in the Task Manager where you should see odbcad32.exe*32 process for 32 bit version.

You don't need to download one specific SQL Native client. Newer (or almost any) version should work with your SQL Server. You just have to select correct ODBC administrator bit depth 32/64 when defining DSN.

I have Native client 2009.100.2500.00 and it works.
0
leslie leeAuthor Commented:
In the task manager the odbcad32.exe process is running.  how do i select the ODBC administrator bit depth 32 as i dont see an option when defining the DSN
0
pcelbaCommented:
If you need 32 bit then execute C:\Windows\SysWOW64\ODBCAD32.exe

If you need 64 bit then execute C:\Windows\System32\ODBCAD32.exe

Just one of above two exes can run.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
leslie leeAuthor Commented:
I actually found the odbcad32.exe in the C:\Windows\winsxs\amd64_microsoft-windows-m..-odbc-administrator_31bf3856ad364e35_6.1.7600.16385_none_a044d905576812d4 and it worked.  The ones in the syswow64 and the system32 directories did not work.  Thanks for the information. It caused me to continue looking for odbcad32.exe on my c: drive.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.