Roger, To test the connection across subnets, can you connect SQL Server to SQL Server? Do you have the Oracle gateway software installed? Here are a couple links detailing the gateway. Microsoft SQL Server Gateway Features and Restrictions http://docs.huihoo.com/oracle/docs/B19306_01/gateways.102/b14270/ch3.htm Generic Heterogeneous Services and Transparent Gateways in 10 Minutes http://www.orafusion.com/art_orahs.htm I think that the issue [if there is one] will probably be with database-to-database connectivity and not Remedy. If your local RDBMS can see and access data from a remote RDBMS then Remedy should be able to easily access the local SQL Views. The only issues I have seen with remote database connectivity is with the Microsoft DTC configurations. I am not sure if Oracle has a similar issues with remote connectivity as SQL Server. I can say that from my computer I was quickly able to connect SQL Server 2005 to a remote Oracle 10g database located on another subnet (in another state). I did not have to make any special local configuration changes to make the connection. If you are experiencing continuing difficulties with connecting Oracle to SQL Server, depending on your environment, it is possible to instead connect SQL Server to Oracle? Would this provide the same functionality you need? On a related note, at my company we are in the process of setting up a new Oracle 10g database to use for one of our main systems. All of our other systems use SQL Server 2000. Because of the massive costs to purchase additional (not upgrade) SQL Server 2005 licenses for all our apps we are planning on switching to SQL Server 2005 at a later date. However, one option that is being considered is setting up a single SQL Server 2005 instance on a basic server that will only provide SQL replication between the Oracle system. This is because SQL Server 2005 is really good with Oracle replication out of the box. Our [SQL Server 2000] apps would then connect to the SQL Server 2005 box natively. With the connection speed between all our servers at full-duplex gigabit Ethernet, there would be almost zero performance impact. ...just want to spark ideas. Stephen
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Thursday, March 29, 2007 11:28 AM To: [email protected] Subject: Re: View Forms ** Okay maybe I did not give enough information, my bad. The two subnets are within the same domain in the company. The view will be created in a SQL database. Of the two Remedy systems the one is SQL and the other is Oracle. The SQL Remedy system is on the same subnet as the view. The Oracle Remedy system is not. Does that make anything clearer? Thanks, Roger A. Nall Manager, OSSNMS Remedy T-Mobile USA Desk: 813-348-2556(New) Cell: 973-652-6723 FAX: 813-348-2565 sf49fanv AIM IM RogerNall Yahoo IM ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Heider, Stephen Sent: Thursday, March 29, 2007 11:19 AM To: [email protected] Subject: Re: View Forms Roger, If you can create a SQL View on your Remedy database server pointing to any table on a remote database server then Remedy should be able to create a View Form on top of the local SQL View. Are you able to add a Linked Server connection from the Remedy database server to the remote database server? Are the two subnets within your company's WAN/LAN or is one of the subnets from the internet? Stephen ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Nall, Roger Sent: Thursday, March 29, 2007 10:58 AM To: [email protected] Subject: View Forms ** We have several Remedy systems on different platforms. We are integrating two of the Remedy systems with a new .Net system all in the same domain. The two Remedy systems are on different subnets. The question that has come up is can the two Remedy systems create a view form to a view of a table that is in a database on one of the subnets? If so, how does the Remedy system in the 'outside' subnet reference the view in the View Form? I hope this makes sense. Thanks, Roger A. Nall Manager, OSSNMS Remedy T-Mobile USA Desk: 813-348-2556(New) Cell: 973-652-6723 FAX: 813-348-2565 sf49fanv AIM IM RogerNall Yahoo IM __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
