Hi,

How can I connect to database  Sage50? what is the database Sage 50? MySQL?

There are three ways you can send transactions into the Sage program.  The database is MySQL:

1.  Import is possible in a sort of comma-delimited format.

2. The Sage SDK can be downloaded and used to build programs in VB, C++ and C# 

Location of SDK:

http://sagecity.na.sage.com/support_communities/sage_50_accounting_ca/f/156/p/72525/222964.aspx#222964

3.  Sage 50 comes with a free ODBC connection, entries directly to the database can be made through this method.   Directly writing to the database is strongly discouraged.  

Sage 50 uses the MySQL database more as a data store than a relational database management system.  It does not enforce referential integrity in the database manager, and uses a complex system of flags and 'nxtpids' to keep track of the next valid ID.  In a single-user environment it might be just possible, but still not a good idea.

One other 'safe' way that I know of, is to use 'AutoHotKey' to 'key' data directly into the interface from a script.

where is the database Sage 50 instalation?

Installed by default on every installation, to the local workstation.  Read the Connection Manager documentation for port information.

which table could I update the GL

Use the methods in the SDK.  The import format is also explained in dev-import.pdf. 

Or, study dev-datarel.pdf and dev-datadict.pdf until you're 100% sure you know which tables to update for every transaction.  It's an OLTP system, not a batching system, so it's complex.

I used the file SAG50\Backup.SDB1\UNIVERSL.SAI for test with your Sample VB.NET, but I have an error message :"Cannot open the database. Please select another file."

what is the Enter File Name, User Name and PassWord.

what is the szHost, szPort.

This function is return false :

wSDBOpenDatabase(iDBLink, FLG_SHARED, "Sample", szUserName, szPassword, szHost, "", szPort)

which the parameter for test this function.

thanks

If other users have not been set up, the username is 'sysadmin' and there is no password.

Passwords are limited to 7 characters in the program interface.  If someone tells you their password is 'gunsm0ke', for example, because that's what they type, logging in from the SDK will fail unless you use 'gunsm0k'

If you're having file version problems, possibly the executable file you are running is not the latest one, or if you're using a sample file, possibly it has not been opened in the software and converted to the latest version.

Thanks you your reply

Hi

I like to download new SDK 2014.2 SDK, I can't download. how can I download the new SDK.. I have a message like this *....... cmd /c dir/b/ad "%systemroot%\Microsoft.NET\Framework"&pause

I try with username = sysadmin  and the password = gunsm0ke.... I go to Sage50 to modify the new password too.. but it's not work in the sample SDK VB.net

thanks

cmd /c dir/b/ad "%systemroot%\Microsoft.NET\Framework"&pause  

From a command line, that would give you a directory listing for Microsoft .net frameworks.  Any error regarding the .NET framework would mean an incompatible version of the Microsoft .NET framework / Windows SDK. 

Where is that message seen?

According to this post that I found by searching this site for '2014.2 SDK':

http://sagecity.na.sage.com/support_communities/sage_50_accounting_ca/f/156/p/72525/215667.aspx#215667

The latest Sage 50 SDK is at http://na.sage.com/ca/partners/development-partners-erp-crm-hrms

The default password for sysadmin is no password.  The note about the 7 characters was to point out that there's no error message in the SDK for longer passwords, but longer passwords will not work.  There's no apparent buffer overflow, it probably does a password hash on the whole thing, which is different from a password hash on the first 7 characters of the string.

cmd /c dir/b/ad "%systemroot%\Microsoft.NET\Framework"&pause  

From a command line, that would give you a directory listing for Microsoft .net frameworks.  Any error regarding the .NET framework would mean an incompatible version of the Microsoft .NET framework / Windows SDK. 

Where is that message seen?

According to this post that I found by searching this site for '2014.2 SDK':

http://sagecity.na.sage.com/support_communities/sage_50_accounting_ca/f/156/p/72525/215667.aspx#215667

The latest Sage 50 SDK is at http://na.sage.com/ca/partners/development-partners-erp-crm-hrms

The default password for sysadmin is no password.  The note about the 7 characters was to point out that there's no error message in the SDK for longer passwords, but longer passwords will not work.  There's no apparent buffer overflow, it probably does a password hash on the whole thing, which is different from a password hash on the first 7 characters of the string.

Hi

the message comme from I click on the 2014.2 SDK

the message lik this

dlm.na.sage.com/d.aspx

In order to utilize the Sage Download Manager you need to install .NET Framework 4.0 on your machine. The following are the steps to find installed versions of the .NET Framework.

Open the Run dialog box (Windows Key + R), enter the following command and choose OK.

           cmd /c dir/b/ad "%systemroot%\Microsoft.NET\Framework"&pause

If you do not find v4.0.xxxxx in the list, please download and install from the following link

NET Framework 4 - Microsoft

If you require further assistance please contact Sage Technical Support at 1-866-996-SAGE(7243).

thanks

Hi,

The downloader will require that you have the .NET framework 4 on your system.

Also, you will need it to run 2014 Sage 50 program, and

you'll need it installed to compile the .NET samples that come with the SDK

You can get the .NET framework 4.0 from Microsoft:

http://www.microsoft.com/en-ca/download/details.aspx?id=17851