Joe >From what I can tell, this is a problem with VS 2005 and unfortunately it isn't fully backwards compatible with the 2.0 ODBC standard. I guess most functions will work, but I was just lucky enough to be in the .01% that needed the 3.0 functionality. I did create a support request with Remedy asking if they do have an ODBC driver that is 3.0 compliant. Maybe the driver that comes with Remedy 7.1? We'll see...
Thanks for your thoughts. Brooks Joe D'Souza wrote: > > 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" > > -- View this message in context: http://www.nabble.com/HPD_HeldDesk-Worklog-timestamp-conversion-tp14624370p14626639.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"
