{"id":16763,"date":"2021-11-02T17:02:22","date_gmt":"2021-11-02T16:02:22","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/configuring-odbc-sqlserver-access-from-oracle\/"},"modified":"2023-06-20T10:08:14","modified_gmt":"2023-06-20T08:08:14","slug":"configuring-odbc-sqlserver-access-from-oracle","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/configuring-odbc-sqlserver-access-from-oracle\/","title":{"rendered":"Configuring ODBC : SQLServer Access From Oracle"},"content":{"rendered":"

By Mouhamadou Diaw<\/strong><\/p>\n

Sometimes you need to access to your SQLServer from your Oracle database. There is many ways and tools to do this. In this blog I am describing how to perform this task using ODBC.
\nThe configuration is below
\n-Oracle Linux server : serverora 192.168.56.41 with Oracle 19 database orcl
\n-Windows server : winrac1 192.168.56.100 with SQLServer Express<\/p>\n

On my Windows server, I have a database named testdb and a table named article.<\/p>\n

The first step is to verify that the file dg4odbc is present in your ORACLE_HOME environment<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n<\/td>\n
\n
\n
[oracle@serverora ~]$ <\/code>cd<\/code> $ORACLE_HOME<\/code>\/bin<\/code><\/div>\n
<\/div>\n
[oracle@serverora bin]$ <\/code>file<\/code> dg4odbc<\/code><\/div>\n
dg4odbc: ELF 64-bit LSB executable, x86-64, version 1 (SYSV), dynamically linked (uses shared libs), <\/code>for<\/code> GNU<\/code>\/Linux<\/code> 2.6.32, BuildID[sha1]=11d0b16445c4b65545b285a222628e03c99e8900, not stripped<\/code><\/div>\n
[oracle@serverora bin]$<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

After this we do install the ODBC driver for SQLServer on our Oracle server
\n-Install the repository<\/strong><\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n<\/td>\n
\n
\n
[root@serverora yum.repos.d]<\/code># curl https:\/\/packages.microsoft.com\/config\/rhel\/7\/prod.repo<\/a> > \/etc\/yum.repos.d\/mssql-release.repo<\/code><\/div>\n
\u00a0\u00a0<\/code>% Total\u00a0\u00a0\u00a0 % Received % Xferd\u00a0 Average Speed\u00a0\u00a0 Time\u00a0\u00a0\u00a0 Time\u00a0\u00a0\u00a0\u00a0 Time\u00a0 Current<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>Dload\u00a0 Upload\u00a0\u00a0 Total\u00a0\u00a0 Spent\u00a0\u00a0\u00a0 Left\u00a0 Speed<\/code><\/div>\n
100\u00a0\u00a0 193\u00a0 100\u00a0\u00a0 193\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0\u00a0 0\u00a0\u00a0\u00a0 265\u00a0\u00a0\u00a0\u00a0\u00a0 0 --:--:-- --:--:-- --:--:--\u00a0\u00a0 265<\/code><\/div>\n
[root@serverora yum.repos.d]<\/code>#<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

-Search the name of the package<\/strong><\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n<\/td>\n
\n
\n
[root@serverora yum.repos.d]<\/code># yum search msodbc<\/code><\/div>\n
Loaded plugins: ulninfo<\/code><\/div>\n
epel<\/code>\/x86_64\/metalink<\/code>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0 19 kB\u00a0 00:00:00<\/code><\/div>\n
epel\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 4.7 kB\u00a0 00:00:00<\/code><\/div>\n
ol7_UEKR5\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 3.0 kB\u00a0 00:00:00<\/code><\/div>\n
ol7_latest\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 3.6 kB\u00a0 00:00:00<\/code><\/div>\n
...<\/code><\/div>\n
...<\/code><\/div>\n
=============================================== N<\/code>\/S<\/code> matched: msodbc ================================================<\/code><\/div>\n
msodbcsql.x86_64 : ODBC Driver <\/code>for<\/code> Microsoft(R) SQL Server(R)<\/code><\/div>\n
msodbcsql17.x86_64 : ODBC Driver <\/code>for<\/code> Microsoft(R) SQL Server(R)<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0<\/code>Name and summary matches only, use <\/code>\"search all\"<\/code> for<\/code> everything.<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

-Install the package msodbcsql17<\/strong>
\nYou can find more info in the documentation <\/a><\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n
29<\/div>\n
30<\/div>\n
31<\/div>\n
32<\/div>\n
33<\/div>\n
34<\/div>\n
35<\/div>\n
36<\/div>\n
37<\/div>\n
38<\/div>\n
39<\/div>\n
40<\/div>\n
41<\/div>\n
42<\/div>\n
43<\/div>\n
44<\/div>\n
45<\/div>\n
46<\/div>\n
47<\/div>\n
48<\/div>\n
49<\/div>\n
50<\/div>\n
51<\/div>\n
52<\/div>\n
53<\/div>\n
54<\/div>\n
55<\/div>\n
56<\/div>\n
57<\/div>\n
58<\/div>\n
59<\/div>\n
60<\/div>\n
61<\/div>\n
62<\/div>\n<\/td>\n
\n
\n
[root@serverora yum.repos.d]<\/code># yum remove unixODBC-utf16 unixODBC-utf16-devel<\/code><\/div>\n
Loaded plugins: ulninfo<\/code><\/div>\n
No Match <\/code>for<\/code> argument: unixODBC-utf16<\/code><\/div>\n
No Match <\/code>for<\/code> argument: unixODBC-utf16-devel<\/code><\/div>\n
No Packages marked <\/code>for<\/code> removal<\/code><\/div>\n
<\/div>\n
[root@serverora yum.repos.d]<\/code># ACCEPT_EULA=Y yum install -y msodbcsql17<\/code><\/div>\n
Loaded plugins: ulninfo<\/code><\/div>\n
Resolving Dependencies<\/code><\/div>\n
--> Running transaction check<\/code><\/div>\n
---> Package msodbcsql17.x86_64 0:17.8.1.1-1 will be installed<\/code><\/div>\n
--> Processing Dependency: unixODBC >= 2.3.1 <\/code>for<\/code> package: msodbcsql17-17.8.1.1-1.x86_64<\/code><\/div>\n
--> Processing Dependency: libodbcinst.so.2()(64bit) <\/code>for<\/code> package: msodbcsql17-17.8.1.1-1.x86_64<\/code><\/div>\n
--> Running transaction check<\/code><\/div>\n
---> Package unixODBC.x86_64 0:2.3.7-1.rh will be installed<\/code><\/div>\n
--> Finished Dependency Resolution<\/code><\/div>\n
<\/div>\n
Dependencies Resolved<\/code><\/div>\n
<\/div>\n
====================================================================================================================<\/code><\/div>\n
\u00a0<\/code>Package\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Arch\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Version\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Repository\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Size<\/code><\/div>\n
====================================================================================================================<\/code><\/div>\n
Installing:<\/code><\/div>\n
\u00a0<\/code>msodbcsql17\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 x86_64\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 17.8.1.1-1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 packages-microsoft-com-prod\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 905 k<\/code><\/div>\n
Installing <\/code>for<\/code> dependencies:<\/code><\/div>\n
\u00a0<\/code>unixODBC\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 x86_64\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2.3.7-1.rh\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 packages-microsoft-com-prod\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 213 k<\/code><\/div>\n
<\/div>\n
Transaction Summary<\/code><\/div>\n
====================================================================================================================<\/code><\/div>\n
Install\u00a0 1 Package (+1 Dependent package)<\/code><\/div>\n
<\/div>\n
Total download size: 1.1 M<\/code><\/div>\n
Installed size: 2.9 M<\/code><\/div>\n
Downloading packages:<\/code><\/div>\n
warning: <\/code>\/var\/cache\/yum\/x86_64\/7Server\/packages-microsoft-com-prod\/packages\/unixODBC-2<\/code>.3.7-1.rh.x86_64.rpm: Header V4 RSA<\/code>\/SHA256<\/code> Signature, key ID be1229cf: NOKEY<\/code><\/div>\n
Public key <\/code>for<\/code> unixODBC-2.3.7-1.rh.x86_64.rpm is not installed<\/code><\/div>\n
(1<\/code>\/2<\/code>): unixODBC-2.3.7-1.rh.x86_64.rpm\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 213 kB\u00a0 00:00:00<\/code><\/div>\n
(2<\/code>\/2<\/code>): msodbcsql17-17.8.1.1-1.x86_64.rpm\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 905 kB\u00a0 00:00:00<\/code><\/div>\n
--------------------------------------------------------------------------------------------------------------------<\/code><\/div>\n
Total\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1.9 MB<\/code>\/s<\/code> | 1.1 MB\u00a0 00:00:00<\/code><\/div>\n
Retrieving key from https:<\/code>\/\/packages<\/code>.microsoft.com<\/code>\/keys\/microsoft<\/code>.asc<\/code><\/div>\n
Importing GPG key 0xBE1229CF:<\/code><\/div>\n
\u00a0<\/code>Userid\u00a0\u00a0\u00a0\u00a0 : <\/code>\"Microsoft (Release signing) \"<\/code><\/div>\n
\u00a0<\/code>Fingerprint: bc52 8686 b50d 79e3 39d3 721c eb3e 94ad be12 29cf<\/code><\/div>\n
\u00a0<\/code>From\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : https:<\/code>\/\/packages<\/code>.microsoft.com<\/code>\/keys\/microsoft<\/code>.asc<\/code><\/div>\n
Running transaction check<\/code><\/div>\n
Running transaction <\/code>test<\/code><\/div>\n
Transaction <\/code>test<\/code> succeeded<\/code><\/div>\n
Running transaction<\/code><\/div>\n
\u00a0\u00a0<\/code>Installing : unixODBC-2.3.7-1.rh.x86_64\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<\/code>\/2<\/code><\/div>\n
\u00a0\u00a0<\/code>Installing : msodbcsql17-17.8.1.1-1.x86_64\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2<\/code>\/2<\/code><\/div>\n
\u00a0\u00a0<\/code>Verifying\u00a0 : msodbcsql17-17.8.1.1-1.x86_64\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<\/code>\/2<\/code><\/div>\n
\u00a0\u00a0<\/code>Verifying\u00a0 : unixODBC-2.3.7-1.rh.x86_64\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2<\/code>\/2<\/code><\/div>\n
<\/div>\n
Installed:<\/code><\/div>\n
\u00a0\u00a0<\/code>msodbcsql17.x86_64 0:17.8.1.1-1<\/code><\/div>\n
<\/div>\n
Dependency Installed:<\/code><\/div>\n
\u00a0\u00a0<\/code>unixODBC.x86_64 0:2.3.7-1.rh<\/code><\/div>\n
<\/div>\n
Complete!<\/code><\/div>\n
[root@serverora yum.repos.d]<\/code>#<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

-Install the package mssql-tools<\/strong><\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n
29<\/div>\n
30<\/div>\n
31<\/div>\n
32<\/div>\n
33<\/div>\n
34<\/div>\n
35<\/div>\n<\/td>\n
\n
\n
[root@serverora yum.repos.d]<\/code># ACCEPT_EULA=Y yum install -y mssql-tools<\/code><\/div>\n
Loaded plugins: ulninfo<\/code><\/div>\n
Resolving Dependencies<\/code><\/div>\n
--> Running transaction check<\/code><\/div>\n
---> Package mssql-tools.x86_64 0:17.8.1.1-1 will be installed<\/code><\/div>\n
--> Finished Dependency Resolution<\/code><\/div>\n
<\/div>\n
Dependencies Resolved<\/code><\/div>\n
<\/div>\n
====================================================================================================================<\/code><\/div>\n
\u00a0<\/code>Package\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Arch\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Version\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Repository\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Size<\/code><\/div>\n
====================================================================================================================<\/code><\/div>\n
Installing:<\/code><\/div>\n
\u00a0<\/code>mssql-tools\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 x86_64\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 17.8.1.1-1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 packages-microsoft-com-prod\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 287 k<\/code><\/div>\n
<\/div>\n
Transaction Summary<\/code><\/div>\n
====================================================================================================================<\/code><\/div>\n
Install\u00a0 1 Package<\/code><\/div>\n
<\/div>\n
Total download size: 287 k<\/code><\/div>\n
Installed size: 714 k<\/code><\/div>\n
Downloading packages:<\/code><\/div>\n
mssql-tools-17.8.1.1-1.x86_64.rpm\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 | 287 kB\u00a0 00:00:00<\/code><\/div>\n
Running transaction check<\/code><\/div>\n
Running transaction <\/code>test<\/code><\/div>\n
Transaction <\/code>test<\/code> succeeded<\/code><\/div>\n
Running transaction<\/code><\/div>\n
\u00a0\u00a0<\/code>Installing : mssql-tools-17.8.1.1-1.x86_64\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<\/code>\/1<\/code><\/div>\n
\u00a0\u00a0<\/code>Verifying\u00a0 : mssql-tools-17.8.1.1-1.x86_64\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<\/code>\/1<\/code><\/div>\n
<\/div>\n
Installed:<\/code><\/div>\n
\u00a0\u00a0<\/code>mssql-tools.x86_64 0:17.8.1.1-1<\/code><\/div>\n
<\/div>\n
Complete!<\/code><\/div>\n
[root@serverora yum.repos.d]<\/code>#<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

-Install the unixODBC-devel package<\/strong><\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n
29<\/div>\n
30<\/div>\n
31<\/div>\n
32<\/div>\n
33<\/div>\n
34<\/div>\n
35<\/div>\n<\/td>\n
\n
\n
[root@serverora bin]<\/code># yum install -y unixODBC-devel<\/code><\/div>\n
Loaded plugins: ulninfo<\/code><\/div>\n
Resolving Dependencies<\/code><\/div>\n
--> Running transaction check<\/code><\/div>\n
---> Package unixODBC-devel.x86_64 0:2.3.7-1.rh will be installed<\/code><\/div>\n
--> Finished Dependency Resolution<\/code><\/div>\n
<\/div>\n
Dependencies Resolved<\/code><\/div>\n
<\/div>\n
====================================================================================================================<\/code><\/div>\n
\u00a0<\/code>Package\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Arch\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Version\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Repository\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Size<\/code><\/div>\n
====================================================================================================================<\/code><\/div>\n
Installing:<\/code><\/div>\n
\u00a0<\/code>unixODBC-devel\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 x86_64\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2.3.7-1.rh\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 packages-microsoft-com-prod\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 42 k<\/code><\/div>\n
<\/div>\n
Transaction Summary<\/code><\/div>\n
====================================================================================================================<\/code><\/div>\n
Install\u00a0 1 Package<\/code><\/div>\n
<\/div>\n
Total download size: 42 k<\/code><\/div>\n
Installed size: 196 k<\/code><\/div>\n
Downloading packages:<\/code><\/div>\n
unixODBC-devel-2.3.7-1.rh.x86_64.rpm\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |\u00a0 42 kB\u00a0 00:00:00<\/code><\/div>\n
Running transaction check<\/code><\/div>\n
Running transaction <\/code>test<\/code><\/div>\n
Transaction <\/code>test<\/code> succeeded<\/code><\/div>\n
Running transaction<\/code><\/div>\n
\u00a0\u00a0<\/code>Installing : unixODBC-devel-2.3.7-1.rh.x86_64\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<\/code>\/1<\/code><\/div>\n
\u00a0\u00a0<\/code>Verifying\u00a0 : unixODBC-devel-2.3.7-1.rh.x86_64\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1<\/code>\/1<\/code><\/div>\n
<\/div>\n
Installed:<\/code><\/div>\n
\u00a0\u00a0<\/code>unixODBC-devel.x86_64 0:2.3.7-1.rh<\/code><\/div>\n
<\/div>\n
Complete!<\/code><\/div>\n
[root@serverora bin]<\/code>#<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Now we can edit the odbc files. Below the contents of my files
\n-\/etc\/odbc.ini<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n<\/td>\n
\n
\n
[root@serverora etc]<\/code># cat odbc.ini<\/code><\/div>\n
[MY_ODBC_TEST]<\/code><\/div>\n
Driver = <\/code>\/opt\/microsoft\/msodbcsql17\/lib64\/libmsodbcsql-17<\/code>.8.so.1.1<\/code><\/div>\n
Server = winrac1<\/code><\/div>\n
Port = 1433<\/code><\/div>\n
Database = testdb<\/code><\/div>\n
<\/div>\n
[root@serverora etc]<\/code>#<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

-\/etc\/odbcinst.ini<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n<\/td>\n
\n
\n
[root@serverora etc]<\/code># cat odbcinst.ini<\/code><\/div>\n
[ODBC Driver 17 <\/code>for<\/code> SQL Server]<\/code><\/div>\n
Description=Microsoft ODBC Driver 17 <\/code>for<\/code> SQL Server<\/code><\/div>\n
Driver=<\/code>\/opt\/microsoft\/msodbcsql17\/lib64\/libmsodbcsql-17<\/code>.8.so.1.1<\/code><\/div>\n
UsageCount=1<\/code><\/div>\n
<\/div>\n
[root@serverora etc]<\/code>#<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Be sure that the Driver is pointing to the right location for libmsodbcsql-17.8.so.1.1<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n<\/td>\n
\n
\n
[oracle@serverora lib64]$ <\/code>ls<\/code> -l <\/code>\/opt\/microsoft\/msodbcsql17\/lib64\/libmsodbcsql-17<\/code>.8.so.1.1<\/code><\/div>\n
-rwxr-xr-x. 1 root root 2065184 Jun 26 12:34 <\/code>\/opt\/microsoft\/msodbcsql17\/lib64\/libmsodbcsql-17<\/code>.8.so.1.1<\/code><\/div>\n
[oracle@serverora lib64]$<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Now let\u2019s validate the connexion ODBC to the SQLserver database from the Oracle server<\/p>\n

-Using sqlcmd<\/strong><\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n<\/td>\n
\n
\n
[oracle@delphixdev1 ~]$ <\/code>\/opt\/mssql-tools\/bin\/sqlcmd<\/code> -D -S MY_ODBC_TEST -U sa<\/code><\/div>\n
Password:<\/code><\/div>\n
1> <\/code>select<\/code> * from article;<\/code><\/div>\n
2> go<\/code><\/div>\n
idart\u00a0 designation<\/code><\/div>\n
------ --------------------------------------------------<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>1 boisson<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>2 \u00e9cran<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>3 o\u00f9<\/code><\/div>\n
<\/div>\n
(3 rows affected)<\/code><\/div>\n
1><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

-Using isql<\/strong><\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n<\/td>\n
\n
\n
[oracle@serverora opt]$ <\/code>which<\/code> isql<\/code><\/div>\n
\/usr\/bin\/isql<\/code><\/div>\n
<\/div>\n
[oracle@serverora ~]$ isql -<\/code>v<\/code> MY_ODBC_TEST sa root<\/code><\/div>\n
+---------------------------------------+<\/code><\/div>\n
| Connected!\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
| sql-statement\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
| help [tablename]\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
| quit\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
|\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
+---------------------------------------+<\/code><\/div>\n
SQL> <\/code>select<\/code> * from article;<\/code><\/div>\n
+-------+---------------------------------------------------+<\/code><\/div>\n
| idart | designation\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
+-------+---------------------------------------------------+<\/code><\/div>\n
| 1\u00a0\u00a0\u00a0\u00a0 | boisson\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
| 2\u00a0\u00a0\u00a0\u00a0 | \u00e9cran\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
| 3\u00a0\u00a0\u00a0\u00a0 | o\u00f9\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 |<\/code><\/div>\n
+-------+---------------------------------------------------+<\/code><\/div>\n
SQLRowCount returns 0<\/code><\/div>\n
3 rows fetched<\/code><\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

We can see above that I can query my article table in the SQLServer database from my Oracle server.<\/p>\n

On the Oracle server let\u2019s create the file inithsconnect.ora for the instance hsconnect (you can choose another name for the instance if you want)<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n<\/td>\n
\n
\n
[oracle@serverora admin]$ <\/code>pwd<\/code><\/div>\n
\/u01\/app\/oracle\/product\/19<\/code>.0.0<\/code>\/db_1\/hs\/admin<\/code><\/div>\n
<\/div>\n
[oracle@serverora admin]$ <\/code>cat<\/code> inithsconnect.ora<\/code><\/div>\n
HS_FDS_CONNECT_INFO = MY_ODBC_TEST<\/code><\/div>\n
HS_FDS_TRACE_LEVEL = user<\/code><\/div>\n
HS_FDS_SHAREABLE_NAME = <\/code>\/opt\/microsoft\/msodbcsql17\/lib64\/libmsodbcsql-17<\/code>.8.so.1.1<\/code><\/div>\n
set<\/code> ODBCINI = <\/code>\/etc\/odbc<\/code>.ini<\/code><\/div>\n
HS_NLS_NCHAR = UCS2<\/code><\/div>\n
<\/div>\n
[oracle@serverora admin]$<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

On the Oracle server let\u2019s adjust the listener.ora to add a static entry for the instance hsconnect<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n<\/td>\n
\n
\n
[oracle@serverora admin]$ <\/code>pwd<\/code><\/div>\n
\/u01\/app\/oracle\/product\/19<\/code>.0.0<\/code>\/db_1\/network\/admin<\/code><\/div>\n
<\/div>\n
[oracle@serverora admin]$ <\/code>cat<\/code> listener.ora<\/code><\/div>\n
# listener.ora Network Configuration File: \/u01\/app\/oracle\/product\/19.0.0\/db_1\/network\/admin\/listener.ora<\/code><\/div>\n
# Generated by Oracle configuration tools.<\/code><\/div>\n
<\/div>\n
LISTENER =<\/code><\/div>\n
\u00a0\u00a0<\/code>(DESCRIPTION_LIST =<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>(DESCRIPTION =<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.56.41)(PORT = 1521))<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0<\/code>)<\/code><\/div>\n
\u00a0\u00a0<\/code>)<\/code><\/div>\n
<\/div>\n
SID_LIST_LISTENER =<\/code><\/div>\n
\u00a0<\/code>(SID_LIST =<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>(SID_DESC=<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>(SID_NAME=hsconnect)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>(ORACLE_HOME= <\/code>\/u01\/app\/oracle\/product\/19<\/code>.0.0<\/code>\/db_1<\/code>)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>(PROGRAM=dg4odbc)<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>(ENVS=LD_LIBRARY_PATH=<\/code>\/opt\/microsoft\/msodbcsql17\/lib64<\/code>)<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>)<\/code><\/div>\n
\u00a0<\/code>)<\/code><\/div>\n
<\/div>\n
[oracle@serverora admin]$<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

On the Oracle server let\u2019s add an entry for instance hsconnect<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n<\/td>\n
\n
\n
hsconnect=<\/code><\/div>\n
\u00a0<\/code>(DESCRIPTION=<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.41)(PORT=1521))<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>(CONNECT_DATA= (SID=hsconnect))<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>(HS=OK)<\/code><\/div>\n
\u00a0\u00a0\u00a0<\/code>)<\/code><\/div>\n
\u00a0<\/code>)<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Be sure that you can do a tnsping to your hsconnect alias<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n<\/td>\n
\n
\n
[oracle@serverora admin]$ tnsping\u00a0 hsconnect<\/code><\/div>\n
<\/div>\n
TNS Ping Utility <\/code>for<\/code> Linux: Version 19.0.0.0.0 - Production on 29-OCT-2021 12:33:50<\/code><\/div>\n
<\/div>\n
Copyright (c) 1997, 2020, Oracle.\u00a0 All rights reserved.<\/code><\/div>\n
<\/div>\n
Used parameter files:<\/code><\/div>\n
\/u01\/app\/oracle\/product\/19<\/code>.0.0<\/code>\/db_1\/network\/admin\/sqlnet<\/code>.ora<\/code><\/div>\n
<\/div>\n
<\/div>\n
Used TNSNAMES adapter to resolve the <\/code>alias<\/code><\/div>\n
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.56.41)(PORT=1521)) (CONNECT_DATA= (SID=hsconnect)) (HS=OK))<\/code><\/div>\n
OK (0 msec)<\/code><\/div>\n
[oracle@serverora admin]$<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

From your Oracle database, create a dblink pointing to your SQLServer and test your dblink<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n<\/td>\n
\n
\n
SQL> create public database link hslink connect to <\/code>\"sa\"<\/code> identified by <\/code>\"root\"<\/code> using <\/code>'hsconnect'<\/code>;<\/code><\/div>\n
<\/div>\n
Database link created.<\/code><\/div>\n
<\/div>\n
SQL>\u00a0 <\/code>select<\/code> * from dual@hslink;<\/code><\/div>\n
<\/div>\n
D<\/code><\/div>\n
-<\/code><\/div>\n
X<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

And then finally you should be able to query your SQLServer article table from your Oracle database<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n<\/td>\n
\n
\n
SQL> <\/code>select<\/code> * from article@hslink;<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>idart designation<\/code><\/div>\n
---------- -----------------------------------<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>1 boisson<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>2 ecran<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>3 ou<\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

To resolve the issue with the French accents, just set the NLS_LANG as below<\/p>\n

\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n<\/td>\n
\n
\n
[oracle@serverora admin]$ <\/code>export<\/code> NLS_LANG=AMERICAN_AMERICA.UTF8<\/code><\/div>\n
<\/div>\n
[oracle@serverora admin]$ sqlplus \/ as sysdba<\/code><\/div>\n
<\/div>\n
SQL*Plus: Release 19.0.0.0.0 - Production on Fri Oct 29 13:15:11 2021<\/code><\/div>\n
Version 19.10.0.0.0<\/code><\/div>\n
<\/div>\n
Copyright (c) 1982, 2020, Oracle.\u00a0 All rights reserved.<\/code><\/div>\n
<\/div>\n
<\/div>\n
Connected to:<\/code><\/div>\n
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production<\/code><\/div>\n
Version 19.10.0.0.0<\/code><\/div>\n
<\/div>\n
SQL> col designation <\/code>for<\/code> a25<\/code><\/div>\n
SQL> <\/code>select<\/code> * from article@hslink;<\/code><\/div>\n
<\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>idart designation<\/code><\/div>\n
---------- -------------------------<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>1 boisson<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>2 \u00e9cran<\/code><\/div>\n
\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0<\/code>3 o\u00f9<\/code><\/div>\n
<\/div>\n
SQL><\/code><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n

Conclusion<\/h3>\n

Hope this article will help<\/p>\n","protected":false},"excerpt":{"rendered":"

By Mouhamadou Diaw Sometimes you need to access to your SQLServer from your Oracle database. There is many ways and tools to do this. In this blog I am describing how to perform this task using ODBC. The configuration is below -Oracle Linux server : serverora 192.168.56.41 with Oracle 19 database orcl -Windows server : […]<\/p>\n","protected":false},"author":27,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[229,198,42,59,99],"tags":[2405,1968,2406],"type_dbi":[],"class_list":["post-16763","post","type-post","status-publish","format-standard","hentry","category-database-administration-monitoring","category-database-management","category-operating-systems","category-oracle","category-sql-server","tag-odbc","tag-oracle-19","tag-sqlserver-access-from-oracle"],"acf":[],"yoast_head":"\nConfiguring ODBC : SQLServer Access From Oracle - dbi Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/configuring-odbc-sqlserver-access-from-oracle\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Configuring ODBC : SQLServer Access From Oracle\" \/>\n<meta property=\"og:description\" content=\"By Mouhamadou Diaw Sometimes you need to access to your SQLServer from your Oracle database. There is many ways and tools to do this. In this blog I am describing how to perform this task using ODBC. The configuration is below -Oracle Linux server : serverora 192.168.56.41 with Oracle 19 database orcl -Windows server : […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/configuring-odbc-sqlserver-access-from-oracle\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-11-02T16:02:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-20T08:08:14+00:00\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/configuring-odbc-sqlserver-access-from-oracle\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/configuring-odbc-sqlserver-access-from-oracle\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Configuring ODBC : SQLServer Access From Oracle\",\"datePublished\":\"2021-11-02T16:02:22+00:00\",\"dateModified\":\"2023-06-20T08:08:14+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/configuring-odbc-sqlserver-access-from-oracle\/\"},\"wordCount\":332,\"commentCount\":6,\"keywords\":[\"ODBC\",\"Oracle 19\",\"SQLServer access from Oracle\"],\"articleSection\":[\"Database Administration & Monitoring\",\"Database management\",\"Operating systems\",\"Oracle\",\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/configuring-odbc-sqlserver-access-from-oracle\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/configuring-odbc-sqlserver-access-from-oracle\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/configuring-odbc-sqlserver-access-from-oracle\/\",\"name\":\"Configuring ODBC : SQLServer Access From Oracle - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"datePublished\":\"2021-11-02T16:02:22+00:00\",\"dateModified\":\"2023-06-20T08:08:14+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/configuring-odbc-sqlserver-access-from-oracle\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/configuring-odbc-sqlserver-access-from-oracle\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/configuring-odbc-sqlserver-access-from-oracle\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Configuring ODBC : SQLServer Access From Oracle\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Configuring ODBC : SQLServer Access From Oracle - dbi Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/configuring-odbc-sqlserver-access-from-oracle\/","og_locale":"en_US","og_type":"article","og_title":"Configuring ODBC : SQLServer Access From Oracle","og_description":"By Mouhamadou Diaw Sometimes you need to access to your SQLServer from your Oracle database. There is many ways and tools to do this. In this blog I am describing how to perform this task using ODBC. The configuration is below -Oracle Linux server : serverora 192.168.56.41 with Oracle 19 database orcl -Windows server : […]","og_url":"https:\/\/www.dbi-services.com\/blog\/configuring-odbc-sqlserver-access-from-oracle\/","og_site_name":"dbi Blog","article_published_time":"2021-11-02T16:02:22+00:00","article_modified_time":"2023-06-20T08:08:14+00:00","author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/configuring-odbc-sqlserver-access-from-oracle\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/configuring-odbc-sqlserver-access-from-oracle\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Configuring ODBC : SQLServer Access From Oracle","datePublished":"2021-11-02T16:02:22+00:00","dateModified":"2023-06-20T08:08:14+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/configuring-odbc-sqlserver-access-from-oracle\/"},"wordCount":332,"commentCount":6,"keywords":["ODBC","Oracle 19","SQLServer access from Oracle"],"articleSection":["Database Administration & Monitoring","Database management","Operating systems","Oracle","SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/configuring-odbc-sqlserver-access-from-oracle\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/configuring-odbc-sqlserver-access-from-oracle\/","url":"https:\/\/www.dbi-services.com\/blog\/configuring-odbc-sqlserver-access-from-oracle\/","name":"Configuring ODBC : SQLServer Access From Oracle - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"datePublished":"2021-11-02T16:02:22+00:00","dateModified":"2023-06-20T08:08:14+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/configuring-odbc-sqlserver-access-from-oracle\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/configuring-odbc-sqlserver-access-from-oracle\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/configuring-odbc-sqlserver-access-from-oracle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Configuring ODBC : SQLServer Access From Oracle"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16763","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=16763"}],"version-history":[{"count":1,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16763\/revisions"}],"predecessor-version":[{"id":26126,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/16763\/revisions\/26126"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=16763"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=16763"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=16763"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=16763"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}