Skip to Content.
Sympa Menu

freetds - [freetds] Problems with FreeTDS and Lotus Domino on SLES10SP1

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Nicole Hähnel <ml AT nicole-haehnel.de>
  • To: freetds AT lists.ibiblio.org
  • Subject: [freetds] Problems with FreeTDS and Lotus Domino on SLES10SP1
  • Date: Thu, 13 Nov 2008 15:13:52 +0100

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




Archive powered by MHonArc 2.6.24.

Top of Page