freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] Unable to open table - Error: [FreeTDS][SQL Server]Incorrect syntax near 'table_name'

From: "Robert G. Davis" <rdavis AT unico.com>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] Unable to open table - Error: [FreeTDS][SQL Server]Incorrect syntax near 'table_name'
Date: Tue, 06 May 2008 10:50:23 -0500

On Tue, 2008-05-06 at 14:41 +0000, Harald Milz wrote:
> I use OpenOffice Database to open a MS SQL Database using unixODBC and the
> TDS Driver.
>
> Progress is: I was able to configure the ODBC.ini and input the TDS driver
> and create a System DSN. I am also able to connect and authenticate to the
> Database.
>
> Problem is: When using OpenOffice Database, I am able to open the table
> list but when I try to open the table I get the Error:
>
> The Data content could not be loaded.
>
> [FreeTDS][SQL Server]Incorrect syntax near 'table_name'
>
> When I write 'table_name' I would like to clarify that the real Table Name
> contains an "_" (underscore)
>
> Any help is greatly appreciated.
>
> Harald

Try a bracket around it. ex. [table_name]

Rob..

[freetds] Unable to open table - Error: [FreeTDS][SQL Server]Incorrect syntax near 'table_name', Harald Milz, 05/06/2008
- Re: [freetds] Unable to open table - Error: [FreeTDS][SQL Server]Incorrect syntax near 'table_name', Robert G. Davis, 05/06/2008
- Re: [freetds] Unable to open table - Error: [FreeTDS][SQL Server]Incorrect syntax near 'table_name', Frediano Ziglio, 05/06/2008
  - Re: [freetds] Unable to open table - Error: [FreeTDS][SQL Server]Incorrect syntax near 'table_name', Harald Milz, 05/07/2008
    - Re: [freetds] Unable to open table - Error: [FreeTDS][SQL Server]Incorrect syntax near 'table_name', James K. Lowden, 05/07/2008