Bug #9883 error name in table -- cannot connect
Submitted: 13 Apr 2005 23:08 Modified: 13 Apr 2005 23:14
Reporter: william jaques Email Updates:
Status: Duplicate Impact on me:
None 
Category:Connector / ODBC Severity:S1 (Critical)
Version:3.51 OS:Microsoft Windows (win XP)
Assigned to: CPU Architecture:Any

[13 Apr 2005 23:08] william jaques
Description:
Hello,

trying to use Openoffice, and to connect to msql server via odbc
(in hope to get red of access)
 
i have a slight problem
on the mysql server (provider) the database name is "domainname.fr"
and tables are named like "contacts"

but when i connect with open office via myodbc
for some reasons it split the name into
domainname
and
fr.contacts

and then mentioned cant find the filed of the base (in the table)

it seems that the server doesnt like the split as it must expect the name "contacts" only

can yu help or advice me where to find help 
Tks very much 
an amateur in Paris
best regards

How to repeat:
open un text file in openoffice
in the menu tools - data source
create de connection to the source, mysql server
then in the menu View - data source
the window split and show the database connexion
try to open a table 

and error appends!
[21 Apr 2005 7:13] william jaques
Thank you everybody for your help
it gives courage
finally the problem was, or still is, 
my pc is connected to a linux server, i am end user win XP, and apparently windows create 2 profiles, so the problem was that i might have install te mysqlodbc under one profile, and use the database through the other one...

How did i get to this solution, well, i squat the pc of a collegue and start from scratch, and carrefully done everything on the same profile and it works

best regards
William