[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 617
  • Last Modified:

Filemaker 9 Linked Server on SQL Server 2005

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

0
jpcesar
Asked:
jpcesar
  • 2
1 Solution
 
lesouefCommented:
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.
0
 
jpcesarAuthor Commented:
"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.
0
 
lesouefCommented:
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?
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now