Hey Joe- I'm using Visual Studio 2005 (Reporting Services) to connect to ARSystem. When I do use the AR ODBC driver I get this error: "Column 'TABLE_CAT' does not belong to table Tables." It's also documented here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=544499&SiteID=1
Microsoft is saying that the ODBC driver must be ODBC 3.0 compliant to work with VS 2005. So most likely the ARSystem driver must only be 2.0 compliant. I finally resorted to just using the SQL Server driver and converting all the datetime fields, but now that I have to report on the Help Desk Worklog, I'm kind of at a loss without parsing that field and converting the multiple timestamps. Thanks! Brooks Joe D'Souza wrote: > > Brooks, > > The AR ODBC driver is the best bet for that conversion. Without that you > will need to do all the conversions yourself and its not just the date and > time but conversions like values of drop list fields which will be > enumerated values, names of columns which will be C1, C2.., Status history > values if you need to report them, etc if you report directly using a SQL > connector. > > What errors are you getting when you try connecting to the database using > the AR ODBC driver? > > Joe > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] Behalf Of brooksm > Sent: Friday, January 04, 2008 3:30 PM > To: [email protected] > Subject: HPD_HeldDesk Worklog timestamp conversion > > > Hello All > I am using SQL Server Reporting Services for my reporting application and > the ARSystem ODBC driver is throwing up errors when I use it to connect to > ARSystem, so I am connecting directly to the database for my reporting. Is > anyone else running into this problem? If not, can someone tell me how I > can > get the Work Log to display properly formatted timestamps in a direct sql > query that looks like this:8/26/2006 2:36:22 PM and not like this: > 1155331936 > > Thanks > Brooks > > ARSystem 7.00 > SQL Server 2005 > No virus found in this outgoing message. > Checked by AVG Free Edition. > Version: 7.5.516 / Virus Database: 269.17.13/1209 - Release Date: 1/4/2008 > 12:05 PM > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > > -- View this message in context: http://www.nabble.com/HPD_HeldDesk-Worklog-timestamp-conversion-tp14624370p14625774.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
