1 Reply Latest reply on Jan 7, 2010 12:42 PM by mrvodka

    FileMaker Server ODBC error.



      FileMaker Server ODBC error.

      Your post

      Hi all,


      I'm trying to connect FileMaker Server 10 with Microsoft SQL Server 2005 Express (9.0 SP3). I am using the DataDirect 32-BIT SequeLink 5.5 driver supplied with FileMaker Pro 10. I am running on Windows Vista Business SP1.



      I have setup FileMaker Server 10 as a linked server in SQL Server 2005 Express using the SequeLink ODBC driver. The linked server appears to work just fine for select statements once I get all the FileMaker data-types correctly configured for use with SQL Server.


      The select statement that I've tried is as follows


      SELECT *
      FROM [TESTSQL]...[Test]

       where TESTSQL is the name of the linked server and Test is the table in the hosted database.


      This correctly returns the following results

      Name    Date            Type    JobNum  WBS

      James     2009-12-31     1     NULL     NULL
      James     2009-12-31     2     NULL     NULL



       If I update the Name field, with

      UPDATE [TESTSQL]...[Test]
      SET Name = 'Joe'

       I get...


      Joe     2009-12-31     1     NULL     NULL
      Joe     2009-12-31     2     NULL     NULL

       so far so good...


      Now if I try to update the Date field with the current date, with


      UPDATE [TESTSQL]...[Test]
      SET Date = GETDATE()

      SQL Server returns the following error from the driver


      OLE DB provider "MSDASQL" for linked server "TESTSQL" returned message "[DataDirect][ODBC SequeLink driver]Cannot open file 'C:\Windows\system32\#'.".
      Msg 7306, Level 16, State 2, Line 1
      Cannot open the table "Test" from OLE DB provider "MSDASQL" for linked server "TESTSQL".

      I have never seen that ODBC error before. Has anyone else seen it? Do you know how to work around it?


      I tried a stupid query to set the column to itself like


      UPDATE [TESTSQL]...[Test]
      SET Date = Date

       this query actually works, but is not useful except to show that there is a way to update dates from SQL Server :)


       Does anyone have any thoughts on how to update Date fields from SQL Server? Thanks for your time!