IT SOLUTIONS
Your full service technology partner! 
-Collapse +Expand
Paradox
Search Paradox Group:

Advanced
-Collapse +Expand Paradox To/From
To/FromCODEGuides
-Collapse +Expand Paradox Store
PRESTWOODSTORE

Prestwood eMagazine

February Edition
Subscribe now! It's Free!
Enter your email:

   ► MB LobbyCorel Paradox / ObjectPAL Coding BoardObjectPAL Topic   Print This     

Database not open on executeqbe

Database not open on executeqbe in ObjectPAL topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: Database   executeqbe   Database not   Database not open  
gwatchmaker
none
-- USA

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

 Posted 39 months ago (Thread Starter)
Comment Quote
About gwatchmaker -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Member pending approval.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #18249, 2 replies
Thread Started 11/21/2020 6:24:48 PM
View Counter=165
Last Reply Posted 11/23/2020 6:53:10 AM)
Location=-- USA 
Joined=39 months ago   MB Posts=12  
gwatchmaker
none
-- USA

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

 Posted 39 months ago (Thread Starter)
Comment Quote
About gwatchmaker -Collapse +Expand
Visit Profile
Membership pending.
Member subscribes to this thread with a verified email.
Member pending approval.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Post ID #18250 (Level 2) and Parent is 18249
Reply Posted 11/22/2020 7:12:47 AM
Location=-- USA 
Joined=39 months ago   MB Posts=12  
Most Recent Post
Moderator
Steven.G
Myrtle Beach, SC USA

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

Prestwood IT Solutions
8421 Auburn Blvd, Suite 256, Citrus Heights, CA 95610
Office: 916-726-5675 | Fax: 916-726-5676 | http://www.prestwood.com
 Posted 39 months ago
Comment Quote
About Steven.G -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #18257 (Level 3) and Parent is 18249
Reply Posted 11/23/2020 6:48:57 AM
Location=Myrtle Beach, SC USA 
Joined=8 years ago   MB Posts=463  

Revive Thread!

Add a comment to revive this old thread and make this archived thread more useful.

Write a Comment...
Full Editor
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1236A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #18249 Counter
165
Since 11/21/2020
Go ahead!   Use Us! Call: 916-726-5675  Or visit our new sales site: 
www.prestwood.com


©1995-2024 Prestwood IT Solutions.   [Security & Privacy]