ZMetadata failed to fetch list of table in excel using ADO

iwancs · Post by **iwancs** » 29.07.2009, 03:24

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

Post by **mdaems** » 08.08.2009, 06:43

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

iwancs · Post by **iwancs** » 13.08.2009, 19:25

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

Post by **mdaems** » 25.08.2009, 21:14

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

iwancs · Post by **iwancs** » 26.08.2009, 22:36

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

Post by **mdaems** » 02.09.2009, 22:08

Did you make some progress?

Mark

iwancs · Post by **iwancs** » 03.09.2009, 19:35

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

Post by **mdaems** » 05.09.2009, 00:01

No idea. I NEVER (really!!) used ADO and I must admit I don't even know how to use it.

Mark