Good news! It all works. After a reinstall of FileMaker (I didn't
even bother to uninstall) the ODBC drivers appeared and I can connect
with no problems from Delphi. I chose custom install as you suggested
however the ODBC driver was already selected to install. All in all it
seems easier (not a great deal so but somewhat) to use ODBC in Delphi
then in C# (Borland IDE vs. VS 2005).
Thanks again for all your help,
Chris Jamieson
John Weinshel wrote:
> The driver is just called 'Filemaker Pro', and shows 'FMFMP50.dll' at
the
> far right of the Data Source Administrator window.
>
> I've found it in: C:\Program Files\Common
Files\ODBC\FileMaker\Fmfmp50.dll,
> and sent it to you.
>
> I also posed the question to the FSA list, received a reply that it's
not
> installed automatically, but with a Custom install, and I can see it in
the
> Custom options. Insert the disk and begin an installation, even though
the
> app is already installed. Keep going until you get to a screen that
gives
> you a choice to do a Custom install, choose that, and you will see the
ODBC
> drivers on the list of items you can choose to install.
>
> --
> John Weinshel
> Datagrace
> Vashon Island, WA
> (206) 463-1634
> Certified For Filemaker 8
> Certified For Filemaker 7
>
>
> "Chris [CapitalC]" <The.Capital.C@[EMAIL PROTECTED]
> wrote in message
> news:1156963176.803101.112670@[EMAIL PROTECTED]
> > That is exactly the issue. If I can locate this driver I believe I
can
> > make it all work. I did a quick windows search for "odbc" (as that
> > seems to be a common name for the .dll files of the other drivers in
> > the ODBC pane. If you scroll over in the drivers tab of the ODBC
> > manager (the one from the picture) you should be able to see the
> > filename. When I searched for the drivers that I do have they appear
> > to be located in windows/system32/ if you can provide me with the name
> > of this driver I can run a search on my computer to see if they are
> > there but "lost" somehow. Alternatively, you could search for the
.dll
> > and email it to me, however I am not too knowledgeable about drivers
> > and simply having the .dll may not be enough.
> >
> > John Weinshel wrote:
> >> Sounds like you need the driver, which I can see in the ODBC pane,
but
> >> not
> >> locate on my drive. I've sent you an email with that image; if you or
> >> anyone
> >> can point me to where drivers are stored in XP, I'll be glad to send
you
> >> the
> >> driver. I just cannot remember how they were installed in the first
> >> place.
> >>
> >> --
> >> John Weinshel
> >> Datagrace
> >> Vashon Island, WA
> >> (206) 463-1634
> >> Certified For Filemaker 8
> >> Certified For Filemaker 7
> >>
> >>
> >> "Chris [CapitalC]" <The.Capital.C@[EMAIL PROTECTED]
> wrote in message
> >> news:1156942105.488482.20080@[EMAIL PROTECTED]
> >> > John Weinshel wrote:
> >> >> There was a driver for FMP 6 (built by Merant, as I recall). It
was
> >> >> slow,
> >> >> and there were many re****ts of failure to use it to create an
external
> >> >> data
> >> >> source, but I was able to make some simple connections and issue
some
> >> >> basic
> >> >> SQL commands, albeit not from Delphi.
> >> >>
> >> >> Have you tried setting up a DSN with the driver? Have you tried
using
> >> >> Delphi
> >> >> as the source and pulling from Filemaker?
> >> >>
> >> >> And, even if you get it to work, it may not be your best option.
Just
> >> >> what
> >> >> do you mean by 'connecting'? You cannot make a real time
connection to
> >> >> Filemaker via ODBC with a Visual Studi-built front end using data
> >> >> connector
> >> >> objects, although Wim Decorte has created some cl***** for
Filemaker
> >> >> 8/8.5
> >> >> that allows a connection to the XML stream from Filemaker Server
> >> >> Advanced.
> >> >> If you just need to pass data back and forth (or one way), you
will
> >> >> likely
> >> >> be better served with text im****t/ex****ts.
> >> >>
> >> >> You may have better luck with ODBC and Filemaker in the new
release (8
> >> >> and
> >> >> 8.5), using either the driver offered by Filemaker, or a driver
from
> >> >> Actual
> >> >> Technologies. All depends on what you are trying to do.
> >> >>
> >> >> --
> >> >> John Weinshel
> >> >> Datagrace
> >> >> Vashon Island, WA
> >> >> (206) 463-1634
> >> >> Certified For Filemaker 8
> >> >> Certified For Filemaker 7
> >> >>
> >> >>
> >> >
> >> > John,
> >> >
> >> > Using some information which I found later in the day yesterday, I
have
> >> > followed the steps set out in the User's Manual of my FileMaker
edition
> >> > titled "Sharing FileMaker Pro data via ODBC". This guide has me
enable
> >> > the sharing plug-ins, open the database I want to share, and set it
to
> >> > be shared. It then has me "configure the ODBC control panel" as I
> >> > normally would to set up a DSN (in XP it is called "Data Sources
> >> > (ODBC)" under Administrative Tools in the Control Panel). While
the
> >> > guide says that the drivers should be there, they are not in the
list.
> >> >
> >> >
> >> > The reason that I need to use FileMaker and Delphi is due to the
> >> > existing conditions in which I am developing. A large Delphi
solution
> >> > exists and I need to expand it to automate the updating of our
existing
> >> > FileMaker Pro 6 database.
> >> >
> >> > When I say "connect" I mean set up a DSN and use it similarly to
the
> >> > way I do it in C# (.NET 2) (objects like OdbcConnection and
> >> > OdbcCommand) in Delphi. I realize that FileMaker ODBC only
sup****ts
> >> > some SQL statements but I only require INSERT and possibly SELECT.
> >> >
> >> > Thanks again for your help,
> >> >
> >> > Chris
> >> >
> >
|
