FreeTDS Development Group

["Lukasz Szybalski" <szybalski AT gmail.com>]

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?

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

Lucas


--
ceODBC Documentation
http://lucasmanual.com/mywiki/ceODBC