MSSQL Linked Server

[Kiwi]

I am trying to link from MSSQL to Filemaker 9 via ODBC (Sequelink 5.5). When doing a Select query from MSSQL I can only select fields that contain numeric characters. When I select a text field I get the error 'Requested conversion is not supoorted'. The ODBC setup works outside of MSSQL (I can import all data into msquery) so I don't think the fault is in ODBC. Any help appreciated!

Cheers

[murtje]

Only the SQL drivers listed on the FileMaker website are supported. SequelLink 5.5 is not one of them.

http://www.filemaker.com/support/technologies/sql.html

Windows Vista: Microsoft SQL Server version 6.00.6000.16386

Windows: Microsoft SQL Server version 2000.85.1117.00

Windows: Microsoft SQL Native Client 2005.90.3042.00

Mac OS X: Actual Technologies, SQL Server version 2.7

Koen

[Kiwi]

HI Koen

Thanks for that... but the sequelink odbc driver IS the one that Filemaker supply with filemaker. It's in the xDBC folder on the CD.

Cheers

John

[murtje]

The sequelLink driver, delivered with FileMaker, is needed to use FileMaker as an ODBC data source.

If you want to use MS SQL server with ESS, you need the other drivers.

Koen

[Kiwi]

Yes the problem is that I am using FM as the data source. I have a Linked Server setup in MSSQL that reads the data from Filemaker (or should read!). I think the problem lies in SQL as I can read the FM data using the same ODBC connection from other applications such as Access and Excel. I should post a message on a MS SQL forum but fear the people using that wouldn't have heard of Filemaker and would think I was making the whole thing up!

Thanks for the help.

John

[murtje]

Ok, I was confused because you posted it in the ESS forum.

I have no solution for you at the moment.

Koen