[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-odbc
Subject:    myodbc: MyODBC & StarOffice 5.0
From:       Michael Widenius <monty () monty ! pp ! sci ! fi>
Date:       1999-02-21 20:07:44
[Download RAW message or body]

>>>>> "Dmitry" == Dmitry Semenov <sem@nest.vinnica.ua> writes:

Dmitry> Hi!
Dmitry> I have some problem with MyODBC and StarOffice 5.0

Dmitry> - I'm create database descriptor in SratOffice for 'mysql' database
Dmitry> (using MyODBC) - it's OK
Dmitry> - I'm open list of tables in database... it's show table names with two
Dmitry> dot before table name:
Dmitry> ..columns_priv
Dmitry> ..db
Dmitry> ..func
Dmitry> ..host
Dmitry> ..tables_priv
Dmitry> ..user
Dmitry> - I'm try browse table (host), but system return message:
Dmitry> Error reading data from database
Dmitry> Table 'mysql.user.host' not found

Dmitry> Records in server log:
Dmitry> --------------------------------------------
Dmitry> Time	     ID Command	Argument
Dmitry> ............. 2 Connect	root@hawk.cci.vinnica.ua on mysql
Dmitry> ............. 2 Query	show tables
Dmitry> ............. 2 Quit
Dmitry> --------------------------------------------

Dmitry> myodbc.log attached...

Dmitry> PS: Sorry for my bad english.

<cut>

Hi!

Try toggle the MyODBC option '"No catalog (exp)"'
You need MyODBC 2.50.21 for this!

Alternatively you can try adding the row marked with + to sql/sql_yacc.yy


table_ident:
	ident			{ $$=new Table_ident($1); }
	| ident '.' ident	{ $$=new Table_ident($1,$3,0);}
+	| ident '.' ident '.' ident	{ $$=new Table_ident($1,$5,0);}
	| '.' ident		{ $$=new Table_ident($2);}	/* For Delphi */

	| ident '.' ident	{ $$=new Table_ident($1,$3,0);}


Regards,
Monty
-----------------------------------------------------------
Send a mail to mdomo@tcx.se with
unsubscribe myodbc your@subscription.address
in the body of the message to unsubscribe from this list.

[prev in list] [next in list] [prev in thread] [next in thread]