The problem with setting up ODBC connections in SA is the fact that every DB type has unique requirements when adding DSN value pairs. For instance; When setting up connections to an Oracle 9i vs Oracle 11g, the vaule pairs required for each are:
9i 11g
datasourcename= datasourcesname=
servicename= servicename=
hostname= hostname=
PortNumber PortNumber=
or portnumber= driver=
driver=
The differences can be so subtle it's nearly impossible to to crack the code. When i setup the 2 connection above, I did 9i 1st and it worked just fine. When i did the same setup on 11g it failed everytime because i didn't have portnumber as PortNumber. It actually took 2 developers about 4 hours to determine this was the problem. Also, when adding the DSN's to your event source type, i would refrain from adding an initial tracking ID unless you know the date/timestamp you want to start polling from. If you don't enter the tracking ID correctly, it will inject unkown commands into the SQL statament and it will not work.
I have been working on McAfee ePO 4.5_x myself for a few days now and still haven't been able to get it to work. If i figure out the DSN value pairs i will definitely let you know. Try taking a look at the sample ODBC.ini files in this datadirect guid provided by RSA. The sample files should help you get on the right track....
