They probably communicate using ODBC. Check to see if there are any DSNs defined on either end. I believe the tool for this is called Data Providers and can be found in Administrative Tools in Windows.
I've had success using the MERANT Progress ODBC Driver. Once you set up a DSN to your Symix server, you can create an ADO connection in Access like so:
Dim ConnectString as String
Dim Symix as ADODB.Connection
ConnectString = "Provider=MSDASQL; DSN=_____"
Set Symix = New ADODB.Connection
With...
Hi, I'm new to Syteline and I'm trying to write a utility that can move/adjust inventory using ADO to access the database. The problem with this is that I'm not sure how to generate new material transactions. I can insert a new row in the matltran table, but getting a proper trans-num value is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.