Hello Listers, MS SQL 2005 on a SAN MS Windows 2003 Enterprise AR System 7.6.03 Build 001
Our system connects to a remote Sybase DB via the DB Link for ARS Croom Consulting. The Sybase DB is being replaced by an Oracle DB. We only need to read data so I am trying to make the oracle connection with a View form. The MS SQL dba created a Linked server to the Oracle DB and confirmed the connectivity. In the View form should I use the MS SQL connection string or an Oracle connection string? <linkname>.<db_name>.<owner>.<table> or <db_name>.<table>@<linkname> The value that I tried to load was the ORAORQ10.propmgt.propmgt.equipment. That gives an ARERR 552 message I have also tried propmgt.equipment@ORAORQ10 That gives ARERR 481 but I'm not sure if the "table not found" is because of case sensitivity or just the wrong connection string format. I've successfully connected to a different linked db but it is a remote MS SQL so I use the link.db.owner.table format for that. Thanks in advance. --- John J. Reiser Remedy Developer/Administrator Senior Software Development Analyst Lockheed Martin - MS2 The star that burns twice as bright burns half as long. Pay close attention and be illuminated by its brilliance. - paraphrased by me _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
