I believe he wants to access Remedy by the ODBC driver and not the Oracle one
regards Stuart Schon Team Manager, Remedy Solutions FUJITSU AUSTRALIA LIMITED Level 4, 320 Pitt Street, Sydney, NSW 2000, Australia T +61 2 9844 0596 M +61 439 475 240 [email protected] <mailto:[email protected]> www.au.fujitsu.com <http://www.au.fujitsu.com> P Please consider the environment before printing this email. From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joe DeSouza Sent: Monday, 27 July 2009 4:51 AM To: [email protected] Subject: Re: SSRS AR ODBC ** Database is obviously the name of the AR System database - usually the default name is ARSystem if you have not changed that default during the install of the AR System server. Server name is the physical name of the database server (AND NOT the AR System server unless you have the AR System and the database installed on the same machine for whatever reason.) Database user name would be ARAdmin if that has not changed during the install of the AR Server and the password if it had been left to default would be AR#Admin#. If for the purpose of reading your data, your DBA's have created a separate user, with read access to the database, use that user instead. Joe ________________________________ From: shweta kumar <[email protected]> To: [email protected] Sent: Friday, July 24, 2009 9:44:15 PM Subject: SSRS AR ODBC ** Hello everybody I am trying to create a report in SQL Server Reporting Services via AR ODBC. However, test "connection" in SSRS fails. I think my connection strings are incorrect. Can you please let me know what components (database, server name etc) are needed for AR ODBC driver setup and for SSRS connection? Thanks Shweta ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
