HS ODBC

DG4 Quick review:

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