Configure SQL.ini to open ADP and a Network Database

[DirectOne]

We have a workstation that has ADP using SQLBase installed locally. We also have an SQLBase database on the network.
How do we configure the SQL.ini to be able to open both databases from that workstation?

Simultaneously would be nice, but one at a time would suffice.

Thanks for any help or tips or white papers.

 

[LMRollins]

Unfortunately, it's not easily done unless you are running the same versions of SQLBase. If that is your problem, try this solution. Open notepad and copy the following and name it visual.bat. (NOTE: Where //visualserver, use your path to your visual server.)

echo off
cls

echo Please Do Not try to Run ADP while this screen is open.
echo This file temporarily changes the path statement and SQLBASE
echo environment variable to correctly run Visual Manufacturing.
echo This is necessary for Visual & ADP to co-exist.

PAUSE

SET SQLBASE=C:\VISUAL\SQLBASE
SET ORIGPATH=%PATH%
SET PATH=C:\VISUAL\RUNTIME;C:\VISUAL\SQLBASE;
\\VISUALSERVER\VISUAL\VMFG\VM.EXE -D VMFG

Echo To exit this screen after closing Visual . . .
Pause

SET SQLBASE=C:\ADP\SQLBASE
SET PATH=%ORIGPATH%
EXIT

Next create a visual icon and right click and go to properties. Change the command line to read to the location where you have your bat file you just created. I'd put it in my local visual folder.

Hope this helps.
Lori