Solved

Asking for good advice. Delphi 7 capability

Posted on 2006-07-01
15
393 Views
Last Modified: 2010-04-04
Hi everybody,

 I would like to ask some questions and i know your expertise & no. of years of experience using Delphi can answer my question fairly and brilliantly.

Im planning to create an application that will use the DELPHI 7 & mySQL. The database (mySQL) server is located remotely, in other words, the network structure in not intranet but WAN. Just like a webpage the database is located remotely.

Now my question are
1. Is Delphi capable of accessing mySQL using WAN connection (over the internet)?
2. Is it SLOW when in terms of quering data? Are there any workaround for the slowness?

Anybody can give me a good advice?
0
Comment
Question by:ryan_sabarre
  • 10
  • 4
15 Comments
 

Author Comment

by:ryan_sabarre
ID: 17023610
Thanks in advance. Hope i can still use delphi... on WAN.
0
 

Author Comment

by:ryan_sabarre
ID: 17023618
Are there any sites also that gives a free mySQL link? i want to try creating a simple applicatin that will link a server over the internet.
0
 
LVL 28

Accepted Solution

by:
2266180 earned 250 total points
ID: 17023801
there are plenty of mysql libs/components out there, lot of them even free.
vheck out thsi page on quite a few resources: http://delphi.about.com/od/mysql/

regarding the speed: it is the same for all kind of db servers; it only depends on you wan capabilities. there is of course the option of using compression, but that depends on the data if you will have significant increase in speed due to this compression.

a list with components: http://delphi.about.com/cs/toppicks/tp/aatpmysql.htm

most people I heard use zeos. so you can try that (in the idea that you will get much easier support around here :) )

also found an open source component: http://www.productivity.org/projects/tmysql/

cheers
0
 

Author Comment

by:ryan_sabarre
ID: 17024008
So your trying to say that Delphi 7 is very much capable of doing a WAN?
0
 

Author Comment

by:ryan_sabarre
ID: 17024049
Hi if i use zeos, does it uses a ODBC still? Is it capable in accessing servers remotely (WAN)? dO You know of any site that i can test my program if it does connect the mysql from their site?
0
 

Author Comment

by:ryan_sabarre
ID: 17024054
wich of the zeos packages should i download? Which is a reliable free component that does not expire and will run without any dll required?

http://delphi.about.com/gi/dynamic/offsite.htm?zi=1/XJ&sdn=delphi&zu=http%3A%2F%2Fzeoslib.sourceforge.net%2F
0
 

Author Comment

by:ryan_sabarre
ID: 17024065
HI by the way, does zeos support delph 7? It only has the 4,5 & 6 version
0
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.

 

Author Comment

by:ryan_sabarre
ID: 17024279
Hi ciuly,
 
 I installed zeos in my delphi, i got an error when intalling "zeosctrl". There's an error

requires
  rtl,
  vcl,
  dbrtl,
  vcldb,
  ZCommon6; <-------- Cannot find this file.

Where can i find Zcommon6?
0
 
LVL 28

Expert Comment

by:2266180
ID: 17024316
delphi has nothing to do with the network connection. windows will take care of that. (that includes wan)

for the resto fo the questions, there should be someone who worked with zeioa around to answer.
0
 
LVL 28

Expert Comment

by:2266180
ID: 17024322
did you follow all the steps described in the zeos install readme file? there should be something to add some paths to delphi lib path
0
 

Author Comment

by:ryan_sabarre
ID: 17024332
I received too many errors, missing files when i installed zeosctrl. I want to know who has a zeos components that has the complete setup
0
 

Author Comment

by:ryan_sabarre
ID: 17024364
Yes i did follow the steps, i did not forgot also to include the lib path. do you know of any other free good component that connects mySQL without using ODBC or ADO?
0
 
LVL 28

Expert Comment

by:2266180
ID: 17024560
well, that link I gave you: http://www.productivity.org/projects/tmysql/ they say they don't use odbc. take a look at theri site
0
 
LVL 12

Expert Comment

by:Ivanov_G
ID: 17026508
Your initial idea is not the perfect solution. I think you need the so called "3-tiered" architecture.

Consider this:
  DB <-> App.Server <-> ...................WAN........................ <-> Client

You can implement App.Server as COM/COM+/WebService that is located nearby the Database. The from clients worldwide you can access the Application Server. If you use WebServices, you application will be open to other applications that may need interface to your system.

About speed: Since MySQL operations (most of them) are really quick, the total speed will depend on the transfer speed in WAN. If you don't transfer datasets more than 10,000 rows and you have at least 64Kbps WAN speed, you application will work excellent.
0
 

Author Comment

by:ryan_sabarre
ID: 17047837
ciuly ,

 Thanks for your help. I have learned many things here specially you gave me the idea of using zeos components. Thanks a lot. I'm using the zeos components now but not the zeos controls because i still am encountering problem when installing the zeos controls components. So therefore Delphi is still good in using mySQL connected in the WAN.

Thanks a lot.
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

Suggested Solutions

Title # Comments Views Activity
Thread safe  opinion 7 126
Delphi component that can load a DLL in design time? 8 53
delphi exception 7 63
Create a path if not exists 7 69
Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
Creating an auto free TStringList The TStringList is a basic and frequently used object in Delphi. On many occasions, you may want to create a temporary list, process some items in the list and be done with the list. In such cases, you have to…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

863 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

19 Experts available now in Live!

Get 1:1 Help Now