Different table naming between Native Mysql and Mysql ODBC drivers

[Fernand Vanrie]

Hallo,

Can the difference in Table naming between The Native Mysql driver and
the ODBC driver been changed ?

the Native connector uses "DatabaseName.TableName"

the ODBC uses "TableName".

In Forms based on a SQL statement it gives (so far) no problems, but in
Forms where the data point to the "Table" there is a issue !

Fernand


---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[frank.schoenheit]

Hi Fernand,

> Can the difference in Table naming between The Native Mysql driver and
> the ODBC driver been changed ?
>
> the Native connector uses "DatabaseName.TableName"
>
> the ODBC uses "TableName".
>
> In Forms based on a SQL statement it gives (so far) no problems, but in
> Forms where the data point to the "Table" there is a issue !

Since with the native connector, you can see tables for more than one
database, omitting the database name would not be possible. Perhaps
we'll add an option in a later version, to limit the tables to one
database. In this case, an additional option to completely hide the
database might be an option.

Ciao
Frank

--
- Frank Schönheit, Software Engineer         frank.schoenheit@... -
- Sun Microsystems                      http://www.sun.com/staroffice -
- OpenOffice.org Base                       http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Fernand Vanrie]

Frank ,

OK, this option will be welcome and the  compatibility  between
MYsql_NATIVE , MYsql_JDBC and MYsql_ODBC will profits from it.
After some small tests I am still not sure witch driver to choose.
MYsql_JDBC is the "slowest" and has no other advantages.
MYsql_NATIVE should be the best solution for OO as frontend to MYSQL but
is still "slower" than ODBC and can  (for the moment) not connect over
the internet.
MYsql_ODBC is the fastest, works  in all conditions (except  on Franks
Windows machine :-) and i suppose that this driver has the most
attention from the MYsql developers ?

Greetz

Fernand

>
>  
>> Can the difference in Table naming between The Native Mysql driver and
>> the ODBC driver been changed ?
>>
>> the Native connector uses "DatabaseName.TableName"
>>
>> the ODBC uses "TableName".
>>
>> In Forms based on a SQL statement it gives (so far) no problems, but in
>> Forms where the data point to the "Table" there is a issue !
>>    
>
> Since with the native connector, you can see tables for more than one
> database, omitting the database name would not be possible. Perhaps
> we'll add an option in a later version, to limit the tables to one
> database. In this case, an additional option to completely hide the
> database might be an option.
>
> Ciao
> Frank
>
>  

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[frank.schoenheit]

Hi Fernand,

> MYsql_NATIVE should be the best solution for OO as frontend to MYSQL but
> is still "slower" than ODBC

the slowness we know of will be fixed in the final version.

> and can  (for the moment) not connect over
> the internet.

Which I fear might not be fixed 'til GA, since it seems to be a problem
in Connector/C, and a fix therein is highly unlikely to make it for our GA.

> MYsql_ODBC is the fastest, works  in all conditions (except  on Franks
> Windows machine :-)

:) I should do some more tests on other machines, I am really confused
that this connect-over-the-internet doesn't work with ODBC here, while
you say it works for you ...

> and i suppose that this driver has the most attention from the MYsql
> developers ?

Don't know anything about MySQL's priorities, sorry.

Ciao
Frank

--
- Frank Schönheit, Software Engineer         frank.schoenheit@... -
- Sun Microsystems                      http://www.sun.com/staroffice -
- OpenOffice.org Base                       http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[Fernand Vanrie]

Frank ,

sorry but wath it means "GA" in real time

I am also confused about this ODBC connection, the only difference i see
is that the Server is on "our" domain and internaly i can aces him over
a internal IP adress but who is not the same as the external IP i gives
you ?

Greetz
Fernand

>
>  
>> MYsql_NATIVE should be the best solution for OO as frontend to MYSQL but
>> is still "slower" than ODBC
>>    
>
> the slowness we know of will be fixed in the final version.
>
>  
>> and can  (for the moment) not connect over
>> the internet.
>>    
>
> Which I fear might not be fixed 'til GA, since it seems to be a problem
> in Connector/C, and a fix therein is highly unlikely to make it for our GA.
>
>  
>> MYsql_ODBC is the fastest, works  in all conditions (except  on Franks
>> Windows machine :-)
>>    
>
> :) I should do some more tests on other machines, I am really confused
> that this connect-over-the-internet doesn't work with ODBC here, while
> you say it works for you ...
>
>  
>> and i suppose that this driver has the most attention from the MYsql
>> developers ?
>>    
>
> Don't know anything about MySQL's priorities, sorry.
>
> Ciao
> Frank
>
>  

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...

[frank.schoenheit]

Hi Fernand,

> sorry but wath it means "GA" in real time

http://wiki.services.openoffice.org/wiki/Database/Drivers/MySQL_Native/Roadmap

Ciao
Frank

--
- Frank Schönheit, Software Engineer         frank.schoenheit@... -
- Sun Microsystems                      http://www.sun.com/staroffice -
- OpenOffice.org Base                       http://dba.openoffice.org -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@...
For additional commands, e-mail: users-help@...