All posts by DigitalNetHosting

In 2009 the actual question is your Dynamics GP or Great Plains ERP version.  If you are on Dynamics GP 10.0 or 9.0, then you can enjoy deploying eConnect or eConnect Runtime to program ecommerce integration directly in your Microsoft Visual Studio C# or VB.Net projects.  There is some chance, however, that if you are reading these lines – you are on older Great Plains Dynamics GP version: 8.0, 7.5, 7.0, 6.0, 5.5, 5.0 or earlier or even on Great Plains on Pervasive SQL Server or Ctree.  In old Great Plains Dynamics you have to program Microsoft SQL Server Stored Procedures or automate Great Plains Integration Manager Integration to work every 10 minutes or so.  Let’s review the scenarios.  Again, real life could be more complex, and there you need to call our office to get your case reviewed:

1.       eConnect.  This Software Development Kit, or in essence stack of interface calling technologies, based on SQL encrypted stored procedures, is available to you if you are on Dynamics GP 10.0 and also with some restrictions if you are on Great Plains Dynamics GP 9.0.  If you are on older Dynamics GP versions, econnect was in progress of being developed at the time, and it is up to you to try to deploy it – we recommend you to upgrade to Dynamics GP 10.0 and then work on eConnect integration programming

2.       SQL Stored Procedures Approach.  If eConnect is not an option for you, this means that you are on historical Dynamics GP Great Plains version, then you should consider direct SQL scripting to develop your ecommerce integration.  This job is really hard and prone to multiple data integrity errors and probes.  If you are experienced MS SQL Server DBA and you feel like you are ready to learn new MRP and ERP application, Microsoft Dynamics GP – including its data flow scenarios, and your job is secured for the next few years, then go ahead and try SQL Stored Procedures programming to accomplish Dynamics GP Great Plains integration project

3.       Pervasive SQL and Ctree.  These are really archaic versions, and if you have to commit to those older Great Plains platforms, please consider creative solutions, such as importing data to Great Plains tables via Microsoft SQL Server linked server constructions.  If you are doing direct Great Plains data repair, use Microsoft Access with ODBC connection to GP tables via linked tables technique

Source by Andrew Karasev

Microsoft Dynamics GP ERP, or former name for this accounting application is Great Plains Dynamics.  With the competition increase, especially with the introduction of such small and mid-size business ERP as SAP Business One, Microsoft Business Solutions changes the licensing schema.  Now you can get so-called Business Ready license, where most of the Great Plains Dynamics GP modules are included.  Historically, however small GP customers are on Great Plains Dynamics GP Standard, where you had to pay for each module separate.  Of course, this paper is our unofficial opinion, based on our relations with existing Great Plains customers:

1.       GP Business Ready advantages.  If you have company growth and now you are looking forward to implement such Great Plains modules as Manufacturing, Collection Management, Fixed Assets, Multicurrency, Sales Order Processing, Purchase Order Processing and others, you may benefit from the switch, especially considering relatively low cost to switch.  Consider the situation, when you currently have very basic Great Plains modules set: General Ledger, Payables Management, Receivables Management – that’s all, and you need additional functionality for your growing and becoming more complicated business processes

2.       Be defensive.  If you are staying with the same number of transactions in Great Plains Dynamics GP, then, you probably should stay with the GP Standard or Module based pricing.  New modules available through Business Ready program would not help you out or contribute to your current business processes, we assume that MRP and Manufacturing is not your specialization

3.       Manufacturing or Discrete Production.  In the case if you are in Manufacturing business, you may definitely win in switching to Great Plains Dynamics GP Business Ready licensing.  We assume that you are currently using inventory control and GP bill of materials modules to cover your Manufacturing business processes

4.       Annual Enhancement, DeLuxe support plans cost comparison.  If you are on Modules based model, then if you switch to Business Ready, you should calculate the cost of annual enhancement program, which you will have to pay each year to be enrolled into the program.  Typically switching to Business Ready license increases the annual support cost

Source by Andrew Karasev

Convert MS SQL to MySQL

