Within SL include the Screen / Report through .INI file &. CRP file

INI file

• An .Ini file is a text file with groups of keywords and variables also a way of storing data’s.
• Using INI files execute the SQL table, Views, procedure, Index, Trigger show as fig (1). Also mention drive path, Folder & Password (Password should be the correct Windows login password) show as fig (2).

                                                                                       Fig (1)

                                                                                      Fig (2)

CRP file

• You can only issue SELECT and INSERT statements. UPDATE and DELETE are not supported.
• You can issue a CREATE TABLE statement but cannot specify a primary key, default value or foreign key constraints.
• You cannot create Indexes. As a result, the queries take much longer to run.
• You cannot create Triggers, Functions or Stored Procedures.

 Create an executable in a separate folder and place it in the Solomon root folder

Steps for Executing the Executable

1. Open Database Maintenance (9829000.exe)

              a.  On the Top of the Connect Server tab, enter the SQL Server Name, Login and password.

              b.  Set the path of configuration file to: <Solomon Root folder>\ Executable\ AR Aged .Ini. Use 

                   Browse button to locate the file.

              c.  Click the Connect button. 

            Note: The Path and Database mentioned here in the screen shot is only for reference   

                         purpose (Locate the AR Aged.ini file using the browse button).

             d.  Now select the Update Database tab.

                     ->  Select the correct system database from the System Database name Combo box.

                     ->  Select the correct Application database(s) names from the Databases Rich text box.

                      ->  Select the “Install – AR Aged – Tables & view" in update scenario as shown in the figure
                          below and also .INI file Template mention in figure (1).

                      ->  Click “Update Database” button

                      ->  If the system asks crenditals, enter it and click OK. Refer figure below.

      ->  Click the Ok button of the message “Database update process complete”

      ->  Close the Database maintenance screen with the Close button.

     2.  UPDATING DATABASE with DB Update.

             a.  Launch Solomon

             b.  Enter the Server name and the correct system database name in the Find Database (98.000.01)
                  as below.

             c.  Click OK to Login

             d.  In Solomon menu, Administration -> select Utility-> DB Update.

             e.  Select the appropriate Application Database(s).

             f.   Select the Drive from the Drive combo box where the delivery file is located.

             g.  From the Files Rich text box, select the following files.

                                Insert screen. CRP

             h.  Click Begin Processing.

                  Note: Refer the picture below for the Database update operation. The Path mentioned here in
                            the screen shot is only for reference purpose

     3.  Copy the Report (08500dp) from Executable folder and placed into the Usr_rpts.

     4.  Close the Solomon and Reopen it.
  

Upgrading issue - Visual Basic 6 Project to Visual Studio.NET Project

When i am trying upgrade my VB 6 Project to Visual Studio 2005.NET, i encountered an error saying

"Upgrade failed: Exception Occured : Could not load referenced component MSCOMCT2.OCX(2.0.0)
You need to install this component before u upgrade the project."

Solution:

• Install .ocx component
• Open command pro

                  REGSVR32 "C:\Windows\System32\MSCOMCT2.OCX"

                                                                                (OR)

• Run the project in already installed vb.6.5 machine. Because 6.5 version  have MSCOMCT2.OCX.ocx file.