Page 1 of 1
ZMetadata failed to fetch list of table in excel using ADO
Posted: 29.07.2009, 03:24
by iwancs
Hi, i've tried to use the ZMetadata to retrieve list of table on an excel file using the ADO protocol.
It returns no list.
But i still can access the excel sheet using the ZQuery and read the data correctly, but i need to list the table inside the excel file.
Is there anyone tried it? thanks
Posted: 08.08.2009, 06:43
by mdaems
Is this a specific 7.0 problem or is it also a problem in the stable zeoslib version?
Is it possible this is a problem with the ADO implementation for excel files or also when using ADO for other databases (eg. Access, sql server)?
Mark
Posted: 13.08.2009, 19:25
by iwancs
Hi,
I haven't tried the ADO Connection to other database, just for Excel File and i've tried the Previous Stable Version, it works, so it happen only on this version. I use the 6.6.5 stable version on D6 and it works.
I Use the TZSQLMetaData component because i need to get list of available sheet.
Iwan CS
Posted: 25.08.2009, 21:14
by mdaems
Hi Iwan,
Sorry for the delay. I've been building an other project I needed urgently, so I didn't log on for a very long time.
I'm afraid you'll have to debug a little. This seems to be a D2009 issue. Or did you test 7.x on an older delphi version with the same result?
Best place to start is in the procedure TZAdoDatabaseMetadata.UncachedGetTables.
Maybe you can find out where the missing link is.
Mark
Posted: 26.08.2009, 22:36
by iwancs
It's ok, i can understand, i've tried 6.5 version on D6, and it's working, i'll try your suggestion for 7.0 on D6 too. I've tried debugging the source to find which function is responsible to return the value, so thanks for the hint, i'll take a look at the source. Hopefully i could find the problem, thanks.
Iwan
Posted: 02.09.2009, 22:08
by mdaems
Did you make some progress?
Mark
Posted: 03.09.2009, 19:35
by iwancs
Sorry mark, i've been busy with other things first, i'll post some progress as soon as possible, i've found the source line, and it looks like it has problem, but i need to do other things first, so i can't continue yet.
But did you having the same problem too?is it reproduceable in your development environment.
Thanks for the support
Iwan CS
Posted: 05.09.2009, 00:01
by mdaems
No idea. I NEVER (really!!) used ADO and I must admit I don't even know how to use it.
Mark