I’m trying to do a left outer join between an MS SQL Server table exported from Domino using LSX:LC and the underlying Notes db view. Apparently I have records in SQL that no longer exist in Notes and I’m trying to find out which they are. (Can’t use LEI replication; the Notes data are so bad almost every record has to be scrubbed.) When I issue the query from MS SQL Query analyzer, I get this message:
The exception breakpoint. A breakpoint has been reached. (0x80000003) occurred in the application at location 0x77f813b1.
SQL server is 2000, Domino server is 6.5, NotesSQL driver is 3.0.2f.
Have you run a fixup on the database? I believe you’re getting that error because it sounds like your underlying data is messed up. This kind of breakpoint only occurs in NotesSQL if there is a problem it can’t resolve.
Subject: RE: NotesSQL 3.02f and Exception Breakpoint
We will give it a shot. Unfortunately, the Notes NSF is about 24Gb with 408,000 documents. Will have to try tonight. Interestingly, the same DSN works with the same query (modified for Access, of course) in MS Access. It is, however, sloooowwww!