Solved

Filemaker Pro and Visual Basic - General Question

Posted on 2008-06-12
4
326 Views
Last Modified: 2013-11-26
Dear All,
I am using Visual Sudio (Basic .Net 2005) to try to write an application to read and write to a Filemaker Pro version 8.0. I have not dealt with this type of database before an therefore I was wondering if someone could be able to advise on the best method to do so with such a type of database. What would be your advise on the options of establishing links between .Net and Filemaker pro? (Just a general format not much details are required at this stage)

Thank you for your help.

K
0
Comment
Question by:khaledc
  • 2
4 Comments
 
LVL 9

Expert Comment

by:jvaldes
ID: 21776033
Why not use FileMaker as the platform it will save you a lot of work. Plus it won't hurt to learn a new product. I promise you it's very easy.
0
 
LVL 1

Author Comment

by:khaledc
ID: 21776048
Hi jvaldes,
I would have loved to do so instead of having to deal with VB trying to communicate with Filemaker Pro, but I am afraid the project is constrained in such a way that there is no other choice.
Cheers,
K
0
 
LVL 28

Accepted Solution

by:
lesouef earned 50 total points
ID: 21776455
well not much choice then...
setup filemaker as an ODBC server, then use this newly created DSN to access its data from within VB. it will behave as a pretty standard ODBC source, a bit less standard than usual ODBC things, but that's the SQL world, almost standard, but never 100% standard... Speed is pretty disappointing, but if the database is not having 500000 lines tables, it will do the job.
alternative: upgrade to fm9, put data in a SQL database, and get both fm and VB to use that common data. but they won't know each other what the other's doing, so this is subject to sync'ing problems.
0
 
LVL 1

Author Closing Comment

by:khaledc
ID: 31466806
Thanks.
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

809 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