Dynamics Gp On Pervasive Sql Server And Ddf Generator

Home | Computers-and-Technology | Software

The technique of ODBC connection to old versions of Great Plains Dynamics based in Pervasive SQL Server 2000 or Btrieve is reasonably straightforward. Modern day programmers are typically comfortable to deal with ODBC or native driver connection to Microsoft SQL Server and the number of consultants who are ready to connect you to B-Trieve database is limited. Lets review the technology and the steps:

1.Great Plains versions on Btrieve/Pervasive SQL 2000. Back in earlier 1990th Great Plains Dynamics was introduced as one of the pioneering graphical accounting applications. Those days competition on the graphical computers had such names as Apple Macintosh and Microsoft Windows. Apple PowerPC server had Faircom Ctree database platform while Microsoft Windows server had either Ctree or B-trieve. In our experience with Faircom DB on Mac server is not very encouraging as we saw poor performance. In executive demonstrations we ended up with scenario where Dynamics clients are installed on Mac computers and the server is Windows with Btrieve database platform. In late 1990th and earlier 2000th Great Plains Dynamics was available on three DB platforms: Btrieve/Pervasive, Microsoft SQL Server and Ctree. And the versions were 7.5, 7.0, 6.0, 5.5, 5.0 and 4.0. Apparently when Microsoft acquired GP Software the direction was chosen to abandon non-SQL Server platforms

2.How do you do data repair with GP release on Pervasive SQL? It is easy enough to delete or update rows in SQL Server Query Analyzer or Management Studio. In the case of Btrieve our tool of choice is Microsoft Access with linked ODBC tables. ODBC connection required so-called DDF files generation. The best way is to look at DDF manual which is installed automatically and placed in Documentation folder. If you like shortcuts, then here they are. In your Dynamics workstation folder drag GenDDF.set file and drop it n Dynamics.exe. Please note that you can create these files for all Dexterity compliant products listed in your Dynamics.set file including such popular as Intellisol Project Accounting and Advanced Purchase Order Processing, Mekorma and others

3.Where DDF files should be placed? They should go to company folder on your server

4.Microsoft Access ODBC connection. The trick here is to find Linked Tables option and then ODBC. Here you are selecting company folder on the server and we recommend you to select all tables and add. Some of the files do not exist (as they are only created when you have at least one record to save) so ignore multiple error messages. At this point you should be positioned to edit Btrieve tables in MS Access interface

5.Popular data fixing scenarios. One of the most popular is unlocking the batch crashed in posting process. The table is SY00500 and you need to change batch status from positive number to zero. There are cases when you have to change customer information in large number of SOP Invoices and here the table is SOP30200

6.For additional information, please feel free to call us 1-866-528-0577 or 1-630-961-5918 (this number works for international customers) or email us help@albaspectrum.com We serve you USA/Canada nationwide via remote support (web sessions and phone/Skype conferences). Local service is available in Western Michigan, Chicagoland, Southern California (LA, Orange County and San Diego), Houston area of the state of Texas

About the Author:
Andrew Karasev, http://www.albaspectrum.com Great Plains Dynamics GP and eEnterprise Certified Master, Microsoft MVP and consultant with 15 years and plus experience and expertise. Alba Spectrum, 1-866-528-0577, help@albaspectrum.com. If you are thinking implement Dynamics GP in challenging environment, we recommend you to give us a call

Article Originally Published On: http://www.articlesnatch.com

Tags: Dynamics GP

, Pervasive SQL 2000

Related....

Videos...

Recent Software Articles

Iskysoft Updates -1080p Output Video For New Ipad(ipad 3), Apple Tv 3 By: Lorin Young | May 31st 2012 - iSkysoft today released two new updates for its iMedia Converter for Mac and iMedia Converter Deluxe for Mac

DVD to iPad 3 Converter for Mac

Convert DVD to iPad 3 mac

How To View, Edit, And Fill Word, Excel Document In Asp.net Application Or Java Web Application By: Nancy Stewart | May 31st 2012 - As we know, it's impossible to view, edit Microsoft Office documents directly on Web pages for many years. But Aceoffix can do that for you. Without installing Office at the server side, web developers can easily embed and call Office in web pages.

Create Your Video Sharing Service Like Youtube Using Joomla Youtheme By: Nancycatherine | May 31st 2012 - With the success of YouTube, similar online video sharing website has popped up like mushrooms, taking the media world by storm.

Boost Your Web Traffic & Revenue With Wordpress Review Plugin By: Henry William | May 31st 2012 - One of the best ways of making money online is by reviewing products and services. Most often, before a consumer decides to pay for a good or a service, they will always search for expert or consumer review in order to learn how the product works, and what they shou ...

Review Writer

Review Software

WordPress Commenting Tool

Ruby On Rails Platform Setup By: Annie | May 31st 2012 - To program most Ruby programs, Ruby on Rails programmer / developer needs virtually only two things: a basic text editor and a Ruby interpreter (usually MRI). Developing Rails applications might involve quite a few more tools. The following is a list of things a pro ...

Ruby on rails developers

Ruby on rails programmers

Best Practices For Custom Application Development By: christa joe | May 31st 2012 - Custom applications help businesses to deploy software technology in their operational processes, according to their needs and requirements. This helps to optimize and manage the functional and operational expertise.

Custom Application development

software development

Mobile Application Development India & Its Extensions. By: Victor Parker | May 31st 2012 - Mobilization flexibility has reached the seventh sky in terms of latest technology. The various mobile applications have been invented for better compatibility and easily used by the users. IT sector has emphasized on Mobile application development which has enhance ...

Mobile application development India

Open Source Technology Services India & Its Benefits To E-business. By: Victor Parker | May 31st 2012 - In simple words open source refers technologies which are independent to users. It has given the vast platform to the IT solutions. This product is highly recommended in the market and it is more powerful than other commercially products available. It has changed th ...

Open source technology company India

Perfect Online Data Visualization With Html5 (javascript) Gauges? By: Tatyana Ufimskaya | May 31st 2012 - Online data visualization is very popular nowadays since it offers such advantages as getting data in real time and access from any location and device. More and more companies move their information monitoring and dashboard apps to web. And here they face some prob ...

html5 gauges

javascript gauges

Take Care Of Your Lifeline"��! By: eScan Antivirus | May 31st 2012 - When we say the advancement of technology has influenced humanity in the various aspects of life that governs almost all acts of man out of some of the few important inventions, I find Credit Cards as the prominent.

Anti-Phishing Working Group

Anti-Virus

Cyber Crime

Cyber Terrorism

Comments

Still can't find what you are looking for? Search for it!

Site Navigation: