.NET FRAMEWORK AND OE

What exactly are you trying to do?

The code looks like you're using an API provided by Sage. You're trying to connect to the AppServer directly? Please search for "Open client" here:

community.progress.com/.../2911.openedge-11-7-product-documentation

Or ODBC to the Database? Check above link for the SQL Development.

Looks like he's trying to create data (one account record) in Sage and probably want to do it from the 4GL, so it's more about adding the SDK to assemblies and 'translate' the c# code to 4GL...

That's a possibility too. But as there are OpenEdge applications from Sage too, it might he helpful to hear from the OP what he's trying to do.

I have followed a suggestion in progress talk. I create assembly. Xml with sage dll.

I tried to translate code but I have big problem to do that.

if you want you can check discussion, with sample and documentation, o 98n progress talk. My ID is gasomma.

Many thanks.

Which OpenEdge release are you using?

You are aware to this translation guide: documentation.progress.com/.../dvngm.pdf

Is there a specific line where you get stuck?

I tried 11.7 and 10.2b because sage dll needs. Net framework 3.5.

if (lConnection.DoValidate((oneSage.SDK.RD.Validating.Interface.IInfoList)lInfoList) == true) {

try {

I cannot translate for example

Hi Mike, good the string is correct. Thanks.

But the next 2 lines:

  oneSage.SDK.RD.Data.SageStart.AccountDataTable lTbl = lDataSet.Account;

  oneSage.SDK.RD.Data.SageStart.AccountRow lRow = lTbl.NewAccountRow();

translated with:

 DEFINE VARIABLE lTbl AS oneSage.SDK.RD.Data.SageStart.AccountDataTable NO-UNDO.

 DEFINE VARIABLE lRow AS oneSage.SDK.RD.Data.SageStart.AccountRow NO-UNDO.  

Progress OE gives an error (in Italian)

Tipo di dati specificato non valido: oneSage.SDK.RD.Data.SageStart.AccountDataTable. Specificare un tipo di dati come 'character' o il nome di una classe. (5638)

**  Impossibile interpretare linea 69. (196)

Thank you. I sent a documentation.

According to the documentation the class names seem coorrect. So you may be missing an Assembly reference. That's something I don't find in your documentation. So you might need to contact Sage and see which assemblies need to be added to the project.

There is another way "web service". Example in C# below:

Is it possible to translate in OE code?

Thx.

Console.WriteLine("Get Data...");

string lUrl = @"sdata.sageschweiz.ch:5493/.../Kontakte";

HttpWebResponse lResponse = null;

HttpWebRequest lRequest = null;

lRequest = (HttpWebRequest)WebRequest.Create(lUrl);

lRequest.Method = "Get";

// get response

try {

lResponse = lRequest.GetResponse() as HttpWebResponse;

using (StreamReader sr = new StreamReader(lResponse.GetResponseStream())) {

try {

string lXml = sr.ReadToEnd();

XmlDocument lXmlDoc = new XmlDocument();

lXmlDoc.LoadXml(lXml);

Console.Write(lXml);

} catch (Exception lEx) {

Console.Write(lEx.Message);

}

}

} catch (WebException lWebEx) {

// Get error

Console.WriteLine("Exception Message :" + lWebEx.Message);

if (lWebEx.Status == WebExceptionStatus.ProtocolError) {

var lResponse2 = ((HttpWebResponse)lWebEx.Response);

Console.WriteLine("Status Code : {0}", lResponse2.StatusCode);

Console.WriteLine("Status Description : {0}", lResponse2.StatusDescription);

using (var stream = lResponse2.GetResponseStream()) {

using (var reader = new StreamReader(stream)) {

var text = reader.ReadToEnd();

Console.WriteLine(text);

}

}

}

} finally {

// Close connection

lResponse.Close();

}

That's probably possible as well! Peter Judge can probably translate that for you into using the ABL http client.

However, I personally would prefer to use the .NET Assemblies as that provides you strong typed access to the API and most likely much more precise error handling. It's probably just a simple thing like an assembly reference that you are missing.

If you want, we can offer you professional support in that matter through a remote meeting. It should not take more than two hours to know if we get that to work or now.

Thanks for your suggestion.

For your professional offer send me a quotation and I discuss with my company.

A.

Hi Mike,

I still received any news from you? Could you pls help me?

Thx a lot

Hi Mike,