Skip to main content

Posts

Connect to SBO 8.8 via DIAPI

been trying to connect with simple step using DIAPI for SBO 8.8 got same issue: Connection to license server failed; if license server address is invalid, correct it; if TAO NT Naming Service stopped, activate it and restart License Manager after searching for 2 days, got the solution 1. Please check if the ports 30000 and 30001 is not blocking 2. Check if have any kind of anti-virus run 3. Please remove and re-install the server tools again. 4a. Go to the folder 'C:\Program Files\SAP\SAP Business One\ServerTools\License' (check in the security properties, if the current user has Full Controller to the folder (Right click > Security > Permissions) b. In the folder 'C:\Program Files\SAP\SAP Business One\ServerTools\License' check the file "NT_Naming_Service.exe", Right click > Security > Permissions > and check if you have full control in this file. 5. Please check if the SQL services and SBO Licenses Server is running automatically Please also t...
Post a Comment
Read more

VB.NET and C# Comparisons

VB.NET Program Structure C# Imports System Namespace Hello Class HelloWorld Overloads Shared Sub Main (ByVal args() As String) Dim name As String = "VB.NET" 'See if an argument was passed from the command line If args.Length = 1 Then name = args(0) Console.WriteLine("Hello, " & name & "!") End Sub End Class End Namespace using System; namespace Hello { public class HelloWorld { public static void Main (string[] args) { string name = "C#"; // See if an argument was passed from the command line if (args.Length == 1) name = args[0]; Console.WriteLine("Hello, " + name + "!"); } } } VB.NET Comments C# ' Single line only REM Single line only ''' XML comments // Single line /* Multiple line */ /// XML comments on single line /** XML comments on multiple lines */ VB.NET Data Types C# Value Types Boolean Byte, SByte ...
Post a Comment
Read more

How to display an assembly in the "Add Reference" dialog box

When you are developing a class library, you may want Visual Studio .NET to list your library in the Add Reference dialog box on the .NET tab without the user having to browse for it. This issue is not resolved if you install your assembly to the global assembly cache, because the Add Reference dialog box is path-based and does not enumerate the components from the global assembly cache. To display your assembly in the Add Reference dialog box, you can add a registry key, such as the following, which points to the location of the assembly [HKEY_CURRENT_USER\SOFTWARE\Microsoft\.NETFramework\AssemblyFolders\ MyAssemblies ]@="C:\\ MyAssemblies " where MyAssemblies is the name of the folder in which the assemblies reside. NOTE : You can create the this registry entry under the HKEY_LOCAL_MACHINE hive. This will change the setting for all of the users on the system. If you create this registry entry under HKEY_CURRENT_USER , this entry will affect the setting for only the cur...
Post a Comment
Read more

Put Decimal Value in Total query

if ur query return like this 123456789 and u want to put decimal to it try this query SELECT CONVERT(VARCHAR(100),CONVERT(MONEY, 123456789), 1) from BOL The following table shows the values for style that can be used for converting money or smallmoney to character data. Value Output 0 (default) No commas every three digits to the left of the decimal point, and two digits to the right of the decimal point; for example, 4235.98. 1 Commas every three digits to the left of the decimal point, and two digits to the right of the decimal point; for example, 3,510.92. 2 No commas every three digits to the left of the decimal point, and four digits to the right of the decimal point; for example, 4235.9819. hope this help see u
Post a Comment
Read more

Using Half Size Form in Crystal Reports

i have a hard time trying to solve this one scenario: at first, we using Letter format to print Delivery Order and Invoice..it run smoothly and in CR we just using Letter as the Page Setup.. now new paper format is coming which is half of the Letter size at first i thougt it is easy because we only need to create new paper size on Server Properties under Printer and Faxes then use the new size at Paper Size in CR then redesign it to fit but it all when wrong, eventhough it display correctly but when i want to print it, it turn up everything that vertical become horizontal..very2 strange behaviour so i give using CR.PrintReport method..i ended up format it to .rtf then print it using this code Dim oDoc As New ReportDocument Dim sFileName As String = String.Empty oDoc.Load(_ReportPath) 'must use this line to make sure it print using the new size 'credit goes to Ali from dotnet.netindonesia.net Dim printDoc As System.Drawing.Printing.PrintDocument = New System.Dra...
Post a Comment
Read more