?
Solved

Filemaker Pro and Visual Basic - General Question

Posted on 2008-06-12
4
Medium Priority
?
384 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 200 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

In real business world data are crucial and sometimes data are shared among different information systems. Hence, an agreeable file transfer protocol need to be established.
Simulator games are perfect for generating sample realistic data streams, especially for learning data analysis. It is even useful for demoing offerings such as Azure stream analytics, PowerBI etc.
The video will let you know the exact process to import OST/PST files to the cloud based Office 365 mailboxes. Using Kernel Import PST to Office 365 tool, one can quickly import numerous OST/PST files to Office 365. Besides this, the tool also comes…
Watch the video to know how one can repair corrupt Exchange OST file effortlessly and convert OST emails to MS Outlook PST file format by using Kernel for OST to PST converter tool. It can convert OST to MSG, MBOX, EML to access them. It can migrate…

569 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