Re: ADO/MYSQL
- From: "Guillem" <guillemvicens-nospam@xxxxxxxxxxxxxxxxxx>
- Date: 19 Jul 2006 06:57:08 -0700
Jack D wrote:
I hope someone can shed some light on this:
I'm in the middle of writing a briefcase application and is having
problems using textfiles(or xml) saved by ado component and loading
them into mysql. Basically i need to access a mysql database server
from time to time to either update or download info. I do this(or
trying to) by exporting data to a xml file from mysql and then
loading that file into a tadoquery component using loadfromfile()
function. MYSQL offers a lot of different file formats in which to
export data, but none of them work when i try to load into a adoquery
component.
Is there some other way i can achieve this?
Cheers
PS: i'm using DElphi 7 Ent
you're getting into the same error I did when I first worked with XML :)
you have to consider that XML is only a "way" to make files
understandable to any app, but that does not mean the app knows how to
load the data. In other words, it not necessary has a method that can
load the information using the structure of the XML file.
For example, OpenOffice files are all based in XML, but try to open
them with ADO... <g>
In fact, XML files generated by MySQL and ADO use different structures,
thus provoking that ADO can not read well the MySQL XML files.
The approach I used then to solve this problem was simple. I had a
mid-tier which, among other things, when the client-tier sent a query
it then created the XML file from ADO and sent it back to the
client-tier, which read it using also ADO. Don't know if that solution
will help you, though.
--
Best regards :)
Guillem Vicens Meier
Dep. Informatica Green Service S.A.
www.clubgreenoasis.com
--
Contribute to the Indy Docs project: http://docs.indyproject.org
--
In order to contact me remove the -nospam
.
- References:
- ADO/MYSQL
- From: Jack D
- ADO/MYSQL
- Prev by Date: Re: ADO/MYSQL
- Next by Date: Re: ADO/MYSQL
- Previous by thread: Re: ADO/MYSQL
- Next by thread: Can INSERT command be used for memo fields ?
- Index(es):
Relevant Pages
|
