Skip to Content.
Sympa Menu

freetds - [freetds] Cant's select columns with umlaute

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Michael Schodra" <mschodra AT pecos.de>
  • To: <freetds AT lists.ibiblio.org>
  • Subject: [freetds] Cant's select columns with umlaute
  • Date: Tue, 9 Dec 2008 13:07:51 +0100

Hello All,

I try to established a DB-Link from Oracle 11g to a MSSQL 2000 database but
it doesn't work.

We install on Centos 5.1 (Linux 64bit).
Our database is Oracle 11.1.0.6.0 plus bugfix 7389110 and we installed the
"linux.x64_11gR1_gateways".
I configured freetds and uinixodbc (see below)

I already told the unixodb folk about the problem, but they told me: ask the
freetds folk. So I do now and I hope you can help me?

Here is my configuration and the problem.


1. unixODBC (unixODBC-2.2.11)
1.1 /etc/freetds.conf
combandb <http://forums.oracle.com/forums/>
host = 212.xxx.xxx.5
port = 1433
tds version = 8.0

Client Charset = UTF-8

1.2 /etc/odbcinst:
FreeTDS <http://forums.oracle.com/forums/>
Description = v0.64-1
Driver = /usr/lib64/libtdsodbc.so.0
Setup = /usr/lib64/libtdsodbc.so.0
FileUsage = 1
Trace = Yes
TraceFile = /tmp/sql.log



ODBC <http://forums.oracle.com/forums/>
Trace = Yes
TraceFile = /tmp/sql.log
ForceTrace = Yes
Pooling = No

1.3. /etc/odbc.ini
ODBC Data Sources <http://forums.oracle.com/forums/>
combandb = SQL-Connect

combandb <http://forums.oracle.com/forums/>
Driver = FreeTDS
Description = DB-Link (MSSQL)
Trace = Yes
Database = namedb
TraceFile = /tmp/sql.log
Servername = combandb
Port = 1433

/tmp/SQL.LOG

When I try to connect using isql I get the following message:



SQL> isql combandb UN PW

Connected! |

SQL> select ID, Ort, Straße from x_lt;

ISQLERROR: Could not SQLPrepare



Here is the SQL-Log

ODBC]18163http://SQLConnect.c3549

Entry:

Connection = 0xa82f970

Server Name = combandblength = 8 (SQL_NTS)

User Name = [******length = 5 (SQL_NTS)

Authentication = *********length = 9 (SQL_NTS)

UNICODE Using encoding ASCII 'ISO8859-1' and UNICODE 'UCS-2LE'



ODBC18163http://SQLConnect.c4123

Exit:SQL_SUCCESS

ODBC18163http://SQLAllocHandle.c510

Entry:

Handle Type = 3

Input Handle = 0xa82f970

ODBC18163http://SQLAllocHandle.c872

Exit:SQL_SUCCESS

Output Handle = 0xa880670

ODBC18163http://SQLPrepare.c189

Entry:

Statement = 0xa880670

SQL = select ID, Ort, Straße from x_lt; length = 62 (SQL_NTS)

ODBC18163http://SQLPrepare.c364

Exit:SQL_ERROR

ODBC18163http://SQLFreeStmt.c140

Entry:

Statement = 0xa880670

Option = 1



Isql> select * from x_lt

Works well, but umlaute are missing.



Any idea is welcome!



Greetings

Michael









Archive powered by MHonArc 2.6.24.

Top of Page