Issue 25063 - Text file accessed using ODBC shows extension which stops queries
Summary: Text file accessed using ODBC shows extension which stops queries
Status: CLOSED WONT_FIX
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: OOo 2.0
Assignee: ocke.janssen
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-02-04 13:55 UTC by kelvine
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description kelvine 2004-02-04 13:55:50 UTC 
Hi,

When connecting to a text file using ODBC the table is shown with the file 
extension.

This stops us from using queries as the full file name including the extension 
and the period is used for the table name causing an error.

For example we have a text file called extract.txt
We set up ODBC using the text driver to connect to the text file
We then create a data source using ODBC 
The table appears and works fine in the data source window. It appears as 
extract.txt and not just extract.
Then we go to create a query against this table and when we run it we get:

[Microsoft][ODBC Text Driver] Invalid bracketing of name '`extract.txt`'.

I don't know if this is an ODBC issue or a data source issue, but I thought I 
should report it.

There may also be a work around in the SQL statement but unfortunately I don't 
have that knowledge either.

Thanks

Kelvin
Comment 1 marc.neumann 2004-02-12 11:57:53 UTC 
Hi,

I can reproduce this.
This works in OOo 1.0 so I set the target to OOo 2.0

Bye Marc
Comment 2 marc.neumann 2004-02-12 11:58:23 UTC 
reassign
Comment 3 ocke.janssen 2004-02-18 07:50:30 UTC 
Hi Kelvin,

the problem is that we append a table alias and this table alias also has the
dot in name. If you remove this name or replace it with the name without dot it
works. For 2.0 we will have an option to disable this automatic table alias
appending.
But never the less, I interpret this as bug in the ODBC driver from MS. :-(

Best regards,

Ocke

http://dba.openoffice.org//howto/AppendTableAlias.html
Comment 4 kelvine 2004-02-18 13:35:46 UTC 
Hi Ocke,

Thanks for the tip and update on the change in 2.0

Much appreciated. I can live with this for the time being.

Kelvin
Comment 5 andreas.martens 2005-03-30 14:38:42 UTC 
Closed.