ArticlesArticles Most Helpful ArticlesMost Helpful Articles Language SettingsLanguage Settings LoginLogin
RSS Feeds
DrillDown Icon Table of Contents
DrillDown Icon MX
DrillDown Icon MANUALS and Other Info for SQL MANEX Client Server
DrillDown Icon Hardware and Software Requirements for Installing SQL Server
DrillDown Icon List of Modules Converted to MANEX Client Server
DrillDown Icon Installing SQL Server
DrillDown Icon System Administrator
DrillDown Icon SQL Backup Options
DrillDown Icon Setup the OLE DB(ADO) for SQL Crystal Reports
DrillDown Icon APIs
DrillDown Icon Code that could be used to find Last Table Modified within SQL
DrillDown Icon Configure SQL Server 2008 R2 to allow Network Connections
DrillDown Icon How to detach and attached databases using the SQL Server Management Studio
DrillDown Icon Restore SQL DB from Backup
DrillDown Icon Setup a SQL Test/Sandbox Database
DrillDown Icon SQLManex Client Server Setup Instructions
DrillDown Icon Setup Folder Permissions to Write "ini" File
DrillDown Icon Setup the ODBC for SQL Crystal Reports
DrillDown Icon Setup a SQL Database Maintenance Plan
DrillDown Icon Setup Task Scheduler to Auto Run MRP
DrillDown Icon Selecting the Authentication Mode
DrillDown Icon Window 10 - Network Disconnect
DrillDown Icon Setup Work Stations
DrillDown Icon Security System
DrillDown Icon Accounting Setup
DrillDown Icon System Setup
DrillDown Icon Operations Manuals
DrillDown Icon System Utilities
DrillDown Icon SQL Server Memory Settings and Performance
DrillDown Icon Definitions
DrillDown Icon How to schedule and automate backups of SQL Server databases in SQL Server Express
DrillDown Icon SQL_FAQ's
DrillDown Icon Customer Relationship Management (CRM)
DrillDown Icon ManEx Minute
DrillDown Icon ManEx Component Exchange
DrillDown Icon ManEx Supplier Directory & Rankings
  Email This ArticlePrint PreviewPrint Current Article and All Sub-Articles
 
SQLManex Client Server Setup Instructions

1.) Create new Directory (Folder) called ManexSql (you can name it something different but the folder name cannot have any spaces in the name or it won't work). You will encounter a GOUSER Count not found; error.

2.) Extract files {provided by Manex} into the ManexSqlBeta Directory (with the subfolder option enabled). Below is a sample screen shot of how the directory should look when all files are extracted.

3.) Open the ((ManExSQL.ini)) and make modifications to the highlighted fields shown below to match your SQL Server. Save and close the ((ManExSQL.ini)) Note: Make sure there are NO spaces for example WSID : or WS ID: or WSID: comp 1. See below for correct entry.

4.) You can now begin using MANEX SQL Client Server. 

(note) If you run into MSVCP71.dll Missing from Computer message go to this article to fix it: MSVCP71

5.) Once the data set has been attached, you should be able to enter any of the highlighted Executables.

SQLMANEX.EXE is where you will find the Production and Accounting modules that have been converted at this time. Reference the following link for the modules we have converted at this time.

 

6.) In addition, you will also have to run the Manex library files to install the necessary VFP .dll files to run the Client Server applications. Here is instructions for installing those. Install Manex library files

7.) Here are Links to KB article for SQL FAQ’s in case you run into additional issues/references not covered above. SQL FAQ and SQL SYSTEM ADMIN.

8.) We also need to mention that the first time you enter a particular module it might take some time to load, but it should only be the first time that you access that module. After that point SQL has the information needed and every subsequent access of the module should be faster. if you notice any module that response time that does not approve after the first access, please note it and let us know.

Article ID: 5506