I.T. Discussion Community!
-Collapse +Expand
Paradox
Search Paradox Group:

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

Prestwood eMagazine

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

   ► MB LobbyCorel Paradox / ObjectPAL Coding BoardParadox Setup, Vista, etc. Topic   Print This     

Paradox on Windows Server 2012

Paradox on Windows Server 2012 in Paradox Setup, Vista, etc. topic (part of our Corel Paradox / ObjectPAL Coding group).

Quick Search: Paradox   Windows   Paradox Windows   Paradox Windows Server  
gcorvera
-- UNK
Rank: Cadet 4th Year

We migrated from using a run of the mill Windows XP box as a server to Windows Server 2012; one of the applications we use is a simple 3 table database which stopped working the moment the files were being accessed from the new server. We could see data but trying to add anything would result in a Lock Time Out error.

I discovered that if I remove Referential Integrity from the detail table structure, and just assign it through the data model on the form, everything works.

Would it be OK to leave it like that? or would it be somehow dangerous for the integrity of the data?

Could the problem have come from some setting on the server? The person who installed the server for us doesn't think so but I'm not sure he is as familiar with Windows 2012 Server as I thought.

For the time being I will be monitoring the data and checking that nothing is lost.

Any suggestions?

Thanks

 Posted 38 months ago (Thread Starter)
Comment Quote
About gcorvera -Collapse +Expand
Visit Profile
Approved member.
Member subscribes to this thread with a verified email.

Post ID #15153, 1 reply
Thread Started 6/2/2014 12:27:41 PM
View Counter=2083
Last Reply Posted 7/21/2017 5:28:19 AM)
Location=-- UNK 
Joined=7 years ago   MB Posts=14   KB Comments=1  
Most Recent Post
Wakinyan
Sinclair Manufacturing
-- --
Rank: Cadet 1st Year

Resurrection...

Lock Time Out errors - I am currently dealing with this, have Microsoft involved as well.

Two weeks ago, we migrated from Server 2008 R1 (Vista based) to Server 2016 (Win 10 based). We run Paradox (Office X6) on clients from XP, 7, 10 x86 / x64, and ONLY store the data on the server's mapped drives.

Paradox locks, crashes, does not behave well at all when pointing to the new server (*).
Through much testing, pointing to a Win8.1 box as a "server", works fine. Pointing to a test Server 2012 R2 box, works fine. Point to the 2016 box, and things get REALLY strange.

Pointing to a 2016 Domain Controller's shared test folder, Paradox WORKS. Huh. fails on File Server, runs on DC.

File Server (2016) #1, RAID1 (2x drives) for OS, shared folder on C:\ WORKS. Running from the RAID 10 (4x drives) data partition, fails the way I mentioned.

File Server (2016) #2, RAID 10 (6x drives, broken up into 2 partitions, 300Gb for OS, 1500Gb for data), WORKS on C: partition, fails on data partition. Install Windows Server 2016 on data partition to make it bootable, etc., FAILS. Make C:\ the entire disk, if WORKS.

I see that X8 is out. While I doubt there's been ANY changes, I'm going to try it and see if it works at all. We've been running this / some iteration of my Paradox app to run the company since... mid 90's, and the boss doesn't want to replace it before he retires. :)

 Posted 26 days ago
Comment Quote
About Wakinyan -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 #16789 (Level 2) and Parent is 15153
Reply Posted 7/21/2017 5:17:25 AM
Location=-- -- 
Joined=26 days ago   MB Posts=1  
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 = P1164A1
Enter key:
Icon: A Post    Thread    Idea    Important!    Cool    Sad    No    Yes    Includes a Link...   
Thread #15153 Counter
2083
Since 6/2/2014
-
   Contact Us!
 
PrestwoodBoards.com was developed and is maintainted by me. Do you have a question or suggestion? Do you see a problem? Contact me now. My goal is to build an ad-free and spam-free source of I.T. information with many contributers (ok to promote your website/company in your bio). Yes, my company Prestwood IT Solutions is mentioned in my bio which shows with every post, but you can contribute and promote your pet project too!

1,879 People Online Now!!  
Sign In to see who's online now!  Not a member? Join now. It's free!
Show more stats...


©1995-2017 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech