Solved

Filemaker Pro and Visual Basic - General Question

Posted on 2008-06-12
4
316 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
Concerto provides fully managed cloud services and the expertise to provide an easy and reliable route to the cloud. Our best-in-class solutions help you address the toughest IT challenges, find new efficiencies and deliver the best application expe…

929 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now