no access to column names

Hello,

with OOo 1.1.0 Linux I'm using a adress database for a long time without
any problem. It's hosted on a MySQL Server Version 3.23.
Now I've created a new database with adress information and this is
hosted on MySQL Server 4.1. Inside OOo I "see" the databae, I can use
adresses for my letter template. But I cannot see the column names. This
occurs by printing a series of letters into file, the formula field for
"filename will be generated with 'database column name'" is empty ...
(sorry if this isn't the correct notation of such dialog, I'm using a
german OOo).
Now I have compared the odbc trace logs for both cases - I cannot find
any error, only some diffences: before of the part
------------------------------------
[ODBC][31269][SQLGetInfo.c][211]
Entry:
Connection = 0x837bc18
Info Type = SQL_MAX_CONCURRENT_ACTIVITIES (1)
Info Value = 0xbfffe3ca
Buffer Length = 2
StrLen = 0xbfffe376
[ODBC][31269][SQLGetInfo.c][522]
Exit:[SQL_SUCCESS]
[ODBC][31269][SQLAllocHandle.c][510]
Entry:
Handle Type = 3
Input Handle = 0x837bc18
[ODBC][31269][SQLAllocHandle.c][872]
Exit:[SQL_SUCCESS]
Output Handle = 0x838f8f0
[ODBC][31269][SQLColumns.c][208]
Entry:
Statement = 0x838f8f0
Catalog Name = [urz_kstv_voip][length = 13
(SQL_NTS)]
Schema Name = [NULL]
....
----------------------------------------

there are some calls to SQL_CATALOG_NAME_SEPARATOR, SQL_CATALOG_USAGE,
SQL_CATALOG_LOCATION, SQL_SCHEMA_USAGE -- these calls I'm missing in the
log of second database (without access to column names). Of course, I
don't know if this has any importance.

Can you help me?

Kind regards,
Wolfgang


--
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe: http://lists.mysql.com/myodbc?unsub=gcdmo-myodbc [at] m.gmane.org
Wolfgang Riedel [ Mo, 14 Februar 2005 17:44 ] [ ID #643081 ]
Datenbanken » gmane.comp.db.mysql.odbc » no access to column names

Vorheriges Thema: MyODBC Problem with BLOB's
Nächstes Thema: no access to column names