ERPConnect FAQ

From Theobald Software

If you can't find the answer you're looking for neither on this page nor in the manual, please contact mailto:support@theobald-software.com.

ERPConnect Misc.

Determine if a connection is valid

How do I know whether or not an ERPConnect.R3Connection object is already opened or closed? I have a shared connection object in a windows form, and I don’t want the user to supply credentials each time he clicks on a certain button.

Please use the ping() method of the connection object. It will never raise an exception only returns true / false depending on if the connection is active and usable.

Ports in Use

Which ports are used by SAP to establish the connection?

If a SAP-Router is used, the ports are 3299 and 3399. If not, the ports are 32XX and 33XX. XX is usually the Systemnumber (like 00, or 05)

SSO doesn't work

I'm not able to obtain a SSO ticket.

Please have a look at SAP Note 356691 and use the test tool described there to check if everything is set up correctly. You may also make sure that you have the latest ERPConnect release. German speaking customers may also have a look here: http://www.bsi.bund.de/gshb/deutsch/m/m04258.htm (Bereich 'Single Sign-On sicher konfigurieren')

Binding LINQ sets to a grid

I'm trying to bind a LINQ resultset to a DataGridView object. But it doesn't show any rows

You must use a so called BindingSource object between the LINQ resultset and the DataSource property of the grid:

var ms = from m in sapcon.MARAList where m.MATNR == "100-100" select m;
 
Form1 f = new Form1();
BindingSource bs = new BindingSource(ms,"");
f.dataGridView1.DataSource = bs;

Or you can use the ToList() method:

var ms = from m in sapcon.MARAList where m.MATNR == "100-100" select m;
 
Form1 f = new Form1();
f.dataGridView1.DataSource = ms.ToList();

Using Passwords with Blanks

I want to use a password with blanks inside

You can use blank charakters in your password, if you quote your password using double quotes.

R3Connection con = new ERPConnect.R3Connection("ptmalg", 05, "User", "\"My Password\"", "EN", "800");

ReadTable class

Error Error in ASSIGN statement in the program SAPLSDTX

I'm getting an error Error in ASSIGN statement in the program SAPLSDTX when using the ReadTable class. But only some tables cause this problem.

This error comes from a bug in one of the SAP's own function modules. The tables that cause the bug contain at least one column of type F (floating point) There are two ways to avoid this error:

• Create a view in SAP over the table that causes the error. Leave out all columns of type F and use the ReadTable class to run the view instead of the table.
• Install the function module Z_XTRACT_IS_TABLE into you system. Then call the method ReadTable.SetCustomFunctionModule("Z_XTRACT_IS_TABLE") before running the extraction. Please have a look here to learn more about the installation of the function module.

Queries

Date format

I'm trying to run a query with the following date paramater
qry.SelectionParameters(0).Ranges.Add(Sign.Include, RangeOption.Equals, "11-07-2007")
but it keeps failing with the following error: "Entry too long (please enter in the format __-__-____)"

For date values please use the technical format YYYYMMDD (e.g. 20070703)