Skip to Content
avatar image
Former Member

SAP .NET Connector

While trying to connect to SAP Database using .NET Connector 2.0.1 the following error occurs:

"SAP.Connector.RfcException: Missing R3NAME=... or ASHOST=... in connect_param in RfcOpenEx at SAP.Connector.Connection.Open() at SAP.Connector.SAPLoginProvider.OpenSAPConnection(Page p, String connstr, Boolean persist) at WebApplication1.SAP_Login_Page.Login_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\webapplication1\sap login page.aspx.cs:line 97".

Any help is very much appreciated.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • avatar image
    Former Member
    Jun 05, 2006 at 02:04 PM

    Kusal,

    Check if you have given the paramenters something similar to

    "ASHOST=HOSTIP SYSNR=00 CLIENT=000 USER=USERNAME PASSWD=MINISAP ABAP_DEBUG=1 trace=1 use_sapgui=1"

    Enter your password in all caps. Check below link for a similar discussion,

    using-sapnet-connector-and-minisap

    Regards

    Krupa

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 13, 2006 at 09:46 AM

    It seems that you use the SAP Login Page. If you open it in designer, you see a destiantion object in the lower area.

    This destination is not configured by default. You need to click on it and configure all necessary parameters in the property window, e.g. Application Server, System Number, Username, Password, and Client.

    A quick way to configure the destination is dragging a SAP Server node from the Server Explorer while holding the Shift key. This trick will transfer all setting of the dragged node to the destination on the designer.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 18, 2006 at 10:06 PM

    I have the same problem.

    "SAP.Connector.RfcException: Missing R3NAME=... or ASHOST=... in connect_param in RfcOpenEx at SAP.Connector.Connection.Open() at SAP.Connector.SAPLoginProvider.OpenSAPConnection(Page p, String connstr, Boolean persist) at WebApplication1.SAP_Login_Page.Login_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\webapplication1\sap login page.aspx.cs:line 97".

    I followed the thread - using-sapnet-connector-and-minisap

    But not helpful.

    I also set the properties - Application Server, System Number, Username, Password, and Client.

    ..... still not useful.

    Can someone help me please ? , its really urgent for me!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 19, 2006 at 05:25 PM

    Problem solved ... Thanks

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Hari. I have the same problem:

      SAP.Connector.RfcException: Missing R3NAME=... or ASHOST=... in connect_param in RfcOpenEx at SAP.Connector.Connection.Open() at SAP.Connector.SAPLoginProvider.OpenSAPConnection(Page p, String connstr, Boolean persist) at Customers_From_SAP.SAPLogin2_aspx.Login_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\Customers From SAP\SAPLogin2.aspx.vb:line 76

      Could you please tell me how you solved yours?

      Thank you in advance.

  • avatar image
    Former Member
    Sep 06, 2006 at 10:25 PM

    I too have encountered this same problem with the 2.01 connector when trying to initialize an SAPLogonDestination.

    When you attempt to set the ConnectionString property (or even if you use ParseConnectionString), the ASHOST parameter gets stripped from the connection string. The other parameters correctly populate the destination object, but the AppServerHost parameter is left blank, which cripples the object (AppServerHost is readonly).

    I can work around this by setting the individual properties of the destination object manually (Client, DestinationKey, DestinationName, Username and Password), but my preference is to be able to use a single string which can be pulled from an external source (we don't want to hard code this into the program).

    Add comment
    10|10000 characters needed characters exceeded