Hi !
I don't think you will encounter problems.
I have currently
- one Oracle Server 8.03 on a NT server,
- one Oracle Server 8.04 on a Unix computer,
- one SQL Server 6.5 on the same NT Server than Oracle,
- one Oracle 8 Personal on my computer and also
- SQL Server 7.0 on my computer.
All NT computers are part of the same domain and use the same
IP Address mask.
Usually I access one or two of the Oracle' dbms with the
company application (via ODBC), SQL Server 7.0 through its
own interface, and several other tools (ODBC tools, enterprise managers,
sql plus / svrmgr for Oracle...). Sometimes simultaneously...
It works fine (the only problem is performance - all these tools and dbms
are greedy of memory).
In fact access to an Oracle DBMS is done through its own protocol
(SQL Net) which is very different from the SQL Server protocol. Use of
ODBC relies on these network layers.
So mix seems impossible to me.
What you have to do is to install clients and configure them to
access your databases.
Isabelle.
Pete wrote:
Are there any problems running an oracle database and a MS SQL 6.5 database on
the same server in the same domain. Each database has its own application that
needs to access it.
Thanks
--
* Isabelle Fernandez
* Product Division, Database administrator
* FOCUS Imaging, Les Genets, 449 Route des Cretes, 06560 Valbonne Sophia
Antipolis, France
* Mailto:isabelle_at_focus-fr.com
Received on Tue Dec 08 1998 - 12:09:40 CST
