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

Harald Milz arv_bua_mharald at msn.com
Wed May 7 05:27:44 EDT 2008

Hi Rob,

Thanks for the quick answer!

Where exactly should I put the brackets??

My /etc/ODBC.ini looks like this:

     Description             = IP Tabelle
     Driver          = TDS
     Server          = 1.1.1.
     Database                = I_Address
     Port            = 1433
     Trace           = No

IP is obviously fantasy. I tried to enter [I_Address] but after that I wasn't able to authenticate to the SQL Server.
I did not find a place to enter the brackets in OpenOffice.

Thank you!


>> From: rdavis at unico.com
>> To: freetds at lists.ibiblio.org
>> Date: Tue, 6 May 2008 10:50:23 -0500
>> Subject: Re: [freetds] Unable to open table - Error: [FreeTDS][SQL   Server]Incorrect syntax near 'table_name'
>> 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 mailing list
>> FreeTDS at lists.ibiblio.org
>> http://lists.ibiblio.org/mailman/listinfo/freetds
> _________________________________________________________________
> Get Free (PRODUCT) RED™  Emoticons, Winks and Display Pics.
> http://joinred.spaces.live.com?ocid=TXT_HMTG_prodredemoticons_052008

Stay in touch when you're away with Windows Live Messenger.

More information about the FreeTDS mailing list