All the new  notes (memo fields) are accessed through the individual files like notes are in ISNOTES, and the notes for links are in ISLINKS.  The File where the actual data is stored is wbtrvmemo.b in the DBAMFG folder.
 

Canadian, eh?  I thought you are from Maine, ayuh!  

I have not tried to access the notes using ODBC, I don't need ODBC I have TAS so I can access it directly. To answer you, yes the IS.NOTE.NOTE contains a ref to BTRV.MEM.CNTR, but It is all internal pervasive stuff so I don't know how it is doing the offsets, and like I said until now I had never thought about accessing it with ODBC. I understand why you would want to.. but I am sorry I don't think I can be much help to you here. You can try Tim, KKMFG, or Kellogs, they may have some ideas.  

Because the data falls outside of any "company", there is not an easy way to get at the file. I'm not sure its even a PSQL file. It looks like random fields with an encoded index scheme. It has notes from all over the place scattered around in it. It's probably just a big blob of text.  
 
 
 
This was enough of an issue for us that we have stayed with the old notes system by using CSN.

Right, but then what? All of the various kinds of notes are mixed together in there. You'd need to use a programing language to pull things out. Reporting tools would likely not be up to the task of even linking that info with SO header info, since that would require linking to two DSNs at once. I guess you might be able to build a new table using Access. Rather beyond the typical Excel or CR user.