HPE Community
Operating System - HP-UX
1752642 Members
5588 Online
108788 Solutions
New Discussion юеВ

ODBC Driver for Oracle to connect to SQL Server on Windows

 
Eric Hess
Advisor

тАО10-26-2004 02:08 AM

тАО10-26-2004 02:08 AM

ODBC Driver for Oracle to connect to SQL Server on Windows

Does anyone know where we can get a ODBC Driver so our Oracle 9i version 9.2.0.4 can connect to a SQL Server 2000. I have been to Data Direct and they will be charging $2000 per CPU. I was wondering if there is a cheaper method we can use. Thank-You to anyone that can be of assistance.

Eric Hess
College of American Pathologists
847-832-7565
ehess@cap.org
I didn't do it. He did!
0 Kudos
Reply
3 REPLIES 3
Steven E. Protter
Exalted Contributor

тАО10-26-2004 02:20 AM

тАО10-26-2004 02:20 AM

Re: ODBC Driver for Oracle to connect to SQL Server on Windows

If you have the oracle client installed on a windows workstation, you can use a tool like access to access both databases.

Access comes with the ability to access microsoft sql databases. Then ODBC drivers for oracle can let you have a little access application that accesses both databases.

Or you could export the sql data and use sqlloader(another oracle tool) to get the data into oracle.

How to proceed depends on the mission requirements.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
0 Kudos
Reply
Eric Hess
Advisor

тАО10-26-2004 02:24 AM

тАО10-26-2004 02:24 AM

Re: ODBC Driver for Oracle to connect to SQL Server on Windows

Oracle is currently installed on a rp7420 running 11.11. The ODBC driver I need is for Unix to connect to Windows.
I didn't do it. He did!
0 Kudos
Reply
Yogeeraj_1
Honored Contributor

тАО10-26-2004 04:15 PM

тАО10-26-2004 04:15 PM

Re: ODBC Driver for Oracle to connect to SQL Server on Windows

hi,

you may wish to look into heterogeneous services and connect the other way round.

regards
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.