Frank: The ARODBC driver tends to be sort of flaky under the best of circumstances. I gave up trying to use it with Reporting Services.
I have been using Reporting Services against my ARSystem database quite successfully. Use the MS-SQL driver and query against the views rather than directly against the tables. This gets you nice names to deal with. The only problem is with timestamps in ARSystem which are stored as integers rather than SQL date/time values, but a couple of short functions takes care of that. Risk-wise there is none since you are doing only select queries to pull out data, and you're not doing anything that the database system is not designed to do. Carl A. Jones ThyssenKrupp Elevator Desk - (901) 365-5656 x5250 Mobile - (901) 210-1369 ------------------------------ > Date: Wed, 3 May 2006 11:32:01 -0400 > From: Frank Wall <[EMAIL PROTECTED]> > Subject: Questrion on Microsoft SQL Reporting Services and Remedy. > > All, > > I have a couple of questions for any one that has used MS SRS with Remedy. > > 1. Is there a way to have SRS to use a ARODBC connection? > > 2. If a ARODBC connection can not be used, what would be the risk if any > in using a SQL connection directly? > > Thanks in advance for any input on questions I have. > > Thanks, > Frank Wall > Administrator _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
