Missing ESS DSN list

[Simon K]

Hi all,

I want to link my FM solution directly go some of the other SQL Server databases in our systems.

(Currently we do ODBC imports)

I am using FM Server 9 Adv and FM pro 9 adv on my client (v1 - just about to upgrade to v3)

I go into File/Manage/External data sources...

I click on "new"

Type in a name and select the radio check box for ODBC

Then click on "specify" - ie next to dsn box -

AND the select odbc data source list is empty.

I have set up a data source to one of the sql dbs on the server hosting the Filemaker databases (and on my client)

What have I missed out?

Many thanks

Simon

[LaRetta]

Hi Simon,

When defining your data source in ODBC Data Source Administrator, you must select (and define) in the System DSN tab and not the User DSN. Could that be what you did?

[Simon K]

Hi LaRetta,

Sorry for delay in replying...

They were system dsn's - the answer was a little more "opaque" - but fwiw - and in relation to windows server products:

One of our developers had put a test db onto a Windows Server 2008 box - then created new system dsn's - unaware of 32 bit nature of FM at this time.

The test db seemed to work - but the dsn's were 64 bit which are not recognised by FM (obviously) hence the empty list.

Once the dsn's were set up as 32 bit, they did appear in the list, but given the fact that Windows Server 2008 is not (yet) supported we will not be using this as a production server

Interestingly, everything else seemed to work fine - but that's not enough for me to use it in a production environment.

[ddreese]

I'm having the same problem, but I still can't get the DSN to show up on the list.

We're using SQL 2008, so I downloaded the X86 driver from MS. I set up the DSN (under system DSN), and the connection works when I test it.

Even the 32 bit driver still does not show up. I can't imagine it would require a system reboot (which I can't do anyway as the only 32bit computer I have is our terminal server)?

Also, am I to understand that since our SQL server is running on Server 2008 it won't work anyway? What should that matter? Filemaker is a great product but come on already.

[mr_vodka]

MS SQL 2008 is supported with 10.

[ddreese]

Yes, I know that's supported. I was talking about running Server 2008 as the server operating system, it was eluded to in one of the replies that this causes problems as well.