Forum post
Missing ODBC (DSN) Connections
Forum post posted October 4, 2010 by Zachary Crossland, last edited February 9, 2012
3010 Views, 6 Comments
Title:
Missing ODBC (DSN) Connections
Post:
I just installed FM Pro 11 on a Win7 64bit machine and loaded my fm application. I soon learned that my odbc connections from my System DSN are not showing for me to connect to my sql server database.
I've successfully connected on all other machines, but when I hit 'Specify' there are simply no 'Data Souce' items to select from. They are definately setup on the machine in System DSN.
Please HELP.
Answer
Zachary Crossland:
Thank you for posting.
There could be some issues running FileMaker Pro on Windows 7 64-bit since it isn't certified and tested. Was the System DSN setup using the 32-bit ODBC Administrator?:
%systemdrive%\Windows\SysWoW64\Odbcad32.exe
Are the DSN's available to any other applications on the machine?
TSuki
FileMaker, Inc.
2 others liked this
|
Sign in to "Like"
TSuki,
Thanks for the quick response.
1. Yes the application was designed on a 32bit system with System DSN's.
2. Yes, I can see the System DSN using MS Access on the 64bit system.
Note: I also tried using Manage / Database... and editing the joined connections (which appear greyed out). It then prompts me for a 'user name' and 'password'. After enter and selecting OK the following message appears:
ODBC Error: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application.
This is dispite the drivers being the same on the 32bit and 64bit systems under ODBC Data Source (Drivers) tab.
Name: SQL Server
Version: 6.01.7600.16385
File: SQLSRV32.DLL
Date: 7/13/2009
I would greatly appreciate any help you could provide.
Be the first to like this
|
Sign in to "Like"
Zachary Crossland:
You mentioned that the database was designed on a 32-bit machine and then moved to the Windows 7 64-bit machine. However, the Windows 7 machine will have 2 versions of the ODBC Administrator: one 32-bit and one 64-bit. Can you verify that you used the 32-bit version of Odbcad32.exe to setup the System DSN and not the default 64-bit version?
TSuki
FileMaker, Inc.
Be the first to like this
|
Sign in to "Like"
TSuki,
I tried the cmd you posted earlier (%systemdrive%\Windows\SysWoW64\Odbcad32.exe) and added the DSN for 64bit. Yeah! It works!
Thanks for your expertice.
Zach
1 other person liked this
|
Sign in to "Like"
TSuki (or any other FMI staff):
Sorry to pick up this old thread, but it's directly relevant.
What would be the method to fix the identical issue on Snow Leopard? IE, we've got a 64-bit ODBC manager, 64- and 32-bit MySQL ODBC drivers, but a 32-bit FMP? Is there a 32-bit ODBC manager available on SL?
Reason I ask: I run my Mac as a rEFIt'ed multi-boot with 10.6, XP 32bit and Win 7 64bit. I've got the ODBC working on XP and, thanks to this thread, now on Win 7 x64, but not on Snow Leopard. The reason is the same, 64-bit/32-bit mismatch. My FMP DB's ODBC connection should work regardless of the OS I am booted into at the moment.
Be the first to like this
|
Sign in to "Like"
Also on WS2008, can't see the System DSN that I created for Firebird. OS is 64 bit, firebird is 64 bit I already installed the 64 bit driver before having this problem.
I have now installed the 32 bit driver and tried to create a DSN with that one and had no luck.
Do I have to downgrade to WS2008 32 bit?
Be the first to like this
|
Sign in to "Like"