Hi David !  I think you made the most logical choice as the solution is way convoluted. I have a Windows 2003 Server R2 64-bit as my Enterprise guide server and I found the solution from Microsoft, not SAS. In the structure of Windows 64 bit (not sure about 2008), there is the standard c:\windows\system32 directory which, according to MS, holds the 64-bit programs and code ! A little confusing ?  Yeah, I know ! Apparently, to use 32-bit drivers in the 64-bit Windows 2003 environment, you need to install your drivers through the 32-bit version of the Datasources (ODBC) program which is located in the c:\windows\SysWOW64 directory and is the executable odbcad32.exe.  Now, the executable in the normal SYSTEM32 directory has the same name, probably for coding reasons, so it's easy to get confused. Also note that pulling 32-bit documents like Word, Excel and others need to use the SAS/Access for PC Server otherwise they won't load. Maybe when we have more 64-bit apps at the user end, we won't have to worry about this incompatibility so much ? ... View more

Hey Rod !  Great idea opening this discussion group in communities.  i have opened a similar one at the SASCANADA site at http://sascanada.ning.com/group/sitrmug but i guess there are not many ITRM users in Canada that have seen the site.  I currently work for Transport Canada, the Federal Government of Canada and I have been supporting ITRM v3.1.1 for almost 3 years now.  I am more a system admin than a coder but i am slowly making my way through the custom code Rod and the gang created for us while I try and see how to update what we have with new source databases (VMware and Citrix) plus to start looking deeper at our SAN infrastructure.  I would be interested in hearing about anyone's experiences in upgrading ITRM from 3.1.x to 3.2 as I have to do that in order to make VMware (aka Vsphere) talk with our adapters.  I have also been supporting about 60 users on Enterprise guide 4.2/4.3 on SAS Base 9.2.  I am also anxious to get it upgraded to SAS Base 9.3 with Enterprise Guide 5.1 but that's for another discussion page !!!  Happy to be here and to meet you all !!!! ... View more