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: "Lukasz Szybalski" <szybalski AT gmail.com>
  • To: "FreeTDS Development Group" <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] unixodbc and openoffice
  • Date: Wed, 12 Mar 2008 13:30:01 -0500

On Mon, Feb 11, 2008 at 11:34 AM, Lukasz Szybalski <szybalski AT gmail.com>
wrote:
> On Feb 11, 2008 3:00 AM, ZIGLIO, Frediano, VF-IT
>
>
> <Frediano.Ziglio AT vodafone.com> wrote:
> > >
> > > 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.


You said newer version sets it as a default.... does it set it in some
kind of config file? Can I set it myself?
Lucas




Archive powered by MHonArc 2.6.24.

Top of Page