FreeTDS Development Group

["Michael Schodra" <mschodra AT pecos.de>]

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