[freetds] Unable to open table - Error: [FreeTDS][SQL Server]Incorrect syntax near 'table_name'
arv_bua_mharald at msn.com
Wed May 7 05:27:44 EDT 2008
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.
>> 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.
>> Try a bracket around it. ex. [table_name]
>> FreeTDS mailing list
>> FreeTDS at lists.ibiblio.org
> Get Free (PRODUCT) RED™ Emoticons, Winks and Display Pics.
Stay in touch when you're away with Windows Live Messenger.
More information about the FreeTDS