Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lee_h
Starting Member
36 Posts |
 Posted - 2003-04-08 : 21:11:19
|
| Has anyone ever manged to create a linked server to a Filemaker database?Any advise on how to go about doing this?Have Filemaker Pro ODBC System Data source called "FM_Test"Filemaker database called "trans.fp5" on "c:\test"No passwords. |
|
|
royv
Constraint Violating Yak Guru
455 Posts |
Posted - 2003-04-09 : 11:43:13
|
| Do you get any errors or anything? Are you not able to follow the normal procedures for creating a linked server?***************************************Death must absolutely come to enemies of the code! |
 |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2003-04-09 : 12:13:58
|
| Yuck. Yep, I've done this. We had to install the FileMaker ODBC drivers on the computer that was running DTS. We were able to pull data out that way. Their ODBC drivers are horribly slow and very prone to errors. Very prone. In fact they were so bad, we ended up exporting FileMaker to a CSV every night BY HAND and then importing that into SQL Server. Make sure you only run one thread in the DTS package. The FM ODBC drivers really freaked out if you tried to load from two files at once.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
|
|
|
lee_h
Starting Member
36 Posts |
Posted - 2003-04-09 : 19:11:32
|
| The problem is, I can't find any docs about what the Provider String should look like.In the Linked Server Properties I've used "Microsoft OLE DB Provider for ODBC Drivers" with the following settingsProduct Name: Filemaker ProData Source: FM_TestProvider String: MSDASQLLocation: "C:\fm_test"Catalog: trans.fp5I've also tried variations on location, catalog and prodivder string.I've never set up a linked server to anything other than another SQL Server before, so I'm not really sure what the settings should be. I couldn't find any decent examples (loads on how to link an SQL database through Filemaker though - and it works).When I try to look at the tables, I get the following really useful error:Error 7399: OLE DB provider for 'MSDASQL' reported an error. The provider did not give any information about the error.Currently I'm just trying to get it to run on my local machine |
|
|
|
RoyalSher
Yak Posting Veteran
95 Posts |
Posted - 2003-04-10 : 03:12:59
|
hth,had been following this msg promptly. i was going thro' few articles / sites in relation to sql & filemaker. graz is rite, the odbc drivers r very pathetic of FM... got a link which looks like a plugin.. c if it cd be of ne help.  .site:http://www.frontbase.fi/products/fbsql/best of luck.RoyalSher.*********The world is the great gymnasium where we come to make ourselves strong. |
|
|
|
|
|
|
Linking to Filemaker