[unixODBC-support] unixodbc and openoffice

Lukasz Szybalski szybalski at gmail.com
Fri Feb 8 17:11:13 GMT 2008


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?
Lucas


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



More information about the unixODBC-support mailing list