MSSQL database translator converts database records of MS SQL into MySQL format

Saturday, August 22, 2009

MSSQL to MySQL database conversion tool to convert MSSQL database records to MySQL format with support to null value, data types, key constraints, schemas, attributes and tables including rows and columns.

MSSQL to MySQL database converter software helps to convert created MSSQL database records into MySQL database format. Database converter utility convert database records with all necessary attributes including unique and primary key constraints, null values, indexes etc. Microsoft SQL database converter application program facilitates conversion of either whole database or selected database table records. MSSQL to MySQL database conversion tool allows users to overwrite the records of existing database records or save the converted database records on the disk at user specified location. Database translator program provides support to all major Microsoft SQL data types and works with all major versions of MSSQL. MSSQL to MySQL DB records transfer program is fully compatible with Windows operating system such as Windows 98, ME, NT, 2000, 2003, XP and VISTA. Easy to use database conversion software provides user friendly GUI (graphical user interface) interface and does not require any technical skills to operate the software.

MSSQL to MySQL database translator utility helps to convert large MSSQL database records into MySQL database format. Microsoft SQL to MySQL db converter tool transfer entire database or selected table records as per user’s choice. MSSQL database converter program supports all data types including attributes, entities, null or default value, primary keys, unique key, foreign key and table structures during conversion. Database synchronization tool safely overwrites the contents of existing MySQL database records and offers to save the converted database records at user specified location. MSSQL database migration program supports Unicode architecture and maintains database integrity during conversion. MSSQL to MySQL DB translator tool supports all major versions of Microsoft SQL database such as 2000, 2005 etc. Microsoft SQL database conversion tool is compatible with different versions of Windows operating system such as Windows 98, 2000, 2003, XP, ME, NT, Vista etc. MSSQL to MySQL database converter software can be easily handled by both technical and non-technical users. MSSQL to MySQL database synchronization application provide interactive graphical user interface and user manual help guide for end user. Features: * MSSQL to MySQL database conversion program supports migration of MS SQL databases to MySQL server. * User can export MSSQL data into new database or overwrite the contents of an existing MySQL database. * Software supports all major version of MSSQL and MySQL database server. * MSSQL to MySQL DB converter supports Unicode architecture and maintains database integrity. * Database conversion tool provides highly interactive user friendly graphical user interface (GUI). * MSSQL to MySQL database transfer program contains user manuals for help and support of end users.

To know more about this product visit URL:

http://www.usbdriverecovery.org/usb-data-recovery/mssql-mysql-converter.asp

###

Source by USB data recovery

Mfeotlk.dll Description

Mfeotlk.dll is a totally rogue anti-spyware program that just like many other rogue programs, every time this fake software infects your computer, it will reports false threats and displays fake security alerts on your PC to convince you that your computer is infected with malware. Mfeotlk.dllis promoted and installed through the use of Trojans and often comes bundled with other malicious software and its purpose is only to try to convince you to purchase its commercial version for removal of infections which don’t exist. Once you find this fake program in your computer, you should remove Mfeotlk.dll and all associated threats as soon as possible!

You can detect and remove Mfeotlk.dll manually, or automatically. The approach you choose is based on your own comfort and computer skill level. However, for most common PC users, we do not recommend you do this manually.

The reason is that, if unfortunately this fake software is in your PC, it will start automatically every time you login to Windows, and then scan your machine and state that there are a lot of infections on it, but you should not remove them. For these infections this rogue program reports are all fake, and the files it reports are infected are actually legitimate Windows software. Therefore please do not manually delete any of the files it states are infections as it may cause your Windows operating system to not operate properly.

How to Get Rid of Mfeotlk.dll safely and easily?

A powerful and updated anti-virus program is very important and effective to remove Mfeotlk.dll and all associated threats! Free download Spyware Remover now to remove Mfeotlk.dll and all other rogue applications such as AntiSpyware Soft, Security Tool, Security Toolbar and Sysinternals Antivirus, etc now to protect your computer and make it run faster and virus free!

Source by Molly Smith

If you have Microsoft Windows 2000, the registry will experience some problems from time to time. However, you can do home computer repair to take care of these problems. If things go beyond your control, you can even involve a computer repair technician working with a remote computer support company and save considerable amount of time and money. The remote pc support technicians help you resolve all your computer related problems within few minutes. But, before we discuss the services of computer tech support company, let’s understand the functioning of Windows 2000 repair utility.

The main reason for registry problems with Windows 2000 is the small size of the registry, which is only 16 MB. Whenever this size exceeds 10 MB, you start getting startup problems.

Note that if your registry is corrupt, there is a risk of serious system errors and the computer may even become unbootable. The most widely used
[removed][removed]
 Windows 2000 repair utility is the Chkreg.exe command-line. Chkreg.exe is used for Windows 2000 Server, 2000 Advanced Server, 2000 Professional Edition, 2000, 2000 SP2, and 2000 SP3. You should not use the utility for SBS 2003 because conclusive tests have not been carried out. Chkreg.exe will help you determine the size of the registry and this will help you make informed decisions. You can get Chkreg.exe from Microsoft’s download center. 

Using Chkreg.exe command

Chkreg.exe command can be used with different options. chkreg /f filename [.log] will specify the name o the registry hive you intend to analyze. chkreg /f/H: will give you access to Chkreg.exe help. chkreg /f/D [ level ] will help you delete subkeys that fall on the level specified. The whole hive will be deleted if you do not specify the level. You should be very careful not to delete what you do not intend to delete. You will be prompted before deletion as a security measure. chkreg /f/S [ bin ] option is used to display usage of space on the bin you have specified. If you do not specify the bin, what will be displayed will be the space usage for your entire hive. chkreg /f/C option is used to compact the hive specified. Note that this utility will not compact a corrupt or bad hive. chkreg /f/L will detect all lost spaces. chkreg /f/R will repair the hive. chkreg /f/V will enable Verbose mode for more detailed information.

Microsoft Office 2000 is a major cause of registry problems in Windows 2000. To use the this registry repair utility if you had installed SR-1 update before May 12, 2000, you will first need to install the Office 2000 Service Release 1a (SR-1a) Update. This includes the Windows 2000 Registry Repair Utility and Office 2000 SR-1.

Note that some of your data may be lost during registry clean-up or fixing, but this depends on the type of the problem. You should be careful when dealing with registry because there is a risk of serious system problems. You should therefore do all you can to prevent the occurrence of registry problems in the first place. You can use registry maintenance tools for this. These are available online, but you should make sure it is OS-specific. These tools perform both preventive and proactive monitoring of your system. You should therefore create a backup, especially for data on the C partition, and you should create a system restore point.

“Copyright 2010 Fixit99.com, Mike Scherenberg. For more information or to view this original article, please visit http://www.fixit99.com

Source by Fixit99.com

Enterprise resource planning, or ERP software solutions and ERP vendors have been around for over forty years. The landscape of enterprise applications has steadily improved throughout the last 4 decades particularly in the mid 1990’s when the YTK, year 2000 scare was starting to take hold.

At this time ERP vendors gained the spotlight as companies started scrambling to ward off potential data and information meltdowns as the new millennium with its triple zeroes wreaked havoc on databases and records ill equipped to handle the numerical roll over. Times were extremely good for enterprise systems and the industry in general. ERP software sales, ERP consulting and implementation projects reached an all time high during this five year period.

Fortunately, the database sky did not fall when the new year rolled over to 2000 and businesses pretty much continued the dotcom bubble ride through the first quarter of the new millennium. The dotcom bubble burst in the second half of 2000 along with the YTK panic subsiding caused the ERP software industry, and most all tech industries for that matter, to take a breather. Over the next 5 years, ERP systems and ERP software lost its sizzle as technology hype began to focus on mobile applications and social network technologies.

However, since 1995, an ERP 2.0 has been emerging that can be compared with the introduction of Model T Fords to the automotive industry. The automobile revolution started not with the invention of the automobile which were a luxury item made available to only the mega wealthy but rather with the introduction of an automobile that could be enjoyed by the masses, the Model T Ford.

