Hello Brooks, I think I did come across somewhere about the ODBC driver version being version 2.0 compliant. Isn't VS 2005 backward compatible then to use older ODBC versions? Maybe there is some setting somewhere in VS 2005 to make it backward compliant?
Worth checking in that direction... Also try creating an Enhancement Request with BMC Support to to create a ODBC driver to be version 3 compliant.. This may not be an immediate fix but at least they will consider building their drivers to support version 3.. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of brooksm Sent: Friday, January 04, 2008 4:56 PM To: [email protected] Subject: Re: HPD_HeldDesk Worklog timestamp conversion 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"
