API Toolkit samples

unknown

I am working on developing an app to read various data sets from the Visual Manufacturing database  Our environment is as follows:

Windows 2012R2 server running SQL Server 2014

Visual 9.0.8 SP4 (VMFG API Toolkit taken from this ISO)

Microsoft Visual Studio 16.8.1

programming in C#

-----------------------------------

In an attempt to familiarize myself with the API calls, I tried to use one of the sample projects in Visual Studio - TestWorkOrders, I change the processing to x86, place my database.config file in the project and ensure all the references are properly linked.  When I debug the project, I receive the following error message when trying to login to the database

"Could not load file or assembly 'Oracle.ManagedDataAccess, Version=4.121.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies.  The system cannot find the file specified."

For starters, I am not using Oracle, but Microsoft SQL.  I looked through the entire project and I cannot find where the load requirement is coming from.  Can anyone point me in the right direction?  This error is reproduced in other examples packaged with the toolkit.  I am guessing the creator made all the samples with an Oracle back end.

Regards,

Todd

charles-hooper

Todd,

If you are a member of the Visual Manufacturing VMIUG-TEC group on Google Groups, take a look at the six part article series on the Visual API Toolkit that I put together in late 2019.  In the VMIUG-TEC group you will also have access to an API Toolkit presentation and related files that I provided at the July 2017 Michigan Visual user group, as well as several other presentations and articles.  Part Six of the article contains links to the earlier articles in the series (so you will want to start at part one and work your way to part six).  
How To: Using the Visual Manufacturing API Toolkit - Part 6 (google.com)

If you are not yet a member of the VMIUG-TEC group, you will need a free Gmail account, and then sign up using the following link:
https://groups.google.com/forum/#!search/vmiug  I am one of the administrators of the VMIUG-TEC group.  To keep spam under control, please specify the following information when requesting to join:

1. The Visual version you currently use.
2. The company you are working for.
3. Your company email address.
4. Your position and why you wish to join.

To get started resolving the problem, I suggest creating a folder on your C: drive named C:VMFGAPIToolkit -  copy the following files from your centralized Visual .EXE folder to that folder (you will create the Database.config file with the VmfgConfigForms.exe program):
Database.config
LSACORE.DLL
LSADATA.DLL
LSADTAREGISTER.EXE
LSASHARED.DLL
MICROSOFT.SCRIPTING.DLL
MICROSOFT.SCRIPTING.METADATA.DLL
ORACLE.MANAGEDDATAACCESS.DLL
ORACLE.MANAGEDDATAACCESSDTC.DLL
VmfgConfigForms.exe
VMFGCONFIGFORMS.EXE.CONFIG
VMFGFINANCIALS.DLL
VMFGINVENTORY.DLL
VMFGPURCHASING.DLL
VMFGSALES.DLL
VMFGSHARED.DLL
VMFGSHOPFLOOR.DLL
VMFGTRACE.DLL

In the C# project, add a reference to the C:VMFGAPIToolkitORACLE.MANAGEDDATAACCESS.DLL file (that reference must always be added, even with a SQL Server back end), selecting in the reference properties Copy Local to True.  You will also need to add a reference to LSACORE.DLL, LSADATA.DLL, VMFGSHARED.DLL, and any other API Toolkit DLL that is required (always selecting in the reference properties Copy Local to True).  Once you generate the Database.config, you will need to manually copy that file to the project's binDebug and binRelease folders.

Hopefully, that information helps you get started.

Charles Hooper
Senior Software Engineer
Meadville Forging Company