Re: connect to external DB ( sqlserver ) via JDBC

From: Mladen Gogala <no_at_email.here.invalid>
Date: Tue, 22 Jun 2010 20:14:22 +0000 (UTC)
Message-ID: <pan.2010.06.22.20.14.21_at_email.here.invalid>

On Tue, 22 Jun 2010 19:49:18 +0000, Mladen Gogala wrote:

> On Tue, 22 Jun 2010 08:27:26 -0700, amoroder wrote:
> 

>> Hello,
>>
>> I remember that we tested this years ago( DB on windows with ODBC ) ,
>> but don't know where to search for dcumentation today.
>>
>> Is it possible to create a link to a non oracle db ( sqlserver or
>> other ) from our oracle 11 DB ?
>> Is the access to the external tables transparent ?
>>
>> Thanks
>> Andreas

> 
> 
> It is possible. I tested it on Red Hat 5.2 (the current version is 5.5)
> with unixODBC and freeTDS, I was able to connect to SQL Server and
> select data. Mixed transactions are not supported. That, in particular,
> means that you can not push data from Oracle. You can do insert as
> select, you can even create a view, but no mixed transactions.

The only problem I had was with the character set. The setting I had to check was HS_LANGUAGE. The setting that did the trick for me was HS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P1

-- 
http://mgogala.byethost5.com

Received on Tue Jun 22 2010 - 15:14:22 CDT