The same analogy can be applied to ERP software solutions and ERP modules. Historically, ERP vendors developed applications for the heavy hitting Fortune 100 manufacturing corporations with a price tag to match. The benefits achieved with ERP systems gave large organizations even more of a competitive advantage over smaller companies within the same industry as information and business processes were better streamlined to maximize resources and profitability. Very few companies could afford the million dollar plus price tag just to play, and this barrier to entry remained for decades.

However, in the last decade with web based application sparked by the internet hitting the market and with the power of open source applications and communities, smaller sized businesses are now able to take advantage of ERP software and ERP application benefits with SaaS, software as a service web-based solutions that are both affordable and powerful. In a nutshell, ERP application benefits are now available to the masses and that is starting a revolution of new product innovations that fit businesses with a very customized fit regardless of size, industry and business model.

The market is heating up for ERP vendors and for small and medium sized businesses looking for enterprise solutions to better compete in the marketplace. However, this surge of new enterprise software innovations ironically come with a price. Companies have so many choices when it comes to ERP vendors and software applications that it is not a simple task to filter all the ERP software solutions on the market to find the best fitting solution for individual companies. Companies are bombarded with not only ERP software applications but with vendors specializing in ERP modules, subset applications within full ERP systems such as CRM, customer relationship management and HRMIS, human resource management information systems ERP modules, to name just a few. However, although the ERP software selection process is a longer process now, the benefits of ERP software apps are tremendous, and it’s usually better to have too many ERP vendors and ERP apps to choose from rather than too few.

Source by Sudhani

What comes to your mind when you hear the term database? Instantly you relate it to an unending list of names, telephone numbers, addresses etc. But to people in managements, sales, marketing, and customer relationship building, a database is much more than a list of names and addresses. For them, it is a tool to increase sales and profit and also a means to create loyal customers.
A customer database as the name suggests is a database especially maintained for customers. It provides many opportunities for business growth and targeted marketing. First of all, such a database helps you in building a good rapport with your customers. By retrieving information such telephone numbers, e-mails, and date of births etc., you can wish your customers on their birthdays or on anniversaries. An unexpected wish goes a long way in building up a relationship. Better still, you can offer special gifts on buying or discounts on products on such occasions. This way you can create customers who are loyal to you while at the same time selling your products.

Again you can send promotional sales and offers from time to time to your customers through their e-mails or phone numbers. You can target specific customers with such offers. For example, you can choose a customer who has not had business with you in the past one year. Again, you can point out the customers who do not show interests in your products in spite of promotional campaigns. In future, you need not waste time and effort on such customers.

Again, a customer database enables you to target specific customers. You can find out who constitute your most profitable customers and their attributes such as geographical location, age, sex, etc. By deducing these facts, you can find out your targeted audience. Having done so, now you can effectively, inclusively, and precisely market your products to them. You also have a golden opportunity to build up a good customer relationship with this elite group of customers.
Therefore you should always maintain a user database if you want to increase your sales and business returns.

Source by Robin Richard

At one point or another, this happens to every computer user in the world: You install   Virtual DJ, find out that you don’t like it, or need it, or that its plain useless for the task you wanted to use it for and you want to uninstall Virtual DJ. So you open up the Windows Add/Remove tool, click the button to uninstall Virtual DJ… and find out that you cannot uninstall the program. In this article I will try to explain how to force uninstall Virtual DJ, that you cannot uninstall using the Windows Add/Remove tool. Before that, however, I will try to explain what happens during installation.

What you need to know to uninstall a program manually

There are several things that happen during the installation of a program.

First, of course, is the copying of files to the specified program folder (which is usually somewhere inside the Program Files folder). Also some files such as shared libraries (.dll files) can be copied into a folder inside Program Files called Common Files and some files such as drivers or shared libraries (again) are copied into the ‘WINDOWSSystem32′ and ‘WINDOWSSystem32drivers’ folders.

After that the installer makes some changes inside the windows registry. The windows registry is a unified place where all the settings for programs and for windows itself are stored. The installer can make changes inside the registry for several reasons. For example if a shared library needs to be registered. Or if certain types of files need to be associated with the program being installed, so that the user could open them (e.g. if you install Microsoft Word, then you will be able to open Microsoft Word documents). After this is done, a key is added to the windows registry in a place where the Windows Add/Remove tool looks for installed programs. During the installation all these operations are logged in a special file (e.g. setup.log), and the installation program usually puts that file inside the application’s folder along with the uninstaller. When a user tries to remove Virtual DJ through the Add/Remove tool, windows looks for the registered uninstaller inside the registry, and executes it. The uninstaller goes through the log file and undoes all the changes done during installation. That is, it deletes all the files that have been copied, all the registry keys the installer created etc.

However, if there is no log file, or if there is no record of the changes made to the registry the uninstaller might fail to uninstall Virtual DJ, and it will stay there untill it is removed by other means.

So if Virtual DJ won’t uninstall, how do you perform a force uninstall?

Well, if you know how to work with the windows registry, you probably can perform a manual force uninstall.

Before I go into detail about how to do this manually, I’d like to say that this is pretty advanced stuff, and if you’re not a power user, then perhaps you should consider using specialized software such as the Best Uninstall Tool which allows you to do this in just a few clicks.

If you are a power user, then let’s continue. First, let’s see how to remove the program from the list of installed programs. To do that you need to open the registry browser:

1.      Click Start and choose Run in the menu (If you’re using Windows Vista then press Win+R on your keyboard).

2.      Type regedit and hit Enter.

3.      On the left side is the registry settings tree, use it to go to HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindowsCurrentVersionUninstall

4.      Inside that key you’ll find a lot of keys that belong to different programs. Some are named after the program’s name, others as a mix of numbers and letters that makes no sense. Look through each of them until you find one that has the key DisplayName (on the right) with your program’s name in it.

5.      Notice the key UninstallString – this key points to the uninstall program, and the log file usually resides in the same folder as that program.

6.      If you delete the key in which you’ve found the DisplayName key with the value equal to your program’s name, then your program won’t appear on the Add/Remove programs list.

7.

Some programs create new entries in the registry to store their configuration options, these entries can usually be found in the HKEY_CURRENT_USERSoftware or in HKEY_LOCAL_MACHINESOFTWARE – look for the program name or the name of the company that made the software. Don’t delete Microsoft though – that contains Windows settings as well.

Next we have to find all the files that have been copied. Open the folder in which the uninstall program should be, and look for files which are named uninstal.log or setup.log or something similar. The list of files that have been installed is inside this file; you can open it in your notepad and find all of the files that have been copied onto your system. Delete the files and you’ll get rid of the program almost fully.

Again, I’d like to stress that if you’re new to the windows registry and all of this stuff, and if you don’t feel like experimenting with your computer, then, again, please consider using either the Best Uninstall Tool or similar software to force uninstall  Virtual DJ, I do not want to be responsible for breaking your computer.

Source by Sam Bridge

