Removed Old Domain Trust. Now Progress (9.1D) can't open DB File
My company has an old server, running Progress 9.1D on a Windows 2000 VM, which was used by our company OS (Vantage 6 by Epicor.) Vantage was our primary OS for a very long time. About 2 years ago, we migrated to a larger, corporate OS and we cancelled our service contract with Epicor.
Yesterday, we removed an AD trust between the corporate domain and our old AD domain we used in the days of Vantage. After restarting the virtual server, I have been able to start the ProService for 9.1D Windows service, however, I can not get Vantage to start back up. When I run the application, I get the error in the message listed below.
Transcript:
** Could not connect to server for database [progress db file], errno 0. (1432)
How can I fix this? FYI, I haven't had to work with Progress in years and even then I wouldn't have considered myself a "novice"-- I'm even less knowledgeable than that title would suggest.
Vantage had a lot of internal tools and I recall that Epicor support managed to prevent .pf scripts from being executed. If there was a Progress specific patch that needed to be applied, you had to do it within the Vantage software OR they had to remote into the machine to fix this.
I may not be able to run a .pf script but I do know that I can log into the console-based server application. (Yes, I can't even recall which utility that was called. It is sad.) It's been a long time and I never had to digg into Progress that much.
Please help and feel free to ask questions. If you need more info, I'll update this post.
Assuming the database you're trying to connect to is running -
if Vantage is using a client-server connection, then the database needs to be started with a "-S" parameter which specifies a service port name or number the db engine will listen on for connections. This can be found in either a ".pf" file, or on the script which starts the database. You can find the value it's using by looking in the .lg file and searching for the last "-S" setting.
If Vantage is attempting to connect to the correct port, then you need to check your firewall settings to see if it is allowing Vantage to access that port, and the database has permissions to listen on that port.
The startup command could look like:
mpro db-name -H hostname -S portname-or-number -p program.p
also -
mpro -pf pfname.pf
is a way to hide the startup complexity in a .pf file.
IF vantage wants to use a self-serve connection (ie, not client-server) then the startup command needs to look something like this:
mpro /full/path/to/db/db-name -p programname.p
If you can get to an 4GL client editor, the ABL code to connect to a database looks like this for client-server connection:
CONNECT VALUE("db-name -H hostname -S portname-or-number").
and this for self-serve connection:
CONNECT VALUE("/full/path/to/db/db-name").