Skip to Content.
Sympa Menu

freetds - Re: [freetds] unixodbc and openoffice

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "ZIGLIO, Frediano, VF-IT" <Frediano.Ziglio AT vodafone.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] unixodbc and openoffice
  • Date: Mon, 11 Feb 2008 10:00:35 +0100

>
> Hello,
> I have a problem connecting to mssql from openoffice.
> I keep getting this error:
>
> SQL Status: 42000
> Error code: 170
> [FreeTDS][SQL Server]Line 1: Incorrect syntax near 'auto_mydb_007'.
> The SQL command leading to this error is:
> SELECT * FROM "auto_mydb_007"."db0"."D1234"
>
> for some reason the quotation gives a problem.
>
> In python app:
> File "mssql.py", line 4, in ?
> cursor.execute('''SELECT * FROM "auto_mydb_007"."db0"."D1234''')
> <type 'instance'>: ('42000', "[42000] [FreeTDS][SQL Server]Line 1:
> Incorrect syntax near 'auto_mydb_007'. (170)")
>
> but if I remove "
> 'SELECT * FROM auto_mydb_007.db0.D1234'
> Everything works just fine on a command line.
>
> but in openoffice if I create a custom query I still get this errors.
>
> The SQL command leading to this error is:
> SELECT * FROM auto_mydb_007.db0.D1234;
>
>
> Any idea why this might be? Is there a setting that deals with "
> quotations? Or is this some other problem?
>

Try adding a "SET QUOTED_IDENTIFIER ON" before select. Newer version
should set this flag during logon.

> I am using debian stable with freeTDS.
> I Followed this page on how to setup unixODBC and freeTDS:
> http://lucasmanual.com/mywiki/unixODBC
>
> Lucas
>

debian stable is quite old... we released 0.64 on July 2006.

freddy77




Archive powered by MHonArc 2.6.24.

Top of Page