NotesSQL returns "Reserved error (-7711)"

HCL Domino Domino Forum
1

I have a database with online survey results. The notable thing about this database is fairly large text fields: several fields contain upwards of 2K bytes. There are very few documents (<100), so this is a pretty itty bitty database. Problem is, I can’t export the data!

My chosen method was to use ODBC/NotesSQL to import the data into an MS Access database. I repeatedly received a “Reserved Error -7711” when I attempted to either link to or import the data. I tried importing using the form; no luck. I also built a view with all 73 fields. Same result. I tried Access 97, Access 2000, Access XP: no joy all around.

I also attempted exporting the view to a 123 worksheet. When I did this, I got a Red Screen of Death (running Notes 6.0.1 on a Windows XP Pro workstation with 256 MB RAM).

Before the Notes database was populated with real data, there was no problem linking / importing the data, so I’m fairly certain that field size is the problem.

Any help in resolvnig this would be greatly appreciated.

2

Subject: NotesSQL returns “Reserved error (-7711)”

What version of NotesSQL are you using? 3.02b should have fixed some problems with Access, so if you aren’t using that version, please update to the newest @ http://www.lotus.com/notessql

There will be a new version coming out soon (3.02c) (remember, soon is relative) that will fix some view problems too, though it’s not Access specific.

Thanks,

Ron

3

Subject: NotesSQL returns “Reserved error (-7711)”

I received this same error doing NotesSQL ODBC to a Notes view.

I tracked it down to a random corrupted Notes view. It wasn’t the view that I was attempting to link to, just a view in the database. When I deleted this view, ODBC worked again. Very odd . . . it happened right after we upgraded to Notes 6.0.

I also saw this -7711 one other time, when I had NULL values in a column that I was using as a key to perform a join.

It is difficult troubleshooting these vague Access/ODBC errors.