Pulling data from non-ARS database

2008-07-31 Thread Jackie Morris
Hi everyone- I have a form that currently does a set fields using SQL to an outside database. My system is on Oracle and so is the outside DB. I think we use a DB Link. The query I use has FROM [EMAIL PROTECTED] in the string to identify where its going. The information I am pulling is

Re: Pulling data from non-ARS database

2008-07-31 Thread Rick Cook
Is creating a Vendor form directly to the outside data an option? Rick On Thu, Jul 31, 2008 at 8:05 AM, Jackie Morris [EMAIL PROTECTED] wrote: ** Hi everyone- I have a form that currently does a set fields using SQL to an outside database. My system is on Oracle and so is the outside

Re: Pulling data from non-ARS database

2008-07-31 Thread Grooms, Frederick W
from non-ARS database Hi everyone- I have a form that currently does a set fields using SQL to an outside database. My system is on Oracle and so is the outside DB. I think we use a DB Link. The query I use has FROM [EMAIL PROTECTED] in the string to identify where its going. The information

Re: Pulling data from non-ARS database

2008-07-31 Thread William Rentfrow
Consultant, StrataCom [EMAIL PROTECTED] O 952-432-0227 C 701-306-6157 From: Action Request System discussion list(ARSList) on behalf of Grooms, Frederick W Sent: Thu 7/31/2008 10:30 AM To: arslist@ARSLIST.ORG Subject: Re: Pulling data from non-ARS database

Re: Pulling data from non-ARS database

2008-07-31 Thread Jackie Morris
@ARSLIST.ORG Subject: Re: Pulling data from non-ARS database To connect to a non Oracle database you can use the Oracle service Heterogeneous Services. Here is a page that describes the process: http://www.orafusion.com/art_orahs.htm I think you will have to install an ODBC driver on your Solaris