DG4 Quick review:
http://www.easysoft.com/applications/oracle/database-gateway-dg4odbc.html
http://docs.oracle.com/cd/B28359_01/gateways.111/b31042/configodbc.htm#CIHFEGDA
http://habrahabr.ru/blogs/oracle/113768/
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:4406709207206#18830681837358
http://download.oracle.com/docs/cd/A87860_01/doc/server.817/a76960/hs_genco.htm#173
http://download.oracle.com/docs/cd/B19306_01/server.102/b14232/toc.htm
http://www.orafusion.com/art_orahs.htm
http://www.dbapool.com/articles/06280701.html
http://www.opennet.ru/base/dev/oracle_link_mssql.txt.html
http://eventmix.ru/forum/showthread.php/38-DBLink-freeTDS-unixODBC
select 'create database link '||a.db_link||' connect to '||a.username||' identified by '||b.password||' using "'||a.HOST||'";' from dba_db_links a, sys.link$ b, dba_users c where a.owner=c.username and b.owner#=c.user_id and a.db_link=b.name and a.host=b.host and a.owner='PUBLIC';
create public database link ask22 connect to "ASKWORKFLOW" identified by "hjybjkm" using 'ASK';
drop public database link ask22;
select * from dba_db_links;
-- list links
COL OWNER FORMAT a10
COL USERNAME FORMAT A8 HEADING "USER"
COL DB_LINK FORMAT A30
COL HOST FORMAT A7 HEADING "SERVICE"
SELECT * FROM DBA_DB_LINKS;
FreeTDS
http://www.unixodbc.org/doc/FreeTDS.html
yum install yum-utils
yum install freetds
repoquery --list freetds
odbcinst -i -d -f tds.driver.template
http://www.freetds.org/userguide/odbcconnattr.htm
# cat tds.driver.template
[FreeTDS]
Description = v0.64 with protocol v8.0
Driver = /usr/lib64/libtdsodbc.so.0
cat tds.datasource.template
[MSSQLTestServer]
Driver = FreeTDS
Description = ODBC Test
Trace = No
Server = 172.23.10.111
Port = 1433
Database = test
-bash-3.2$ odbcinst -i -s -f tds.datasource.template
isql -v MSSQLTestServer odbc qweasd (odbc - login, qweasd - password)
SQL> select name from test.sysobjects where xtype = 'U';
Generic connectivity (ODBC)
http://download.oracle.com/docs/cd/B19306_01/server.102/b14232/gencon.htm#g1012648
http://download.oracle.com/docs/cd/B28359_01/server.111/b28286/statements_5005.htm
--config - /u01/app/oracle/product/10.2.0/db_1/hs/admin
tnsping mstest
create public database link mstest connect to "sa" identified by "xxx" using 'MSTEST';
drop public database link mstest
select * from "dbo.tst1"@mstest
select * from tst2@mstest
tsql -S MSTEST -U sa -P xxx
isql -v MSTEST Workflow xxx
-- plays with charset through hs
SQL> select * from nls_database_parameters where parameter like '%CHARACTERSET';
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_CHARACTERSET CL8MSWIN1251
RUSSIAN_CIS.AL32UTF8
AMERICAN_AMERICA