Database not open on executeqbe

Dear experts,

I installed Paradox 11 on a Server 2016 last month.  I migrated my programs from an old Server 2003 that served me well for 15 years, resaved the libraries and all was running fine for 2 weeks.  Then a few days ago, my users received a "Database not open" error.  My debugging reveals that I can open a tcursor to my tables, edit them, etc.  If however, I run a qbe agains the tables .... I receive the 'not open' error.  What is stranger is that if I open Paradox interactively and run the form directly myself, the qbe works.  If, however, the form is started by another form, the error occurs.  It occurs whether in an RDP session or if I am at the console at the server's desktop.  The error occurs in all 30-40 forms I wrote years ago and worked on the Server 2016 for weeks.

My efforts to date:

1.  deleted all paradox private directories, recreated, made sure all users have full control of the directory in security settings

2.  removed Paradox and Wordperfect, deleted all Borland and Corel registry entries, deleted all .cfg, .lck, .net files, and deleted the installation directories

3.  reinstalled Paradox.  Strange thing is that 2 of my OBDC alias's showed up on reinstallation before I created them in the BDEadmin despite deleting every vestige of the BDE I could find.

Any thoughts greatly appreciated as I am 12 hours into this problem 

Greg

Dear all,

Sometimes just writing a post helps! 

I isolated the problem and found a bug in Paradox 11 that I didn't know of that caused the problem.  In my main opening program, I obtain the list of printers on the computer so that I know the default printer and others that are available.  I found that the line of code with the enumprinters causes a database open error that will not go away until closing Paradox.  I tested with these three lines:

enumPrinters(systemPrinters) ; Get a list of installed printers to an array and look for a local one

enumPrinters(tcprinters) ; get structured list of printers as tcursor in memory

enumPrinters(":priv:__enumprinters.db") ; get structured list of printers as table

What I found is that the enum to tcursor, once executed causes the inability to run an executeqbe in any program in the session thereafter.  Maybe this is a known (and normal or reported) behavior but it certainly caught me off guard.

Greg

not familiar with that particular error in that context being common, but paradox has issues in general with network resources that are ID'd but not there, especially printers, and issues with printer names over 32 characters

recent Win versions (Win10, Server 2016 and 2019, etc.) all install printers with much longer names than previously, so you have to shorten the names

so, most likely, it's not the enum itself, it's what the enum is finding

Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN