What do I need to access an Informix db from Oracle ? - Heterogeneous Connectivity

Hi.
I need to access an Informix db from Oracle, through distributed transactions. Do I need the Oracle Transparent Gateway for Informix or may I use an ODBC access through generic connectivity ?
According to the manual "Oracle8i Distributed Database Systems" it's posiible to access through generic connectivity any data source that is ODBC compliant. Can I install an ODBC driver on AIX to access informix ?
Thank you in advance,
Sebastian.

Sebastian,
Generic Connectivity does not support distributed transactions.
You can use the Transparent Gateway for Informix.
It is available on Solaris and HP.
Note that the gateway can be installed on any machine.
It can be installed on the machine where Oracle is running or the machine where the non-Oracle system is installed or a third machine. 

Thanks for your answer.

Related

Solaris an MSSQL Server connectivity

Hi, I need connect a Oracle Database 10g under Solaris with a MSSQL Server 2000.
I read in the data sheet "Oracle Generic Connectivity and
Oracle Transparent Gateway" (http://www.oracle.com/technology/products/gateways/gateways_fov.html) that not exist the oracle gateway for MSSQL in solaris.
is it posible with generic ODBC connection?
Thanks. 
I'm in the same boat
10gR2#Solaris8/SPARC <--> Sql Server 2K#Windoz
Nedd to get data FROM Sql Server
Any help please ? 
You either need an ODBC driver for Unix or a Windows Oracle server with ODBC connectivity defined for the SQL Server instance. If you already have an Oracle server on Winodws I would go that route then see the following
link for more info:
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14232/gencon.htm#sthref344 
Under Linux/Solaris you can use e.g. HSODBC with
http://www.datadirect.com/products/odbc/index.ssp.
But costs a lot of money.
For simple batch jobs I use the mssql jdbc driver.

Using Heterogeneous to connect to Sybase databse

