Search results

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...