Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Programming > Pascal Delphi Databases > Re: Connecting ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 6 of 7 Topic 932 of 987
Post > Topic >>

Re: Connecting a Delphi (Borland Developer Studio 10) program to a FileMaker Pro 6 Database (ODBC)

by "John Weinshel" <john@[EMAIL PROTECTED] > Aug 30, 2006 at 01:30 PM

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
>> >
>
 




 7 Posts in Topic:
Connecting a Delphi (Borland Developer Studio 10) program to a F
The.Capital.C@[EMAIL PROT  2006-08-29 11:29:22 
Re: Connecting a Delphi (Borland Developer Studio 10) program to
"John Weinshel"  2006-08-29 19:39:26 
Re: Connecting a Delphi (Borland Developer Studio 10) program to
"Chris [CapitalC]&qu  2006-08-30 05:48:25 
Re: Connecting a Delphi (Borland Developer Studio 10) program to
"John Weinshel"  2006-08-30 10:24:32 
Re: Connecting a Delphi (Borland Developer Studio 10) program to
"Chris [CapitalC]&qu  2006-08-30 11:39:36 
Re: Connecting a Delphi (Borland Developer Studio 10) program to
"John Weinshel"  2006-08-30 13:30:40 
Re: Connecting a Delphi (Borland Developer Studio 10) program to
"Chris [CapitalC]&qu  2006-08-31 11:16:28 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Fri Sep 5 12:33:18 CDT 2008.