Find Sporting Goods on eBay
Video and Audio], Broadcasting and podcasting Real Time Media On The Net

[description], Story, any other text you want to use.

Microsoft Great Plains Dynamics on Pervasive SQL.2000 data repair – overview for Database Administrator

 by: Andrew Karasev

Up to the version 7.5 Microsoft Great Plains, and if you are looking to version 7.0, 6.0, 5.5, 5.0 or 4.0 - then it was Great Plains Dynamics were available on Pervasive SQL.2000 or Btrieve. I am confident that majority of database administrators know how to do data repair via Transact SQL query if you are on Microsoft SQL Server 2000/7.0, but I would like to help these ones, who have to support Microsoft Great Plains on Pervasive SQL.2000 or Ctree. Some introduction into Great Plains Software products, now Microsoft Business Solutions. Microsoft Great Plains becomes more and more popular, partly because of Microsoft muscles behind it. Now it is targeted to the whole spectrum of horizontal and vertical market clientele. Small companies use Small Business Manager (which is based on the same technology – Great Plains Dexterity dictionary DYNAMICS.DIC and runtime DYNAMICS.EXE), Great Plains Standard on MSDE is for small to midsize clients, and then Great Plains serves the rest of the market up to big corporations.

If you are database administrator who is supporting the version on Pervasive SQL.2000/Ctree – read this and you will have the clues on where to look further.

1. Microsoft Great Plains Tables Structure – Launch Great Plains and go to Tools->Resource Description->Tables. Find the table in the proper series. If you are looking for the customers – it should be RM00101 – customer master file, account master file - GL00101, Sales Header Work file - SOP10200 - and you got the idea.

2. Use Microsoft Access. Lunch Microsoft Access and make a link to Microsoft Great Plains tables. This will allow you to do data modification/repair. Some people are trying to use Pervasive control center - we do not recommend this - MS Access does job better.

3. Locked batch repair – unlocking the batch, which was interrupted in posting. The tables: SYoo500 - batch header - you need to change Batch Status or Marked for Posting field

4. Activity table - If you have user locked in Great Plains - just ask all the other users exit and delete ACTIVITY.BTR (Pervasive) or ACTIVITY.DAT (Ctree)

5. Crystal Report link to Pervasive/Ctree - you have to install Pervasive SQL ODBC driver from Great Plains Dynamics CD. This will allow you to deploy ODBC connection to Great Plains database

6. Sometimes you have to rescue to Great Plains Dexterity - when you need ongoing data import and you do not own Great Plains Integration manager or when Integration Manager doesn't have the object to deploy. This is proprietary Great Plains Software tool and development environment and you need some time invested, before you can do programming.

7. Complex Data Migration - use MS SQL Linked Server - you can create linked server to Pervasive/ctree and then you can create the cursor, coming through all the tables in your migration set - we usually recommend reading tables schema in MS SQL Server (it is the same to Pervasive) and pull the data from Pervasive database using EXEC statement in Transact SQL.

Happy data repairing! if you want us to do the job - give us a call 1-866-528-0577! help@albaspectrum.com

About The Author

Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies – USA nationwide Great Plains, Microsoft CRM customization company, based in Chicago, San Francisco, Los Angeles, San Diego, New York, Boston, Atlanta, Houston, Austin, Dallas, Miami, Atlanta, Denver, Phoenix, Minneapolis, Canada, UK, Australia, Europe, Moscow and having locations in multiple US states (www.albaspectrum.com), he is Dexterity, SQL, C#.Net, MS Access, Crystal Reports and Microsoft CRM SDK developer.


akarasev@albaspectrum.com


satellite television services

Real Time Media On The Net
This is one of the best resources for information on Real Time Media On The Net you can possibly find. Follow our links to find more information on Real Time Media On The Net. We hope that we have all of the Real Time Media On The Net details that you could need.
Real Time Media On The Net

Netscape Corporation has created the best known secure server technologies. It uses a security protocol called Secure Sockets Layer (SSL) that provides data encryption, server authentication, message integrity and optional client authentication for a TCP/IP connection. When a client seeking to purchase satellite television services connects with a secure server, they exchange a *handshake* which initiates a secure session. With this protocol, the same server system can run both secure and unsecured web servers simultaneously. This means an satellite television services organization or company can provide some information to all users using no security, and other information that is secured. For example, a business that sells satellite television services online can have its storefront (merchandise catalog) unsecured, but ordering and payment forms can be secure.

Why are these developments important? As the Internet becomes a way to buy and sell satellite television services products and services, financial transactions become essential. Right now, most satellite television services transactions involve the exchange of credit card information, either directly over the network, or by phone, to complete a transaction initiated online. Eventually, you will be able to use cash as well as credit, directly over the network.

There are two basic kinds of digital cash, anonymous cash and identified cash. Anonymous cash is just like paying for satellite television services with paper cash but it also carries no information about the person making the transaction, and leaves no transaction trail. You create it by using numbered bank accounts and blind signatures. Identified cash, on the other hand, contains information revealing the identity of the person who withdrew it from the bank. Like credit card transactions, identified cash can be tracked as it moves through the system and involves fully identified accounts and non-blind signatures. Whether you use digital cash when purchasing satellite television services is entirely up to you. We suggest you employ the purchasing avenues available from the satellite television services supplier we recommend.

Main Menu
Real Time Media On The Net
Site Map

Affiliate Ads, Links, news, etc.

News for 21-Aug-25

Source: BBC News - Home
Preserving Mali's rural life

Source: BBC News - Home
Libyan hijacker arrested in Malta

Source: BBC News - Home
David Moyes: Manchester United's great traditions have gone says Sunderland boss

Source: BBC News - Home
Chile anger as jailed Pinochet reign abusers ask forgiveness

Source: BBC News - Home
Your pictures

Source: BBC News - Home
Man 'in love' drives through airport

Source: BBC News - Home
Adrenaline and exhaustion

Source: BBC News - Home
Drip dry

Source: BBC News - Home
Is Nigeria's 'plastic rice' actually real?

Source: BBC News - Home
Sri Lankan court acquits five men in Tamil MP murder trial


Links
Links
Links
Google

Fantasy Football Information | Kids Meet | Present On The Net | Take Medicine Correctly
Copyright © 2005. Name of Site here. Last Updated: Thursday, 21-Aug-2025 00:00:51 MDT.
Take It Right   Talk On The Net   Fantasy Football Strategies