BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Connecting a Delphi (Borland Developer Studio 10) program to          BorlandTalk.com Forum Index -> comp.lang.pascal.delphi.databases View previous topic :: View next topic   Author Message Guest Posted: Tue Aug 29, 2006 11:29 pm    Post subject: Connecting a Delphi (Borland Developer Studio 10) program to Hello, I have spent the last day or so searching for information as to where to start in connecting a Delphi (Borland Developer Studio 10) program to a FileMaker Pro 6 database (preferably using ODBC) however all the information that I have gathered is now in a large jumble in my head. I have experience using both C# and PHP to connect to a MySQL database through ODBC and some PHP functions however I can't seem to get myself started with Delphi and FMP. I was wondering if someone could please give me a walk through about how to connect to and access this database from my Delphi program. Thanks in advance, Chris Jamieson Back to top John Weinshel Guest Posted: Wed Aug 30, 2006 7:39 am    Post subject: Re: Connecting a Delphi (Borland Developer Studio 10) progra There was a driver for FMP 6 (built by Merant, as I recall). It was slow, and there were many reports 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 classes 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 import/exports. 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 <The.Capital.C (AT) gmail (DOT) com> wrote in message news:1156876160.264009.127010 (AT) b28g2000cwb (DOT) googlegroups.com... Quote: Hello, I have spent the last day or so searching for information as to where to start in connecting a Delphi (Borland Developer Studio 10) program to a FileMaker Pro 6 database (preferably using ODBC) however all the information that I have gathered is now in a large jumble in my head. I have experience using both C# and PHP to connect to a MySQL database through ODBC and some PHP functions however I can't seem to get myself started with Delphi and FMP. I was wondering if someone could please give me a walk through about how to connect to and access this database from my Delphi program. Thanks in advance, Chris Jamieson Back to top Chris [CapitalC] Guest Posted: Wed Aug 30, 2006 5:48 pm    Post subject: Re: Connecting a Delphi (Borland Developer Studio 10) progra John Weinshel wrote: Quote: There was a driver for FMP 6 (built by Merant, as I recall). It was slow, and there were many reports 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 classes 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 import/exports. 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 supports some SQL statements but I only require INSERT and possibly SELECT. Thanks again for your help, Chris Back to top John Weinshel Guest Posted: Wed Aug 30, 2006 10:24 pm    Post subject: Re: Connecting a Delphi (Borland Developer Studio 10) progra 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 (AT) gmail (DOT) com> wrote in message news:1156942105.488482.20080 (AT) i3g2000cwc (DOT) googlegroups.com... Quote: John Weinshel wrote: There was a driver for FMP 6 (built by Merant, as I recall). It was slow, and there were many reports 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 classes 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 import/exports. 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 supports some SQL statements but I only require INSERT and possibly SELECT. Thanks again for your help, Chris Back to top Chris [CapitalC] Guest Posted: Wed Aug 30, 2006 11:39 pm    Post subject: Re: Connecting a Delphi (Borland Developer Studio 10) progra 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: Quote: 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 (AT) gmail (DOT) com> wrote in message news:1156942105.488482.20080 (AT) i3g2000cwc (DOT) googlegroups.com... John Weinshel wrote: There was a driver for FMP 6 (built by Merant, as I recall). It was slow, and there were many reports 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 classes 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 import/exports. 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 supports some SQL statements but I only require INSERT and possibly SELECT. Thanks again for your help, Chris Back to top John Weinshel Guest Posted: Thu Aug 31, 2006 1:30 am    Post subject: Re: Connecting a Delphi (Borland Developer Studio 10) progra 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 (AT) gmail (DOT) com> wrote in message news:1156963176.803101.112670 (AT) m73g2000cwd (DOT) googlegroups.com... Quote: 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 (AT) gmail (DOT) com> wrote in message news:1156942105.488482.20080 (AT) i3g2000cwc (DOT) googlegroups.com... John Weinshel wrote: There was a driver for FMP 6 (built by Merant, as I recall). It was slow, and there were many reports 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 classes 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 import/exports. 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 supports some SQL statements but I only require INSERT and possibly SELECT. Thanks again for your help, Chris Back to top Chris [CapitalC] Guest Posted: Thu Aug 31, 2006 11:16 pm    Post subject: Re: Connecting a Delphi (Borland Developer Studio 10) progra 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: Quote: 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 (AT) gmail (DOT) com> wrote in message news:1156963176.803101.112670 (AT) m73g2000cwd (DOT) googlegroups.com... 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 (AT) gmail (DOT) com> wrote in message news:1156942105.488482.20080 (AT) i3g2000cwc (DOT) googlegroups.com... John Weinshel wrote: There was a driver for FMP 6 (built by Merant, as I recall). It was slow, and there were many reports 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 classes 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 import/exports. 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 supports some SQL statements but I only require INSERT and possibly SELECT. Thanks again for your help, Chris Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         BorlandTalk.com Forum Index -> comp.lang.pascal.delphi.databases All times are GMT Page 1 of 1   Jump to: Select a forum C++ Builder Newsgroups----------------C++ BuilderC++ Builder (ActiveX)C++ Builder (Announcements)C++ Builder (Command Line Tools)C++ Builder DatabasesC++ Builder Databases (ADO)C++ Builder Databases (Desktop)C++ Builder Databases (InterBase Express)C++ Builder Databases (Multi-Tier)C++ Builder Databases (SQL Servers)C++ Builder (Graphics)C++ Builder (IDE)C++ Builder (Internet)C++ Builder (Internet Socket)C++ Builder (Internet Web)C++ Builder (Jobs)C++ Builder (Language)C++ Builder (Language C++)C++ Builder (Compatibility with MFC)C++ Builder (Native API)C++ Builder (Non-Technical)C++ Builder (Students)C++ Builder (Third Party Tools)C++ Builder (Upgrade)C++ Builder (VCL)C++ Builder (VCL Components Usage)C++ Builder (VCL Components Development)C++ Builder (VCL Usage)C++ Builder (WinAPI)C++ Builder Installation Delphi Newsgroups----------------Delphi (General)Delphi ActiveX Controls UsageDelphi ActiveX Controls DevelopmentDelphi As400Delphi DatabasesDelphi Databases (ADO)Delphi Databases (dbExpress)Delphi Databases (Desktop)Delphi Databases (InterBase Express)Delphi Databases (Multi-Tier)Delphi Databases (SQL Servers)Delphi DeploymentDelphi GraphicsDelphi IDEDelphi InternationalizationDelphi InternetDelphi Internet Isapi-WebBrokerDelphi Internet WebSnapDelphi Internet WinsockDelphi JobsDelphi Language BASMDelphi Language ObjectPascalDelphi Model Driven Architecture (General)Delphi Model Driven Architecture (Third Party)Delphi MultimediaDelphi Native APIDelphi Non-TechnicalDelphi ObjectPascalDelphi OLE AutomationDelphi OO designDelphi OpenToolsAPIDelphi Reporting-ChartingDelphi RTLDelphi StudentsDelphi TeamSourceDelphi Thirdparty ToolsDelphi Thirdparty Tools (General)Delphi Thirdparty Tools (IntraWeb)Delphi Thirdparty Tools (RaveReports)Delphi UpgradeDelphi VCLDelphi VCL ComponentsDelphi VCL Components UsingDelphi VCL Components WritingDelphi WebServices SOAPDelphi WinAPIDelphi XMLDelphi Installationcomp.lang.pascal.delphi.components.misccomp.lang.pascal.delphi.components.usagecomp.lang.pascal.delphi.components.writingcomp.lang.pascal.delphi.databasescomp.lang.pascal.delphi.misccomp.sources.delphi JBuilder Newsgroups----------------JBuilderJBuilder AnnouncementsJBuilder Applet IssuesJBuilder As400JBuilder CompilerJBuilder CORBA/RMIJBuilder DatabasesJBuilder DB SwingJBuilder DebuggerJBuilder DeploymentJBuilder DocumentationJBuilder EnterpriseJBuilder HandheldJBuilder IDEJBuilder JavaJBuilder JavaAPIJBuilder Java LanguageJBuilder Java SwingJBuilder Java BeansJBuilder Java Beans UsageJBuilder Java Beans DevelopmentJBuilder JBCLJBuilder JDataStoreJBuilder JobsJBuilder LinuxJBuilder MacintoshJBuilder & MobileSetJBuilder MultiLingual AppsJBuilder Non-TechnicalJBuilder OpenToolsJBuilder Servlets (JSP)JBuilder StudentsJBuilder Team DevelopmentJBuilder Thirdparty ToolsJBuilder UpgradeJBuilder Installation InterBase Newsgroups----------------InterBaseInterBase Bug DiscussionInterBase GeneralInterBase IBConsoleInterBase OpenSourceInterBase ReplicationInterBase SQLInterBase ThirdpartyInterBase Installation Miscellaneous Borland Newsgroups----------------AppCenterAppServerEnteraVisiBroker  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.