Zeoslib Portal

Fine with me.

Thanks.

Thanks cipto_kh, problem solved.

If anyone else is curious, a value in rdb$fields.dimensions will indicate an array, the dimensions for the array are found in rdb$field_dimensions.

Thanks also to mdaems.

Choppy.

Screenshot showing further info.

I've attached the db, taken, unmodified, from a fresh install of Firebird 2.03. I'll post a screenshot of the error, also showing table structure. To re-create, drop a TZConnection and a TZTable on a form, set the connection as user : sysdba password : masterkey protocol : firebird-2.0 database : [a...

Using 6.6.2, with Firebird 2.03, with protocol=firebird-2.0 I'm using a TzTable to open the sample employee.fdb, but certain tables won't open, giving the error : "Cannot access blob record in column x with type y" where x is a column number, and y is a non-blob field (integer or string). ...

I've checked my mdac, with Microsofts own tools, and it checks out ok. I've been working with this solution: function TZAdoDatabaseMetadata.AdoOpenSchema(Schema: Integer; const Args: array of const): ZPlainAdo.RecordSet; var Restrictions: Variant; begin Result := nil; if not FSupportedSchemasInitial...

Mark, As you suggest, the error is probably caused by the High(Args) value of -1. In 'TZAdoDatabaseMetadata.BuildRestrictions', if I change the line Result := VarArrayCreate([0, High(Args)], varVariant); to Result := VarArrayCreate([0,0], varVariant); then problem is resolved. I don't know exactly w...

I've checked GetSchemaNames, with the exact same results. The schema is supported, as 'TZAdoDatabaseMetadata.SchemaSupported' returns ok. i've found an exception is raised in 'TZAdoDatabaseMetadata.AdoOpenSchema', on : ' Result := (GetConnection as IZAdoConnection).GetAdoConnection. OpenSchema(Schem...

Hi Mark, Running with a TZSQLMonitor suggests nothing is sent to the server when i run GetCatalogNames, only the connection statement is logged : 2008-03-25 09:41:11 cat: Connect, proto: ado, msg: CONNECT TO "bob" AS USER "" I can't trace through the code as the MsSQL server is n...

I''ll try with the TZSQLMonitor tomorrow, but I can confirm that 'ResultSet.GetString(0)' returns nothing, as I also tried adding quotes to it e.g

List.Add('""+ResultSet.GetString(0)+'"');

with no result. Using SQL, I get correct answer of 5.

Choppers.

Hi Mark,

I'm connecting using ado. GetCatalogs appears to run fine, but with no results. I double checked by changing

ResultSet.GetStringByName('TABLE_CAT')

to

ResultSet.GetString(0)

but still no results.

Using 6.6.1 - beta, I can successfully connect to a MSSQL 2005 server, but GetCatalogNames returns empty.

I can get a list using SQL, but it's not my preferred option.

Does anyone know if this *should* work, or am I barking up the wrong tree?

I couldn't agree more zippo.

The database in question was a sample from an old copy of Crystal Report, version 7, to be precise, written way back in 1998. The database was called 'xtreme', and was an MDB.

Indeed !!

You've just found a bug in my software for me, Thanks!!. It only appeared because I was testing the updated 'ZAbstractTable.pas', glad I mentioned it now.

Thanks again.

Problem solved. Although the problem recurs later when I open the table with a TZQuery, but i'd guess you probably knew that. Don't go out of your for for me, this isn't a mission critical problem, I only noticed it when I was messing around with a sample database that comes with an old version of C...