Dear All, Does anyone have any experience or even know if it is possible to use DBI to hook up to an OTG (Oracle Transparent Gateway) ???
I am trying to use the DBI to connect to a remote gateway machine. This situation is, we have an AS400 machine which has some Oracle libraries on it and then a gateway machine which has what is called an OTG software layer on it which talks to and interprets data from the Oracle libraries on the AS400. You can talk to the OTG via an Oracle database (up to version 7 so Oracle themselves say, but we and many others have found that 8i does work). I want to know if it is possible to use DBI in some shape or form to hook directly in to the gateway machine (OTG). The problem being, I do not know how to connect to this OTG as it does not have an Oracle SID. The 8i database we can connect to it from is able to query the OTG in the following manner: "select * from <table_owner>.<table_name>@<machine>" As you can see, this does not really equate to any kind of standard DBI connect string. I was wondering also if anyone knows if there is a OTG driver available such as DBD::Oracle. Perhaps a driver of this kind would offer a different connect method? Any help on this matter would be most appreciated. Best Regards, Paul Anderson. 2Helix Solutions ---------------------------------------------------------------------------- --------------------------------------- NTL Quadrant House Telephone: +44 (0)207 7464270 17 Thomas More Street Fax: +44 (0)207 7464335 London Email: [EMAIL PROTECTED] E1W 1YE or [EMAIL PROTECTED] ---------------------------------------------------------------------------- --------------------------------------- The contents of this email and any attachments are sent for the personal attention of the addressee(s) only and may be confidential. If you are not the intended addressee, any use, disclosure or copying of this email and any attachments is unauthorised - please notify the sender by return and delete the message. Any representations or commitments expressed in this email are subject to contract. ntl Group Limited
