Zeus IDE

Hi All,
am new to the forum so please bear with me.

I have been using zeus for a number of years now purely as an sql scripting tool. The company I am now in need now to start using code source control. Zeus has this feature but after a few struggles I find I am in need of some help in using it.

The help didn't appear to that much help so I am looking to the forum to help me.

regards

Alan

just had a look around and tips and tricks could well solve the problem

cheers

Alan

Well I have tried to follow the instructions but with no sucess.

can anyone out there help?

a brief outline of the problem

I have a set of sql scripts which we as a companu use for database administration. I wish to keep these files on a server for all to view.
I set up a workspace and set the workspace directory as the server location. I remove; header resource and source folders as per instructions. I then add a file to the project. I then ensure that source control is active. I then add the project to source control.

a new window appears saying
new zesu scc-cvs project.
question - where should the repository folder be
is the protocol local folder, what does this mean.

if this procedure can be verified by someone and the questions answered then I will proceed to the next points



regards


Alan

Well I have tried to follow the instructions but with no success.

Did you try the example setup as described here: http://www.zeusedit.com/forum/viewtopic.php?t=237

If you did then what went wrong

What error messages where displayed

question - where should the repository folder be

The repository folder is where the version control database is kept. If you have many people using the version control this needs to located on a LAN address that all users can see.

is the protocol local folder, what does this mean.

CVS has many connection protocols. A protocol defines how this client connects to the CVS database. The local folder option means the database is located in a local folder (ie a local or network drive mapping).

if this procedure can be verified by someone and the questions answered then I will proceed to the next points

In the case you are describing Zeus is using CVS for the version control system. Therefore any documentation describing CVS is suitable for example: http://ximbiot.com/cvs/cvshome/

CVS can be a little tricky to configure, so you really need to try and work through the example link mentioned earlier while referring back to some CVS documentation, just to get a feel for what is going on.

Alternatively you could try a more user friendly version control system like for example Perforce or Microsoft Source Safe. Zeus can connect to any version control that supports the SCC interface.

Cheers Jussi

Hi Jussi,
Thanks for the reply.
I go through all the steps as per the instruction and hit the create project button in step 13.

however when I go to step 14 and then 15 I get the following error message

Unknown project. The workspace must be configured or the project must be added to the source control system.

Is there anyway in which I can cut and paste screen dumps into this message to show you the screen shots of the set-up?

regards

Alan.

Hi Alan,

I ran through the all the steps of the example but for me I had no trouble adding the project to the version control

So all I can suggest make sure you have a folder called c:\projects\cvsroot and make sure the c:\projects\ and c:\projects\cvsroot folders are both empty.

Next open the example workspace in Zeus and using the Workspace Options menu, make sure the Source Control section contains no source control details other than having the Use SCC version control option checked on.

At this point I would the suggest closing then restarting Zeus and then move straight to step 12 of the example.

This time when you are presented with the Create Project dialog make sure the CVSROOT details are correctly set to c:\projects\cvsroot.

If this still fails use the Workspace, Source Control, View Source Control Output menu and post the output displayed to this thread.

Cheers Jussi

Hi Jussi,

here is the output you requested.

---------------------------------------------------------------------------
Zeus for Windows Programmers Editor - Version 3.95v
Copyright (c) Xidicone Pty Ltd 1993-2005. All rights reserved.
---------------------------------------------------------------------------

The project was successfully created.

Connecting to version control database.
Looking for version control details in the project file....
WARNING: No project details found in make file, using values passed in.
===================================================================
Zeus SCC-CVS Interface, Version 1.97
Xidicone Pty Ltd, Copyright (c) 2005
All rights reserved
http://www.zeusedit.com
===================================================================
cvs.exe -d :local:c:\project\cvsroot init
The current CVS project is being updated.
cvs.exe -d :local:c:\project\cvsroot -r co sql scripts
cvs.exe checkout: Updating sql
cvs.exe checkout: cannot find module `scripts' - ignored
Project Details
===============
Command, User, Project, AuxPath, Local Directory
cvs.exe -d :local:c:\project\cvsroot
sql scripts
:local:c:\project\cvsroot
G:\Central File Structure\5.0 Projects\5.137 Exel - Migrate DB\Tradeteam sql scripts 2852006\
Return Code: -2

The version control details are:
Scc_ProjName sql scripts
Scc_AuxPath :local:c:\project\cvsroot
Scc_LocalPath G:\Central File Structure\5.0 Projects\5.137 Exel - Migrate DB\Tradeteam sql scripts 2852006
ERROR connecting to version control database.
Return Code: -2
User ID:
Scc_ProjName sql scripts
Scc_LocalPath G:\Central File Structure\5.0 Projects\5.137 Exel - Migrate DB\Tradeteam sql scripts 2852006
Scc_AuxPath :local:c:\project\cvsroot

WARNING: Used project details supplied yet project failed to open. Make sure the project
details in the project file are correct. See online help for more details.

Unknown project. The workspace must be configured or the project added to the source control system.

Unknown project. The workspace must be configured or the project added to the source control system.


Connecting to version control database.
Looking for version control details in the project file....
WARNING: No project details found in make file, using values passed in.
SccOpenProject
===================================================================
Zeus SCC-CVS Interface, Version 1.97
Xidicone Pty Ltd, Copyright (c) 2005
All rights reserved
http://www.zeusedit.com
===================================================================
The current CVS project is being updated.
cvs.exe -d :local:c:\project\cvsroot -r co sql scripts
cvs.exe checkout: Updating sql
cvs.exe checkout: cannot find module `scripts' - ignored
Project Details
===============
Command, User, Project, AuxPath, Local Directory
cvs.exe -d :local:c:\project\cvsroot
sql scripts
:local:c:\project\cvsroot
G:\Central File Structure\5.0 Projects\5.137 Exel - Migrate DB\Tradeteam sql scripts 2852006\
Return Code: -2

