[freetds] Problems with FreeTDS and Lotus Domino on SLES10SP1
Nicole Hähnel
ml at nicole-haehnel.de
Thu Nov 13 09:13:52 EST 2008
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
More information about the FreeTDS
mailing list