Bug #33620 can't link tables which contain '_' in theyr names to MsAccess97

• Submitted: 2 Jan 2008 9:50
• Modified: 2 Jan 2008 18:22
• Reporter: Martins Brivnieks
• Status: Can't repeat
• Category: Connector / ODBC
• Severity: S2 (Serious)
• Version: 3.51.06
• OS: Windows (XP sp2)
• CPU Architecture: Any
• Tags: connector: MyODBC-3.51.06

[2 Jan 2008 9:50] Martins Brivnieks

Description:
on trying link table 'my_table_name'
comes mesage: ~"table 'my\_table\_name' not found"

but
if same named table is still linked from previous server versions(4.x; 5.0) then i can access this table

How to repeat:
- - -

[2 Jan 2008 10:59] Valeriy Kravchuk

Thank you for a problem report. Please, try to repeat with a newer version, 3.51.22 (see http://dev.mysql.com/downloads/connector/odbc/3.51.html), and inform about the results.

[2 Jan 2008 13:08] MySQL Verification Team

Linking with 5.1.23

Attachment: linking.PNG (image/png, text), 31.90 KiB.

[2 Jan 2008 13:10] MySQL Verification Team

Thank you for the bug report. I wasn't able to repeat with latest source server
5.1.23 and latest released version of MyODBC.

[2 Jan 2008 18:22] Martins Brivnieks

@Valeriy Kravchuk
with your sugested works,
but i cant move to newer connector(than 3.51.06) cause one other problem
which i cant describe cause my weak english - ill try:
in my network i have one other server 4.1.7(linux) which is under my Admin
and it do some "mistical lock" after some activity made by connector newer than 3.51.06
mistical it is cause: simple select are able but where in select caled more than one table comes err msg which gone only after server restart
(admin wont change anything cause it works in current combination)