0 Replies Latest reply on Oct 5, 2012 9:48 AM by mcarey

    Data Source for SQL 2008 not showing up when defining external data source

    mcarey

      I am running FileMaker Server 11 Advanced on a Windows Server 2008 R2 Standard - 64 Bit Operating System

       

      On this server I am already using a Data Source for MySql

       

      I am trying to add a DSS for SQL 2008

       

      I downloaded the Microsoft SQL Server 2008 Native Client 10.0 and installed it on the FileMaker Server

       

      I have gone into the Server's DataSource (ODBC) administrator and clicked on the System DSN tab

      Under this tab I have the System Data Source for my MySql connection.

      I have added the SQL Server 2008 Native Client 10.0 here and configured it, pointing it to my SQL 2008 Server, entering the login and password to my view of a DB on the SQL Server. I have tested the connection it successfully connects.

       

      When I go to a FileMaker DB which is currently hosted on the FileMaker server in question and select Manage:External Data Sources I can see the data source for my connection to MySql. I then click NEW to add the new data source that connects to my SQL 2008 Server. After clicking the 'New' button I get the 'Edit Data Source' window. I then select Type: ODBC

      I then click the 'Specify' button to select my DSN. In the 'Select ODBC Data Source' window I only see the MySQL data source. The SQL 2008 data source that I defined and tested on the operating system of the FileMaker Server does not appear......so I am stuck at this point.

       

       

      Perhaps I have the wrong SQL Server 2008 driver loaded on the FileMaker Server? I have had a tough time finding a better one on the Internet. Have I made a mistake in my configurations? Does anyone know where I should go from here.

       

      Thanks for your help!