Re: Problems with FreeTDS and Lotus Domino on SLES10SP1

Il giorno gio, 13/11/2008 alle 15.13 +0100, Nicole Hähnel ha scritto:
> 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)
> 

Good

> The first problem are datetime fields which were interpreted as 
> "undefined" fields in the Lotus Domino agent.

?? Perhaps Lotus Domino does not support date from ODBC ??

> 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.
> 

Perhaps an ODBC trace would help. Do perhaps Lotus use ODBC 3 and bind
with ODBC 2 types??

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

It's not clear to me here did you read data. From a file and then stored
in db or id db data correct and you get character 127 ??

> 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

Configuration is ok

Regards
  Frediano Ziglio