The version control details are:
Scc_ProjName sql scripts
Scc_AuxPath :local:c:\project\cvsroot
Scc_LocalPath G:\Central File Structure\5.0 Projects\5.137 Exel - Migrate DB\Tradeteam sql scripts 2852006
ERROR connecting to version control database.
Return Code: -2
User ID:
Scc_ProjName sql scripts
Scc_LocalPath G:\Central File Structure\5.0 Projects\5.137 Exel - Migrate DB\Tradeteam sql scripts 2852006
Scc_AuxPath :local:c:\project\cvsroot

WARNING: Used project details supplied yet project failed to open. Make sure the project
details in the project file are correct. See online help for more details.

Unknown project. The workspace must be configured or the project added to the source control system.

Unknown project. The workspace must be configured or the project added to the source control system.


Connecting to version control database.
Looking for version control details in the project file....
WARNING: No project details found in make file, using values passed in.
SccOpenProject
===================================================================
Zeus SCC-CVS Interface, Version 1.97
Xidicone Pty Ltd, Copyright (c) 2005
All rights reserved
http://www.zeusedit.com
===================================================================
The current CVS project is being updated.
cvs.exe -d :local:c:\project\cvsroot -r co sql scripts
cvs.exe checkout: Updating sql
cvs.exe checkout: cannot find module `scripts' - ignored
Project Details
===============
Command, User, Project, AuxPath, Local Directory
cvs.exe -d :local:c:\project\cvsroot
sql scripts
:local:c:\project\cvsroot
G:\Central File Structure\5.0 Projects\5.137 Exel - Migrate DB\Tradeteam sql scripts 2852006\
Return Code: -2

The version control details are:
Scc_ProjName sql scripts
Scc_AuxPath :local:c:\project\cvsroot
Scc_LocalPath G:\Central File Structure\5.0 Projects\5.137 Exel - Migrate DB\Tradeteam sql scripts 2852006
ERROR connecting to version control database.
Return Code: -2
User ID:
Scc_ProjName sql scripts
Scc_LocalPath G:\Central File Structure\5.0 Projects\5.137 Exel - Migrate DB\Tradeteam sql scripts 2852006
Scc_AuxPath :local:c:\project\cvsroot

WARNING: Used project details supplied yet project failed to open. Make sure the project
details in the project file are correct. See online help for more details.

Unknown project. The workspace must be configured or the project added to the source control system.

Unknown project. The workspace must be configured or the project added to the source control system.


Connecting to version control database.
Looking for version control details in the project file....
WARNING: No project details found in make file, using values passed in.
SccOpenProject
===================================================================
Zeus SCC-CVS Interface, Version 1.97
Xidicone Pty Ltd, Copyright (c) 2005
All rights reserved
http://www.zeusedit.com
===================================================================
The current CVS project is being updated.
cvs.exe -d :local:c:\project\cvsroot -r co sql scripts
cvs.exe checkout: Updating sql
cvs.exe checkout: cannot find module `scripts' - ignored
Project Details
===============
Command, User, Project, AuxPath, Local Directory
cvs.exe -d :local:c:\project\cvsroot
sql scripts
:local:c:\project\cvsroot
G:\Central File Structure\5.0 Projects\5.137 Exel - Migrate DB\Tradeteam sql scripts 2852006\
Return Code: -2

The version control details are:
Scc_ProjName sql scripts
Scc_AuxPath :local:c:\project\cvsroot
Scc_LocalPath G:\Central File Structure\5.0 Projects\5.137 Exel - Migrate DB\Tradeteam sql scripts 2852006
ERROR connecting to version control database.
Return Code: -2
User ID:
Scc_ProjName sql scripts
Scc_LocalPath G:\Central File Structure\5.0 Projects\5.137 Exel - Migrate DB\Tradeteam sql scripts 2852006
Scc_AuxPath :local:c:\project\cvsroot

