Skip to Content.
Sympa Menu

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

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • 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..





Archive powered by MHonArc 2.6.24.

Top of Page