Filemaker 9 Linked Server on SQL Server 2005

Posted on 2007-07-31
Last Modified: 2008-09-19
Im trying to create a Linked Server within SQL Server 2005, to Filemaker 9 Server. I can sucessfully create it and make a query like: select count(*) from OPENQUERY(FILEMAKER,'select * from test') .

However, if instead i make a select * it will return me:

OLE DB provider "MSDASQL" for linked server "FILEMAKER" returned message "Requested conversion is not supported.".
Msg 7341, Level 16, State 2, Line 1
Cannot get the current row value of column "[MSDASQL].idpais" from OLE DB provider "MSDASQL" for linked server "FM".

that request conversion is not allowed. I think it have to do with text -> varchar mapping.  If i select integer fields, all is ok.

How can I solve this? Anyone knows a reliable ODBC driver for filemaker other than Sequelink? Is there any dedicated provider to filemaker? is any workaround to use a linked server with JDBC instead of ODBC?

I have the DSN properly configured using DataDirect SequeLink 5.5 Client for ODBC.
Im doing this at Microsoft SQL Server Management Studio Express

best regards

Question by:jpcesar
    LVL 28

    Accepted Solution

    fm has no varchar, and fm text fields can go up to 64k, so maybe worth trying another field type to accept bigger text fields?
    I have always used it the other way around.
    the datadirect is the fm supplied odbc driver. I do not know of any other one.
    the jdbc driver works but definitly is a slow solution. I just made a test to access filemaker from within servoy
    driver is shipped on file maker cd and is called sljc.jar.

    Author Comment

    "so maybe worth trying another field type to accept bigger text fields?"
    but I'm not doing manual mapping on the fields, i just want to make a select * so i can perhaps create a view or something. can i use any cast or convert to achieve that?

    im downloading servoy atm.
    LVL 28

    Expert Comment

    don't use servoy just for this, it was a side comment.
    juts a view... so that should work unless the syntax is not accepted. have you read fm8_odbc_jdbc_developer.pdf? it gives all filamaker sql restrictions...
    but in a basic select * from 'testtable', it should work, unless odbc is not properly enables on fm server?

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Suggested Solutions

    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
    Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now