[freetds] unixodbc and openoffice
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', " [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
*** 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
Don't seem as there is a newer version in Debian repository.
More information about the FreeTDS