Hello,
Here is my situation, I have two SUN boxes , one for Oracle database and other for Sybase database. I would like to use Sybase database from Oracle using windows ODBC. How do I configure this, do I have to install ODBC on Oracle server too?
Thanks
Syed 
In my eyes this does not make much sense, but...
You have 2 SUN boxes and want to connect from an Oracle DB on SUN to Sybase on another SUN box.
In general you have 2 options: GENEIC CONNECTIVITY and Gateway.
The gateway requires a sep. license, whereas the gateway is for free but requires an additional ODBC driver (on Unix; on MS platforms it's delivered for free most of the time...).
The gateway has the advantage, that you can install it on a different machine then the Oracle DB; also on Windows...
HSODBC is for free and ported to a few platforms (like SUN). HSODBC MUST be installed on the same machine like the Oracle DB. So you need an ODBC driver on the SUN machine.
You can get ODBC drivers from OPENLINK or Data Direct, but they require also a license. The other option is to use the EASYSOFT ODBC/ODBC bridge. Easysoft offers an splitted solution: you connect with their SUN based part to the Windows machine and there you call the windows based ODBC driver.
But this solution is also not for free.
So it's a simple calculation -> all require a licence you must purchse. In many cases the Gateway is the cheaper solution and if you later on plan to use distributed transaction the gateway is the only choice....
What do you mean by "The gateway requires a sep. license, whereas the gateway is for free but requires an additional ODBC driver ". Are you saing that Hetrogeneous connectivity is free and gateway require seperate license?
I was able to configure this setup. I downloaded ODBC driver from data direct and just followed the metlink note.
Now I can connect to Sybase from any client/web application using Oracle database.
Syed

Configuring Hetrogeneous Database

Hi,
I need to SELECT data from MS-Access DB from Oracle 10gR2 database. Please guide me to configure this . (How to configure Data Source)
Note: Oracle Server is Running on CentOS 5.1
Regards
Vish 
vishwa wrote:
Hi,
I need to SELECT data from MS-Access DB from Oracle 10gR2 database. Please guide me to configure this . (How to configure Data Source)
Note: Oracle Server is Running on CentOS 5.1
Regards
VishI think below link is helpful
http://www.databasejournal.com/features/oracle/article.php/3358411/Connecting-with-Oracle-Accessing-Oracle-via-Access-and-Excel.htm 
Also you can check out this one: [http://www.oracle-base.com/articles/9i/HSGenericConnectivity9i.php] 
vishwa wrote:
I need to SELECT data from MS-Access DB from Oracle 10gR2 database. Please guide me to configure this . (How to configure Data Source)
Note: Oracle Server is Running on CentOS 5.1Do not see how this is possible. An ODBC driver is needed to access the MS Access database. The Oracle's HS (Heterogeneous Service) Agent loads the ODBC driver and uses it to access the database.
So as the Oracle Server is on Linux, the HS Agent too runs on Linux. It needs to load the ODBC driver and access the database. This means a Linux based MS Access ODBC driver is needed - and the MS Access dbf file needs to reside on Linux (or be mounted via Samba from a NT share).
I'm not aware of ODBC drivers for MS Access being available on Linux. ODBC on Linux is pretty much an Open Source initiative. And there's not much reason for supporting MS Access on Linux when mySQL and other Open Source databases are available.
Oh yeah - think the MDAC (MS Data Access Components) library is needed to access (read/write) the MS Access database file. This is proprietary MS stuff and not available on Linux. 
I'm not aware of ODBC drivers for MS Access being available on Linux. there is a package unixODBC. Did you try it? 
So as the Oracle Server is on Linux, the HS Agent too runs on Linux.Also you can install Oracle XE home in Windows, there is stuff related to HS. yuo do not need database.
But I believe you will need Listener. Then via the Listener->HS->ODBC/OLEDB Win libs you can reach your MSAccess DB from other servers. You can create DB Link to there in Linux Oracle. 
user11181920 wrote:
I'm not aware of ODBC drivers for MS Access being available on Linux. there is a package unixODBC. Did you try it?Have you even bothered looking at the RPM? Do you see any MS Access driver in it? Or how about simply reading the README file?
Description:
        unixODBC is an Open Source ODBC sub-system and an ODBC SDK
        for Linux, Mac OSX, and UNIX.
       
License:
       
        All libraries are LGPL except the News Server driver which
        is GPL. LGPL libraries can be used by commercial software.
       
        All programs are GPL.
Parts:
        unixODBC includes the following;
       
        - Driver Manager
        - Installer Library and command line tool
        - Drivers and Driver Setup libraries
        - Graphical tools to admin ODBC, test drivers and browse
          data sources
        - Command Line Tools to help install a driver and work with SQLSo where in the parts section does it list MS Access?
The only driver that ships with unixODBC is a text-based file driver. Drivers ship separately, like freetds.x86_64 (<i>Open Source implementation of Sybase's db-lib, ct-lib, and ODBC libraries</i>), that can be used for MS SQL-Server access. 
Hi Vish,
You can select from MS-Access from an Oracle database using the 11g Database Gateway for ODBC (DG4ODBC). As discussed in some of the previous entries you need a third party ODBC driver for this to work. Microsoft now provide a SQL*Server ODBC driver that will run on Linux but I am not sure if they provide an Access driver also at the moment. You could contact them to check.
However, what you could do is install DG4ODBC on the Windows machine where Access is running and connect to it from the RDBMS running on CentOS 5.1.
You could then use the MS ODBC drivers on the Windows platform.
See the following notes in My Oracle Support for further details -
Master Note for Oracle Gateway Products (Doc ID 1083703.1)
How to Setup DG4ODBC (Oracle Database Gateway for ODBC) on Windows 32bit (Doc ID 466225.1)
How to Setup DG4ODBC (Oracle Database Gateway for ODBC) on 64bit Windows Operating Systems (Doc ID 1266572.1)
The Master note has links to the download sites, documentation and further information about the Gateways.
Regards,
Mike 
To be honest I've connected from Linux to MS Access years ago.
Currently on the web http://www.unixodbc.org/ I found that drivers for MS Access are available.
Yes these are 3-rd party ones, from Easysoft.
So, this way is possible.
I agree, in case with Oracle a better way is using of dg4odbc installed on MS Access side.

connect oracle64bit (linux) to access

dose it possible to connect oracle 64bit(linux) to access?
what i must to install for that 
user498843 wrote:
dose it possible to connect oracle 64bit(linux) to access?
what i must to install for thatYou can use HS(Heterogeneous Services) .
http://docs.oracle.com/cd/E11882_01/server.112/e11050/tgvsgc.htm#HETER002
Aman.... 
my database is on linux64bit and it hasn't ODBC Driver.
what i must to do? 
user498843 wrote:
dose it possible to connect oracle 64bit(linux) to access?
what i must to install for thatDo you want Oracle to read from the Access "database"?
Or do you want Access to read from the Oracle database?
If the former, I haven't a clue and would ask what the real business problem is.
If the latter, Access will - by definition -- be running from Windows. You'd need to install the oracle client with windows components, and configure ODBC.
Edited by: EdStevens on Sep 22, 2012 8:14 AM 
dose it possible to connect oracle 64bit(linux) to access?See http://www.orafaq.com/node/60 
My Linux is OEL 5.4 and i installed unixODBC by oracle validate.
But i don't know how to config that. 
My Linux is OEL 5.4 and i installed unixODBC by oracle validate.Did you read the link I posted ? You don't need ODBC on linux, but only on Windows machine. 
I want to connect Oracle to access and get some data from access to oracle.
my servers has the following spec:
oracle server(destin):
1- OS=Oracle Enterprise Linux 5.4 -64bit
2- Database= Oracle 1.0.0.4 64bit
3- unixODBC which is installed by oracle validate
source
1- OS =Windows 32bit
2- Database= Access
I find a document in address http://www.dbapool.com/articles/06280701.html
But
how could i config unixODBC which is installed by oracle validate?where is config file? 
When you want to link MS Access and an Oracle database you first need to think about the driving site. You can link an Oracle table into MS Access which would require to have an Oracle ODBC driver installed, but you can also link a MS Access table into the Oracle database which would require the Database Gateway for ODBC (also called Heterogeneous Services for ODBC in releases prior Oracle 11) and a suitable 3rd party ODBC driver which can connect to the MS Access database.
According to the header you want to connect from your Oracle database to MS Access. So you need to use the Database Gateway for ODBC. DG4ODBC is available for several Unix platforms and also for MS Windows. When you use DG4ODBC on Unix you commonly need an ODBC Driver Manager (unixODBC) and the real ODBC driver which can connect to the MS Access database. I'm only aware of one ODBC driver on Unix that allows you to handle MS Access mdb files, it is from http://mdbtools.sourceforge.net/. BUT please be aware that this driver is NOT DG4ODBC compliant as it misses some required ODBC functions. For example the version I tested didn't return the correct result for the ODBC function SQLNumResultCols which is mandatory for DG4ODBC. So from this point of view using DG4ODBC on Unix can't be used (with this ODBC driver).
The better approach that will work is to set up DG4OBC on Windows and to use the MS Access ODBC driver. This ODBC driver will at least allow you to access the MDB file. The connect flow is:
Your Oracle database on Unix connects to the DG4ODBC installation on Windows which will then load the MS Access ODBC driver and this ODBC driver will then connect to the MDB file of your choice.

Why use Transparent gateway in stead of heterogenous Connectivity

I am looking for a solution to update data in a AS400 environment through a oracle DB.
I found information to do this. I can use transparent gateways or Generic Connectivity.
Generic connectivity is free and for transparent gateways I have to pay.
But what is the different between the two?
What is the limitation of Generic connectivity? 
As you stated, Generic Connectivity is for free - from the Oracle license point of view.
But it requires a 32bit ODBC driver from a 3rd party vendor which might require to purchase a license for the ODBC driver.
The big difference is GC (=HSODBC) is NOT availbale for all platforms (only in 10g for Sun Sparc Solaris, AIX, HP-UX RISC, Linux 32bit and Windows) AND it is bundled with the Oracle database. This means you MUST have an Oracle database installed on the machine where you configure generic connectivity.
The gateway (TG4DRDA) or TG4DB2400 is independant from an Oracle db.
TG4DB2400 is installed on the AS400 machine and you can connect from any Oracle db on any platform to the gateway which then handles the connection.
Similar for TG4DRDA; only the platform availibility is different.
The next big difference/advantage of the gateways is the 2PC (2 phase commit) or distributed update control. You can insert something into the Oracle db and without commiting into the foreign db. Now commit your work and the gateway takes care that the transaction is only valid if BOTH inserts went well. 
Thanks For the this information

Categories

Resources