Unable to open table - Error: [FreeTDS][SQL Server]Incorrect syntax near 'table_name'
Harald Milz <[email protected]>
| Newsgroups | gmane.comp.db.tds.freetds |
|---|---|
| Message-ID | <[email protected]> |
Hi Rob,
Thanks for the quick answer!
Where exactly should I put the brackets??
My /etc/ODBC.ini looks like this:
[BSG]
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!
Harald
----------------------------------------
>> From: [email protected]
>> To: [email protected]
>> 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
>> [email protected]
>> 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.
http://www.windowslive.com/messenger/overview.html?ocid=TXT_TAGLM_WL_Refresh_messenger_052008