FreeTDS Development Group

[Nicole Hähnel <ml AT nicole-haehnel.de>]

Hi,

we are trying to use unixODBC and FreeTDS 0.82 to read and write to 
MSSQL 2005 databases.
The connection works and we can read and write data to the database 
using LSX ODBC classes from LotusScript.
(Connection tested with dctest from Lotus Domino)

The first problem are datetime fields which were interpreted as 
"undefined" fields in the Lotus Domino agent.
The only way to write date and time to this datetime fields in the 
database is without the predefined LotusScript class "result.UpdateRow"
and with the normal sql UPDATE query.

The second problem are the german umlauts (ä,ö,ü). They were read as 
ASCII 127 and can not be interpreted.

Are there any known solutions or experiences?
More infos needed?

Thanks!
Nicole


Our configs:

/etc/unixODBC/odbcinst.ini:
[FreeTDS]
Description     = v0.82
Driver          = /usr/local/freetds/lib/libtdsodbc.so
Driver64        =
Setup           =
Setup64         =
UsageCount      = 1
CPTimeout       =
CPReuse         =
Trace           = Yes
TraceFile       = /tmp/freetds.log
ForceTrace      = Yes

freetds.conf:
[global]
       # TDS protocol version
       tds version = 7.0
       client charset = UTF-8
       dump file = /tmp/freetds.log
       dump file append = yes
;       debug flags = 0xffff
       debug level = 10

       text size = 64512

[3pleP]
   host = xx.xx.xx.xx
   port = 1433
   tds version = 7.0

/home/notes/.odbc.ini:
[3pleP]
Driver          = FreeTDS
Description     = 3pleP
Trace           = No
Server          = xx.xx.xx.xx
Port            = 1433
Database        = ihp-training
TDS_Version     = 7.0