×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Configure SQL.ini to open ADP and a Network Database

Configure SQL.ini to open ADP and a Network Database

Configure SQL.ini to open ADP and a Network Database

(OP)
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.

RE: Configure SQL.ini to open ADP and a Network Database

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close