Skip to Content.
Sympa Menu

freetds - [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 AT lists.ibiblio.org
  • Subject: [freetds] unixodbc and openoffice
  • Date: Sun, 10 Feb 2008 11:56:25 -0600

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




Archive powered by MHonArc 2.6.24.

Top of Page