Visual Menu Builder Issue

[jsapienza]

We are having some issues with Visual Menu Builder. It launches just fine but when I select the correct server for the SQL SA Login box and select connect I get a value of true under connected. But, the continue button remains grayed out. Any info / tips is greatly appreciated.Thanks.

 

[dgillz]

In order for visual menu builder to work with SQL the full set of SQL tools - enterprise manager, sql query analyzer, etc. - must be installed.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"making predictions is tough, especially about the future" - Yogi Berra

 

[jsapienza]

I have it all the sql tools installed and enterprise manager works with no problems.

 

[dgillz]

Try reinstalling the Macola client. Does this work from any other workstatiom

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"making predictions is tough, especially about the future" - Yogi Berra

 

[jsapienza]

VMB doesnt work from any workstation. I have reinstalled the client a few times it didnt have any effect.

 

[abaldwin]

Are you trying this from PWE or standard progression? Just a thought.


Andy Baldwin

"Testing is the most overlooked programming language on the books!

 

[jsapienza]

Standard progression.
PWE is another story , according to some users it has not worked for months.
I have just been tasked with getting it all working (long time systems engineer first time macola user/admin)

PWE hangs on opening files until it times out or the process is killed. It says there is a problem accessing the DB.

My gut says that its a sql permissions issue but im not sure what the default permissions should be.

 

[maccrystal]

Check the MacSQL.cfg file in the root of Macola. Verify that the server name is correct and the number of company installed agrees with the actual number of [company_xxx]
The [company_xxx] should only have three numbers (e.g.002). Delete any blank lines. (Backup the config file before you change it)

http://www.appstratinc.com

 

[jsapienza]

the MacSQL.cfg looks correct.

 

[abaldwin]

Any folders or files in the macola root directory that start with "DATA" that are not data compay folders?


In other words you have an old data company folder out there that no longer exist in teh macsql.cfg and db. and for instance a file called dataforme.xls



Andy Baldwin

"Testing is the most overlooked programming language on the books!

 

[kscheeler]

Also verify that in the Macsql.cfg file, all of the companies listed have valid databases in SQL and valid DATA_xxx folders in the macsql folder.

How many servers show up in the window when trying to access VMB?

Kevin Scheeler

 

[jsapienza]

Here is my Macsql.cfg
----- Begin file -----
[SQL_INFO]
Companies_Installed=10
[Company_000]
Name=Macola Electronics
Server=APPSRVR
Database=Demodata
LOCKDB=MsllockDB
FRL=False
[Company_001]
Name=DATA BUSINESS SYSTEMS INC
Server=APPSRVR
Database=DATA_01
Lockdb=MSLLockDB
FRL=False
[Company_005]
Name=DATA BUSINESS SYSTEMS OF NORTHERN VA
Server=APPSRVR
Database=DATA_05
Lockdb=MSLLockDB
FRL=False
[Company_007]
Name=DATA BUSINESS SYS SOFTWARE LLC
Server=APPSRVR
Database=DATA_07
Lockdb=MSLLockDB
FRL=False
[Company_010]
Name=Data Business Sys (2002)
Server=APPSRVR
Database=DATA_10
Lockdb=MSLLockDB
FRL=False
[Company_013]
Name=Data Business Sys (NOVA)
Server=APPSRVR
Database=DATA_13
Lockdb=MSLLockDB
FRL=False
[Company_055]
Name=NOVA>0504
Server=APPSRVR
Database=DATA_55
Lockdb=MSLLockDB
FRL=False
[Company_090]
Name=Consolidation Company
Server=APPSRVR
Database=DATA_90
Lockdb=MSLLockDB
FRL=False
[Company_098]
Name=DBS-98 YR 2004 PR
Server=APPSRVR
Database=DATA_98
Lockdb=MSLLockDB
FRL=False
[Company_099]
Name=TEST
Server=APPSRVR
Database=DATA_99
Lockdb=MSLLockDB
FRL=False
[ENGLISH]
Server=APPSRVR
Database=SCREENS
LockDB=msllockdb

---- End File -----


----- Data Folders in Macsql dir ----

07/26/2006 12:30 PM <DIR> Data
07/21/2006 09:00 AM <DIR> Data_00
07/26/2006 11:45 AM <DIR> Data_005
03/06/2006 06:43 PM <DIR> Data_006
07/25/2006 10:15 AM <DIR> Data_010
03/06/2006 06:43 PM <DIR> Data_012
05/25/2006 09:08 AM <DIR> Data_013
03/06/2006 06:43 PM <DIR> Data_052
07/01/2006 04:48 PM <DIR> Data_07
07/19/2006 03:13 PM <DIR> Data_090
07/21/2006 11:11 AM <DIR> Data_099
05/15/2006 02:54 PM <DIR> Data_55
06/07/2006 08:28 PM <DIR> Data_98

Also:
There are 2 servers that show up when trying to access VMB.
The APPSRVR is the correct server and then one that was an old server.

Thanks to all for the help so far.

 

[kscheeler]

Look at another file called pwe.tam. It's a text file and is in the \macsql\pwe folder. Verify the server name was changed in there as well.

Kevin Scheeler

 

[jsapienza]

Thanks Kevin that was it. The PWE.tam file was pointing to the old server. Once I changed it to the new server.. PWE started working again as well as VMB.

Thanks again Kevin and thanks to all that replied.

 

[dgillz]

As an aside your macsql.cfg shows 10 companies but your data directories show 13. You might want to edit your macsql.cfg file accordingly.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"making predictions is tough, especially about the future" - Yogi Berra