FileMaker Server ODBC error.
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
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
SET Name = 'Joe'
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
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
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!