BorlandTalk.com Borland discussion newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  Library/components for non-visual app using MySQL with run-t          BorlandTalk.com Forum Index -> Delphi Databases (SQL Servers) View previous topic :: View next topic   Author Message Warrick Wilson Guest Posted: Fri May 18, 2007 1:09 am    Post subject: Library/components for non-visual app using MySQL with run-t I'm working on a non-visual app (which is slated to ultimately become a service) using BDS 2006 Delphi. I need to connect dynamically (at run time) to a MySQL server and work on various databases on that server. Basically, the app is collecting in-bound data logs via one method, will do some reformatting/precalculating/crunching, and then put the data into the appropriate places on the server. I'd like to have the connection information be loadable from my own storage format, since we want to hide passwords, etc. from plain view and may not want to have a central repository of connection information (which seems to be the way that a number of components I've looked at want to store things). I want to establish the database connections - both connecting and disconnecting - at run-time, including defining the connections. I believe that the program will be more reliable that way, plus I have a need to have the program handle server failovers.... I'm actually reworking a Java application that doesn't work too quickly, and it's difficult to make a service out of a Java program. And I need to make it a service eventually so that we can have failovers work with multiple servers to keep this running. Price is somewhat an issue. I've been looking at AnyDAC and Zeos today, but I'm wondering what people would recommend. AnyDAC looks intriguing, but I'm having issues trying to get a quick non-visual prototype up and running. I was reading the Zeos support forums and got a little worried about the "open source" nature of the program - the app I'm working on is definitely a commercial venture. So I need to be wary of potential problems there. Thanks. Back to top Ray Marron Guest Posted: Fri May 18, 2007 2:57 am    Post subject: Re: Library/components for non-visual app using MySQL with r "Warrick Wilson" <warrickw (AT) mercuryonline (DOT) com> wrote in message news:464cb6a2 (AT) newsgroups (DOT) borland.com... [...] Quote: I was reading the Zeos support forums and got a little worried about the "open source" nature of the program - the app I'm working on is definitely a commercial venture. So I need to be wary of potential problems there. It's LGPL, so no worries on the license front. -- Ray Marron Back to top Dmitry Arefiev Guest Posted: Fri May 18, 2007 8:11 am    Post subject: Re: Library/components for non-visual app using MySQL with r Hello Warrick Quote: AnyDAC looks intriguing, but I'm having issues trying to get a quick non-visual prototype up and running. What issues do you have ? Regards, Dmitry -- Dmitry Arefiev - www.da-soft.com AnyDAC - Oracle, MySQL, MSSQL, MSAccess, IBM DB2, Sybase ASA, DbExpress, ODBC freeware data access engine ThinDAC - multitier data access engine Back to top yannis Guest Posted: Fri May 18, 2007 2:07 pm    Post subject: Re: Library/components for non-visual app using MySQL with r Ray Marron pretended : Quote: "Warrick Wilson" <warrickw (AT) mercuryonline (DOT) com> wrote in message news:464cb6a2 (AT) newsgroups (DOT) borland.com... [...] I was reading the Zeos support forums and got a little worried about the "open source" nature of the program - the app I'm working on is definitely a commercial venture. So I need to be wary of potential problems there. It's LGPL, so no worries on the license front. Actually LGPL does not permit statical linking as far as I can remember only dynamic. And Zeos is not linked at all they are compiled directly to your application. This is a license violation. Regards Yannis. Back to top Ray Marron Guest Posted: Fri May 18, 2007 7:21 pm    Post subject: Re: Library/components for non-visual app using MySQL with r "yannis" <none (AT) noware (DOT) non> wrote in message news:mn.92d77d75bc432b39.0 (AT) noware (DOT) non... [...] Quote: Actually LGPL does not permit statical linking as far as I can remember only dynamic. And Zeos is not linked at all they are compiled directly to your application. This is a license violation. I went and read the whole license (well, mostly), and YOU'RE RIGHT! " However, linking a "work that uses the Library" with the Library creates an executable that is a derivative of the Library (because it contains portions of the Library), rather than a "work that uses the library". The executable is therefore covered by this License. Section 6 states terms for distribution of such executables." .... " 6. As an exception to the Sections above, you may also combine or link a "work that uses the Library" with the Library to produce a work containing portions of the Library, and distribute that work under terms of your choice, provided that the terms permit modification of the work for the customer's own use and reverse engineering for debugging such modifications." So it would appear when using the Zeos library, you have to make the source of your application available for the customer to change, although they can't distribute it further (based on "terms of your choice"). I can now officially say I learned something this week! :) -- Ray Marron Back to top Warrick Wilson Guest Posted: Fri May 18, 2007 9:36 pm    Post subject: Re: Library/components for non-visual app using MySQL with r "Dmitry Arefiev" <darefiev@da-soft.com> wrote in message news:464d2cd4 (AT) newsgroups (DOT) borland.com... Quote: Hello Warrick AnyDAC looks intriguing, but I'm having issues trying to get a quick non-visual prototype up and running. What issues do you have ? Dmitry, I'll post a message in your support forums. I registered there last night. Thanks. Back to top Warrick Wilson Guest Posted: Fri May 18, 2007 9:41 pm    Post subject: Re: Library/components for non-visual app using MySQL with r "Ray Marron" <me (AT) privacy (DOT) net> wrote in message news:464db64c$1 (AT) newsgroups (DOT) borland.com... Quote: "yannis" <none (AT) noware (DOT) non> wrote in message news:mn.92d77d75bc432b39.0 (AT) noware (DOT) non... [...] Actually LGPL does not permit statical linking as far as I can remember only dynamic. And Zeos is not linked at all they are compiled directly to your application. This is a license violation. I went and read the whole license (well, mostly), and YOU'RE RIGHT! " However, linking a "work that uses the Library" with the Library creates an executable that is a derivative of the Library (because it contains portions of the Library), rather than a "work that uses the library". The executable is therefore covered by this License. Section 6 states terms for distribution of such executables." ... " 6. As an exception to the Sections above, you may also combine or link a "work that uses the Library" with the Library to produce a work containing portions of the Library, and distribute that work under terms of your choice, provided that the terms permit modification of the work for the customer's own use and reverse engineering for debugging such modifications." So it would appear when using the Zeos library, you have to make the source of your application available for the customer to change, although they can't distribute it further (based on "terms of your choice"). I can now officially say I learned something this week! There's something on one of the sites that also talks about the issue in needing the libmysql.dll from the MySQL package to run with. That, apparently, according to one thread I read, implies a "distribution of MySQL" and the requirement for a commercial license purchase of MySQL. In my case, that's not a problem, since we have the commercial license already. But we don't want to give source out for the product. So Zeos doesn't look like a useful application, in this case. I'm not against buying something, if it's reasonably priced and will work. What would work well is if I can create my program with a trial version, prove it works, and then get our purchasing process started. It's a pain to try and get some things purchased. Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         BorlandTalk.com Forum Index -> Delphi Databases (SQL Servers) 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.