AnsweredAssumed Answered

FileMaker Server ODBC error.

Question asked by wlucas1984 on Jan 7, 2010
Latest reply on Jan 7, 2010 by mrvodka

Title

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.

 

Background:

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!

 

-Will

 

 

 

 

 

 

 

 

 

Outcomes