 WebProWorld
Dev Forum |
Macromedia Question, HELP!!
I'm trying to make a "register page" with dreamweaver (in .php) where the username, password, mail, access level, etc. are in a ms database; when i try to create a server behavior, more specifically ; my problem is that when im choosing the database table, connection, etc, nothing appears in the pop-up menu...
mysql question
Table person is described by a PersonID,LastName and FirstName. Table song include songid,songtitle,artistname and recordconame. Table likes show which person likes which song.
Is new database needed for each script?
It seemed logical to me that each of these should have its own database. However, I am wondering if this is actually correct. Could both scripts use the same database? Since each has a prefix for its tables, could they share the db?
|
|
|
|
Recent Articles |
MCSE 70-290 Certification Primer
Microsoft Certifications are one of the most widely acclaimed, pursued, and achieved technical certifications in the IT industry. The demand for Microsoft Certified Professionals in the job market is increasing every year.
CompTIA Linux + Beta Exam
For the next eight weeks, anyone interested in demonstrating that he or she has the equivalent of six to 12 months of experience with the latest Linux applications can do so for $75 by passing the CompTIA Linux+ beta exam.
10 Things you Should Know about IT Training
In the bid to acquire skills and knowledge in today's information age, many are turning to IT Training.
Stellant Achieves EnterpriseOne 8.9 and 8.10 Certification by PeopleSoft
Certifications provide comprehensive imaging and business process management support for accounts payable and receivable, travel and expense reporting, and human resources applications.
Cisco CCNA Certification: Five Things To Do ON Exam Day
There are plenty of articles out there about how to prepare for the CCNA exam. However, there are also things you can do to increase your chances of success on exam day during the most important part of the entire process -- the time that you're actually taking the test.
New Horizons Signs Agreement with Planet 3 Wireless for Wireless Network Training
New Horizons Computer Learning Centers the world's largest independent IT training provider, has signed an agreement with Planet 3 Wireless to deliver courses mapping to Planet 3 Wireless' Certified Wireless Network Administrator (CWNA) certification.
Cisco Certification: How To Become A Truly Valuable CCNA
I've been active in the Cisco Certification track for four years, working my way from the CCNA to the coveted Cisco Certified Internetwork Expert title, and during that time I've conducted job interviews and casual conversations with hundreds of CCNAs and CCNA candidates.
Project+ - Combining the Technical World and the Business World
An Interview with Ayana Nickerson, Project+ Certification Program Manager for CompTIA (the Computing Technology Industry Association). |
|
|
|
11.10.04
Great Plains Installation For IT Director/Controller
 By Andrew Karasev
Microsoft Great Plains is main mid-market application from Microsoft Business Solutions.
This is short article, written in question/answer/FAQ style to give IT Director/Controller balanced top level information on Microsoft Business Solutions Great Plains implementation. If you have decided on Microsoft Great Plains as main accounting and ERP system you need to know some technical details on Great Plains installation and implementation and what is going on behind the scenes. As of right now the current version is Microsoft Great Plains 8.0
What is installation in the language of technology? Installation has server and client sides.
• Server side - Installation creates security environment (logins) on MS SQL Server or MSDE, creates system database - DYNAMICS and then company databases. All these tasks are performed by Microsoft Great Plains Utilities
• Workstation side - workstation installation copies the client side application, installs current version of MDAC (we need SQL ODBC driver - please check documentation on ODBC DSN setup), registers the application. If you plan to run Great Plains Utilities from the workstation to create server side (see above) - you need to check Install Client and Server Components
 What is following implementation? Implementation requires combination of technological and accounting skills
• System Setup - you should refer to GP documentation. In general setup consists of Company information, General GL/AR/AP/Payroll setup, User classes, Customer/Vendor/Employee classes to name a few
• Master Records - you should either use integration tools, such as Integration Manager, SQL queries or have users to type in all your GL Accounts, Customers, Vendors, Employees .
• Beginning Balances - this is recommended approach - you place aside the old accounting application for querying the historical data and enter beginning balances in Great Plains GL, AR, AP, SOP, POP, Payroll. When you have balances in the system you are ready to use it in production
• Historical Data conversion - this is optional, in order to do historical data conversion you need to know basic Great Plains tables structure (Setup->Tools->Resource Description->Tables Structure). This is similar to surgery - so you probably need outside consultant to help you. If the volume of historical data is small - you can deploy Great Plains Integration Manager and then post the records in the modules.
| Pay Pennies For New Clients - Expose your site to over 1/2 BILLION searches per month. >> more info |
|
• User Training - we are just listing this item - it is up to you to decide on the way to train your users
• Using Two Systems in Parallel - this is recommended. You should print the reports from both systems during this test period and compare the results
• Customization - typical areas of customizations: Invoice form, Crystal Reports, pulling info from multiple databases, including Great Plains database, Great Plains forms modification with Modifier/VBA, Great Plains Dexterity forms and logic customization, integration with CRM, RMS and other business systems, web publishing from Great Plains tables, EDI with your suppliers, SQL Data Transformation packages
 Do I need consultant? We strongly recommend you to use consultant in the following cases
• You have identified the need for Great Plains Dexterity customization
• You are doing migration from Pervasive/Ctree to Microsoft SQL Server/MSDE, especially when you have third-parties without migration tools
• You are doing migration from Great Plains Accounting to Microsoft Great Plains
• You have to create a lot or ReportWriter Modified Great Plains Reports
• You have old version of Great Plains: Dynamics or eEnterprise 6.0 or prior - in this case you can not appeal to Microsoft Technical Support - it is discontinued
• Your Great Plains has more than 20 users in this case the mistake may lead to serious business problems
• You don't have support for your old Great Plains - then you have to select your Microsoft Business Solutions Partner and pay for the annual support/enhancement plan - you will get new registration key and will be ready for the upgrade
About the Author:
Andrew Karasev is Chief Technology Officer in Alba Spectrum Technologies – USA nationwide Microsoft CRM, Microsoft Great Plains customization company, based in Chicago, California, Texas, New York, Georgia and Florida and having locations in multiple states and internationally (www.albaspectrum.com), he is Dexterity, SQL, C#.Net, Crystal Reports and Microsoft CRM SDK developer. |
