[freetds] unixodbc and openoffice

Lukasz Szybalski szybalski at gmail.com
Wed Mar 12 15:02:02 EDT 2008


On Wed, Mar 12, 2008 at 1:48 PM, James K. Lowden <jklowden at freetds.org> wrote:
> Lukasz Szybalski wrote:
>  > >  > >     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)")
>  > >  >
>
> > >  > 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?
>
>  In later versions, the driver is hard-coded to send "SET QUOTED_IDENTIFIER
>  ON" to the server as soon as the connection is established.  (I didn't
>  check the source code, but I think that's what Frediano meant.)
>
>  There's no config file setting.  You can set it yourself by sending that
>  string at any time between opening the connection and sending the query.
>  You don't even have to send it as a separate batch; this would work:
>
>         SET QUOTED_IDENTIFIER ON select * from "tablename"
>
This works if you type sql in. But with open office you can browse
tables and for me I have over 150 tables so double clicking and
viewing the date is faster then typing select statement each time.

So my option is upgrade to what version?


lucas at debianlaptop:~$ apt-cache policy tdsodbc
tdsodbc:
  Installed: 0.63-3.2
  Candidate: 0.63-3.2
  Version table:
 *** 0.63-3.2 0
        600 http://debian.uchicago.edu etch/main Packages
        450 http://debian.uchicago.edu lenny/main Packages
        400 http://debian.uchicago.edu sid/main Packages
        100 /var/lib/dpkg/status

Don't seem as there is a newer version in Debian repository.

Lucas



More information about the FreeTDS mailing list