Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Linking to a SQL Server
Walt-
What version of Linux are you running?? As of RH 8.0 generic HS services were not supported by Oracle. In fact the hsodbc exe does NOT exist at $ORACLE_HOME/bin.
Using Perl or Python does not qualify for generic connectivity in my book..............
-----Original Message-----
Sent: Wednesday, November 26, 2003 2:14 AM
To: Multiple recipients of list ORACLE-L
I have.
It works.
The steps:
1. Connect to Oracle. 2. Connect to SQL Server. 3. Transfer data, maybe using Perl. Or Python (this is for my buddy SteveOrr). 4. If it doesn't work, contact a call center in India. They know everything.
Generic connectivity is, indeed, supported on Linux. I'll bet it's supported at Russel Athletic too.
Now, here's the hard part. Try to get up the balls to try it yourself. I know it's hard, but I'll bet you can do it.
If you can't, spend some time watching old reruns of Mr. Roger's Neighborhood.
--Walt (I've fallen down and can't get up) Weaver
Bozeman, Montana
On behalf of absolutely nobody but myself.
> -----Original Message-----
> From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com] On
> Behalf Of Shiva Maran
> Sent: Tuesday, November 25, 2003 11:39 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Linking to a SQL Server
>
>
> Hi All,
>
> Has any of you had an exprience in accessing SQL Server
> data from Oracle database. I am woking on Oracle 9i on RH
> Linux 9. Does it work?? If so can you please list the steps
> that I need to try to do the same.
> Also wanted to clarify if generic connectivity is supported
> on Linux. Oracle documentation seems to have only examples on
> Unix and NT.
>
> Thanks
> ShivaM
>
> DISCLAIMER: This e-mail contains proprietary information some
> or all of which may be legally privileged.
> It is for the intended recipient only. If an addressing or
> transmission error has misdirected this e-mail,
> please notify the author by replying to this e-mail. If you
> are not the intended recipient, you must not use,
> save, disclose, distribute, copy, print or relay this e-mail.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Shiva Maran
> INET: Shivam_at_talisma.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L (or the
> name of mailing list you want to be removed from). You may also send
> the HELP command for other information (like subscribing)
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Weaver, Walt INET: wweaver_at_rightnow.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may include AMERIGROUP member information that is legally privileged. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy copies of the original message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thompson, Todd INET: TThomps_at_amerigroupcorp.com Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Wed Nov 26 2003 - 08:34:33 CST