WARNING: Used project details supplied yet project failed to open. Make sure the project
details in the project file are correct. See online help for more details.

Unknown project. The workspace must be configured or the project added to the source control system.

Unknown project. The workspace must be configured or the project added to the source control system.



thanks

Alan.

Scc_LocalPath G:\Central File Structure\5.0 Projects\5.137 Exel - Migrate DB\Tradeteam sql scripts 2852006
ERROR connecting to version control database.
Return Code: -2

This looks like the error to me My guess is the local path might be either too long or there is some issue with the format of the actual file name

Is this the actual name of the SQL file: Tradeteam sql scripts 2852006

As a test I would suggest trying a few simple file names something like c:\test\script.sql for example. If these shorter file names work, then this definitely means the problem somehow relates to the structure or length of your script file names.

Cheers Jussi

Hi Alan,

After some more testing I think the problem relates to the fact that the last name in the directory tree contains a white space character.

The last name of the directory tree corresponds to the project name (this should also correspond to the workspace name) and it is the fact that this project name contains a white space character that is causing the issue.

Cheers Jussi

Hi Jussi,
thanks for the responses. I have tried again using local directories and got the following

---------------------------------------------------------------------------
Zeus for Windows Programmers Editor - Version 3.95v
Copyright (c) Xidicone Pty Ltd 1993-2005. All rights reserved.
---------------------------------------------------------------------------

The project was successfully created.


Connecting to version control database.
Looking for version control details in the project file....
WARNING: No project details found in make file, using values passed in.
===================================================================
Zeus SCC-CVS Interface, Version 1.97
Xidicone Pty Ltd, Copyright (c) 2005
All rights reserved
http://www.zeusedit.com
===================================================================
cvs.exe -d :local:c:\project\cvsroot\ init
The current CVS project is being updated.
cvs.exe -d :local:c:\project\cvsroot\ -r co sql scripts
cvs.exe checkout: Updating sql
cvs.exe checkout: cannot find module `scripts' - ignored
Project Details
===============
Command, User, Project, AuxPath, Local Directory
cvs.exe -d :local:c:\project\cvsroot\
sql scripts
:local:c:\project\cvsroot\
C:\sql scripts\
Return Code: -2

The version control details are:
Scc_ProjName sql scripts
Scc_AuxPath :local:c:\project\cvsroot\
Scc_LocalPath C:\sql scripts
ERROR connecting to version control database.
Return Code: -2
User ID:
Scc_ProjName sql scripts
Scc_LocalPath C:\sql scripts
Scc_AuxPath :local:c:\project\cvsroot\

WARNING: Used project details supplied yet project failed to open. Make sure the project
details in the project file are correct. See online help for more details.

Unknown project. The workspace must be configured or the project added to the source control system.

Unknown project. The workspace must be configured or the project added to the source control system.


not sure where to go from here

regards

Alan.

Hi Jussi,
I am making progress slowly. I now have some sql scripts which are in CVS. However when I check out a file and look at history I get the following message

cvs.exe -d :local:c:\project\cvsroot log create_database.sql

cvs.exe log: create_database.sql has been added, but not committed

How do I commit ?

regards


Alan.

Hi Alan,

As is shown in the log output window:

cvs.exe -d :local:c:\project\cvsroot\ -r co sql scripts
cvs.exe checkout: Updating sql
cvs.exe checkout: cannot find module `scripts' - ignored
C:\sql scripts\
Return Code: -2

The CVS command failed to run. The reason is you local directory contains a white space character: The cannot find module `scripts' - ignored message shows that the CVS was confused as it thinks sql scripts is two modules (ie projects) and not a single project. This can be fixed by wrapping the module name in quotes , but that requires a new Zeus SCC-CVS dll to be release.

So in a nutshell the until a new dll is produced, the current Zeus SCC-CVS dll does not support folder names that contain white spaces.

Until that happens you can only have folders that contain no spaces.

Cheers Jussi

Hi Jussi,
Thanks.
I have created as per your instructions. I right click on a file and check it out. What is the process that happens then. The file doesn't appear in the workspace area to edit. Hope this makes sense.


regards

Alan.

Hi Alan,

When you check out the file all you have done is got the latest version of the file from the repository and it is now ready for editing in your local folder. You can now make changes to the file as required.

At any time:

You can use the difference command to compare your changes to the version in the repository.

You can throw away your changes and release the check out with the undo checkout.

You can throw away your changes but keep the check out with the get latest version.

You make your changes permanent by doing a check-in.

You can see the histroy of change for any file using the history command.

etc. etc.

Cheers Jussi