July 8, 200817 yr Hi guys, I'm working on this database and i need to get data from my vb.net code to the fmp database... i was wondering if there is a way to program my program to automatically import the xml data to the FMP database... thanks in advance, Euka
July 9, 200817 yr Not that I know anything about .NET or vb.NET, but you might want to look here: fmDotNET - press release Connecting Data fmDotNET info page
July 13, 200817 yr If the XML route doesn't work for you, you can connect to FMPro (basic version) using ADO.NET or plain ADO if you install the ODBC drivers that come with your FileMaker CD. Also, I posted a simple Ruby script that pulls from FileMaker into SQL Server 2005 using 2 ODBC connections and ADO. The reverse could probably easily be accomplished--pretty sure FileMaker's ODBC supports INSERT statements. [My script uses the basic COM/Win32OLE flavor ADO.] Let me know if you want me to post my Ruby source code since Ruby source code should be somewhat understandable to a Visual Basic user (I always take Visual Basic COM/Win32OLE documentation to help make my Ruby scripts).
July 16, 200817 yr Author ok since nobody has posted in a while... how about this... what if i created a script (that ran automatically after hitting the save button) in vb.net that ran from all of my parameters... how would that look? thanks in advance, Euka
Create an account or sign in to comment