Issue 25063

Summary:	Text file accessed using ODBC shows extension which stops queries
Product:	Base	Reporter:	kelvine <kelvineld>
Component:	code	Assignee:	ocke.janssen
Status:	CLOSED WONT_FIX	QA Contact:	issues@dba <issues>
Severity:	Trivial
Priority:	P3	CC:	issues
Version:	OOo 1.1
Target Milestone:	OOo 2.0
Hardware:	All
OS:	Windows XP
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---

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.