Computer softwares are the most important part of any computer system. Basically, these consist of programmes which enable the computer to execute specific tasks. The softwares are installed into the storage slots in computer systems which are RAM, hard disk and the memory. All the applications and programmes in a computer are run by the softwares. Most of these softwares are licensed rather than sold. The license is given for a certain period of time. Microsoft, Adobe, Norton and Linux are some of the leading software developers in the global markets.
The various programmes and data in a computer are generally called as the softwares. These can be classified into two types which are system software and programming software. The basic functions in a computer device are run by the system applications whereas programming applications provide tools to write different computer programmes. Both of these are equally important for smooth functioning of a computer system. One can also create one’s own applications such as spreadsheet templates, words and word processor macros.
There are a wide variety of softwares available to the users worldwide. The licensed computer software is the computer programme which is authenticated by the manufacturer. A number of such applications are being developed by the companies so that the computers could be used for many purposes. The licensing system is based on different concepts such as the number of computers on which the licensing programme can run and the number of users that would be running the programme.
Using unlicensed computer programmes is an offence and may lead to cyber crime. In fact, the legal computer applications allow the users to run the programmes on only one computer. However, copies of the software can be made for backup purposes. In some of the cases, one can run the applications on more than one computer system. This all depends on the type of agreement that comes with the software.
The licensed computer software is basically a protection against the unauthorized copying by the users. Several laws have been made in order to protect the intellectual property rights of the developer. If software is copied without permission of the owner, it is considered as “copyright infringement”. The offender can be imposed penalties and other punishments as per the laws. There a number of situations in which this offence can take place. These situations are as the following.
* When one loads the software into one’s computer by running the application from CD-ROM, hard drive or an optical storage media.
* The software is copied on to other storage devices such as pen drive, floppy disk or the hard drive of the computer.
* The application is run directly from the network place where it is stored.
* If the software is copied for a sale or hire, it is considered as a crime.
* The offence takes place if any supporting documents of software such as programme manuals, data, and codes are distributed to others without having permission from the owner.
Computer software is a big business and thousands of companies have invested their money in this industry. It requires a large sum of money, continuous efforts and sharp human brain to develop the softwares. Therefore it becomes necessary to protect this intellectual capital from hackers and piracy threats. The federal copyright law has been made in this direction which says that users can not copy softwares for any reason except for back-up purpose without the explicit permission of the copyright holder. Several other laws have been made for this purpose which protects the intellectual property rights of the software developers.
There are a number of places from where the valid computer programmes can be availed. Internet is perhaps the best source of getting these. Various online marketplaces offer the legally authorized softwares and applications. One can also download any particular programme directly from the developer’s website. Therefore, using licensed computer software is the best and ethical way to run the computer programmes. It minimizes the revenue loss of the concerned companies and also gives a lot of satisfaction to the users.

Source by Jayson Pablo

If you have SAP B1 ERP implemented in your organization, you are probably already familiar with internal reports, queries, XL Reporter and in this small publication we would like to give highlights on Crystal Reports.  Each reporting tool has its own pluses and drawbacks, and you should try multiple tools, if your reporting needs are broad: from Financial reporting (Trial Balance, Balance Sheet, Profit and Loss, Cash Flow Statement) to Operation reporting (Sales by Regions and Items, Sales Commission Report, Project Profitability to name a few examples), plus if you need industry forms, such as Bill of Ladings, Agent Settlement Report:

1.        XL Reporter.  This reporting tool is very end user friendly and if you are accountant, who is neither comfortable nor familiar with SQL scripting, this report should fit your needs.  This report is deploys Microsoft Excel tools and it has VBA extension to MS Excel.  However this reports design tool  works with predefined SB1 objects: Business Partner, Account, Item, Price List and similar, and you are limited in building custom links.  And this is understandable – if you need advanced links in your report, you will need SQL view or Stored procedure as the report base – you can achieve this goal in Crystal Report

2.       Crystal Reports.  If you are discovering Crystal Reports design through report building wizard, then you should listen SAP BO training class either online or face-to-face.  However if you are report developer and work in IT department, then you should go to SQL view or stored procedure scripting.  Stored procedure is the most powerful tool and its parameters should be translated to Crystal Report parameter.  Stored Procedure allows you to build temporary tables within its boundaries – this should resolve complex unionizing and build staging tables if required.  Stored procedure should be able to build very complex report – try to design something like Sales project profitability, based on incurred cost in Purchase Order Processing, Production (working hours and possible overhead)

3.       SQL Server Reporting Services or SRS.  This tool is web based, which should give you certain advantages if your organization has regional offices and international presence.  SRS in its suitability is pretty similar to Crystal Reports and it bases its reports on SQL Views or SQL Stored Procedures

4.       Industry Forms.  If you are thinking which reporting tool to deploy and how, the hint is simple – these reports should depict only one document: Sales Invoice, Purchase Order, Vendor Invoice in the format, required by your industry regulation.  You can use Crystal Report (which could be integrated in your SAP B1 interface) as well as SRS (if you want to enable these reporting over the web)

Source by Andrew Karasev