The four elements of a nifty marketing article

You may think that the key to article marketing success is writing a good article. While this is true, there is much more to it than this. You will also need to consider your headline, your article description and your resource box. In many ways, these can be more important than the article itself. The Headline By far the most important part of your article is the headline. It is the first thing your reader or potential publisher will see. If you can grab their attention and get them to read your article you are on the road to success. Your headlines should only be between five and ten words, but these few words can be the difference between success and failure. Write a few headlines, not just one. Also, once you have written a few headlines put them aside and come back to them later. You will then be able to better judge which is the best one. There are a few tricks you can use to grab the reader's attention. One is to play to people's desires and offer a solution. Examples of this could be: How to get rich in one month How to retire before your 50 Headlines that offer to show a reader how to achieve something in easy steps also lead to a good click through rate. So, these could be something like: 10 top tips for getting rich quick 5 easy steps to early retirement As you submit more and more articles, you will get a better idea of what is working for you both in terms of headlines and content. The Description Almost as important as the headline is the description. The description of your article will appear under your headline in the article directories. There is a temptation here to take your first paragraph and cut it into the description box when submitting to directories. This is a grave mistake. While it is not as powerful as a headline, the description gives you another opportunity to sell your article so word it carefully. Describe what the article sets out to do, how it does it and hint at the great solution it is going to provide. A powerful introductory paragraph in the article may achieve all of this, but it is not always possible so generally you should write your description separately. The Article If you have grabbed the reader's attention with your headline and they are reading your article you are almost there. However, your work isn't done yet. The article has to be good, if not excellent. At least good enough to hold the reader's attention for its entirety. In general, your article should either entertain or inform. Writing entertaining or funny articles is a skill most professional writers struggle at and is very hard to achieve, so you should aim to inform. Either tell the reader about something they want to know about, or tell them how to do something. Also, write about something you know about. "How to" articles are particularly popular. If you can show a reader how to complete a task in 500 or so words you are on to a winner. When you are writing the article, keep it simple. There can be a temptation to use flowery language but this is a definite no-no. Keep your sentences short, your words simple, and avoid complex grammatical structures. One trick is to read the article aloud to yourself when you have finished. It it sounds good to the ear and flows smoothly it should also read well. The Resource Box Ah, the resource box. The forgotten child of article marketing. If you get someone to read your article it is a fair achievement. So do not scupper your efforts by writing a poor resource box, as so many people do. The whole point of the exercise is to get people to click through to your website, so your resource box content is key. If you wrote a good article related to your website or product your reader will already be interested so you have a lot of the work done. The text in the resource box should include your name but for the most part should be about the reader, not about you. You need to tell them why they want to buy your product and how it can help them. Remember, you are offering the solution to their problem. Also, be sure you can deliver on your promises. Do not offer something you can not provide. Finally, it can be a good idea to include a plain address for your website as well as a live link. So, when you are next preparing a marketing article be sure to give each of the four steps the attention they deserve.



Online The four elements of a nifty marketing article

Email grammar quiz

How good is your grammar? When writing email messages, proper grammar is important. By being aware of common mistakes, you can avoid them. In other words, you don’t need to know all the rules. (What a relief!) But, . . . (You knew that was coming, didn’t you?) you need to know what you don’t know. If you are unsure if something is correct, look it up. Or, ask someone knowledgeable for assistance. If you don’t have the time to seek help, here’s a quick tip. Use different wording.

To put it another way: If you can’t determine how to make the sentence correct, re-word the sentence so it doesn’t contain the item you’re having trouble with. Please don’t tell your high school English teacher that I made this suggestion! Yes, it would be great if the entire country knew proper English. However, the reality is many people don’t. The goal of this article is to convince you to select the grammar that you know is correct. Quiz Are your grammar skills good enough? Find out by taking the following quiz. Directions: Indicate whether the specified phrase is Correct (C) or Incorrect (I). C I 1. John is (laying) on the couch in the office. C I 2. Peter (laid) the file on the desk. C I 3. He (sat) in front of the computer. C I 4. (Set) the files on my desk when you are done. C I 5. The customers want (their) price quote now. C I 6. The customer wants (their) phone call returned. C I 7. Wilma had (less) callers on her line. C I 8. Fred has (fewer) employees. Solutions 1. Incorrect. The correct answer is lying. To lie means to recline. The verb is intransitive; it does not require an object. The past tense is “lay.” 2. Correct. To lay means to put or place. The verb is transitive; it requires an object. The past tense is “laid.” 3. Correct. To sit means to be seated. The verb is intransitive. The past tense is “sat.” 4. Correct. To set means to put or place. The verb is transitive. The past tense is “set.” (Yes, it is the same as the present tense. This is, after all, English grammar. It is not supposed to make sense.) 5. Correct. The antecedent is plural which requires a plural pronoun. In other words, the plural form of “customers” requires using a plural pronoun “their.” 6. Incorrect. The antecedent is singular which requires a singular pronoun. In other words, the singular form of “customer” requires using a singular pronoun “his or her.” This can also be written “his/her.” 7. Incorrect. The correct word is “fewer.” Fewer is used when you can count the quantity (e. g., “fewer students,” or “fewer hours in the workday,” or “fewer corn kernels”). Less is used with an indeterminate quantity (e. g., “less interest,” or “less time,” or “less corn”). 8. Correct. Fred can count the number of his employees, so “fewer” is correct. Score: 8 = You’re perfect. (But, you knew that already.) Keep emailing! 6 - 7 = You’re okay. You could learn a few tips from my book, Email Etiquette Made Easy (see link in resource box). 3 - 5 = You could use some help. Try my book, Email Etiquette Made Easy (see link in resource box). Less than 3 = Ugh! Call me now! We’ll schedule your intense therapy immediately.



Online Email grammar quiz

What do i need to consider before selling my business

The process of selling a business is not as straight-forward as you may imagine, especially if you are looking to get the best possible price. Your business may have been set up in a formal and structured way; this will be far more attractive to any potential purchaser more than one which is run in a more 'personal’ way. The best time to implement these structures and procedures in place is when the business is first set up - of course, you can always modify them as the business develops and grows but spending time on this area at the start will pay huge dividends in the future. One of the main problems with internet businesses is that they are generally so 'personal'. This means the site owner has developed a business based around his/her own experiences and knowledge, throughout the site there will be personal traits. In the past I have been guilty myself of developing my own sites from my own experiences and this is reflected heavily in the website content. Having a personal website may be good for you financially; however it could be problematic when you try to sell the business. The manner in which your site has be personally developed may lead you to carry out a major revamp of the site and at worst might actually affect the sales of the business. I would advise anyone to set up an online business in a 'corporate' manner - this would mean that the websites gave the impression of having a company and losses the personal touch. However, if I had done this at the start, would any of my websites be as lucrative as they have been? My feeling is perhaps not - I know that many people have purchased from me in the past because they can relate to the situations that I found myself in as they are going through a similar situation also. Had my sites been a representation of a faceless corporation, then maybe my customers would never have become customers in the beginning. I am unsure what is the better approach - personal or corporate - there are advantages and disadvantages to both. If you are looking to keep the business short term my advice would be: 1. Maintain proper financial records – No one is going to buy a business without scrutinising your accounts. 2. Open a business bank account – An accountant should advise you of his, as business revenue has to be separated from non business finances. 3. Make sure your tax returns are submitted on time. 4. Have a knowledge of SEO (Search Engine Optimization) and always try ahead of the competition. 5. Speak to a broker and get their advice on how to maximise your potential to sell the business in the future. Don’t get too attached to your business, otherwise letting go could be difficult. http:// bizseller4u. com



Online What do i need to consider before selling my business

Fha loans lower fees and raise acceptance

FHA mortgage insurance programs assist low and moderate income families become homeowners by lowering some of the costs of their mortgage loans. FHA loans encourage mortgage companies to make loans to otherwise creditworthy borrowers and projects that might not be able to meet conventional underwriting requirements by protecting the mortgage company against loan default on mortgages for properties that meet certain minimum requirements. Today’s FHA program is the adaptation of the very same program which has helped save homeowners from default since the 1930s. Today, One to Four Family Mortgage Insurance is still an important tool allowed by the federal government to expand home ownership opportunities for first time homebuyers and other borrowers who would not otherwise qualify for conventional loans on affordable terms. Several amendments have been made to the FHS in the nearly eighty years it has been a part of United States federal policy.

Most notable to these changes is evident in the 203(b) clause added in the 1980s which allows numerous advantages to the first time and disadvantaged home buyer. In contrast to conventional mortgage products, which frequently require down payments of 10% or more of the purchase price of the home, single family mortgages insured by FHA under Section 203(b) make it possible to reduce down payments to as little as 3% . This is because FHA insurance allows borrowers to finance approximately 97 percent of the value of their home purchase through their mortgage, in some cases. With most conventional loans, the borrower must pay, at the time of purchase, closing costs (the many fees and charges associated with buying a home) equivalent to 2-3 percent of the price of the home. This program allows the borrower to finance many of these charges, thus reducing the up front cost of buying a home. FHA mortgage insurance is not free: borrowers pay an up front insurance premium (which may be financed) at the time of purchase, as well as monthly premiums that are not financed, but instead are added to the regular mortgage payment. Finally, FHA rules impose limits on some of the fees that mortgage companies may charge in making a loan. For example, the loan origination fee charged by the mortgage company for the administrative cost of processing the loan may not exceed one percent of the amount of the mortgage. Along with a renovation of the FHA regulations during the 1980s to accommodate for an ever-evolving real estate market, the federal government adapted what’s known as a ‘streamline’ refinancing program.

This refers only to the amount of documentation and underwriting that needs to be performed by the mortgage company, and does not mean that there are no costs involved in the transaction. There are a few basic requirements to qualify for the streamline option. The mortgage must already be insured by FHA, the mortgage to be renewed must be current and paid on time to date, the refinance is to result in a lowering of the borrower’s monthly principal and interest payments, and no cash may be taken out on mortgages refinanced using the streamline refinance process. Companies may offer streamline refinances in several ways. Some offer “no cost” refinances (actually, no out of pocket expenses to the borrower) by charging a higher rate of interest on the new loan than if the borrower financed or paid the closing costs in cash. From this premium, the company pays any closing costs that are incurred on the transaction. Also, companies may offer streamline refinances and include the closing costs into the new mortgage amount.

This can only be done if there is sufficient equity in the property, as determined by an appraisal. Streamline refinances can also be done without appraisals, but the new loan amount cannot exceed what is currently owed, i. e., closing costs may not be added to the new mortgage with those costs either paid in cash or through the premium rate as described above. Investment properties (properties in which the borrower does not reside in as his or her principal residence) may only be refinanced without an appraisal and, thus, closing costs may not be included in the new mortgage amount. Once you do, or if you have ever fully paid off a home backed by FHA, you may be owed back compensation from the government. About 1 in 10 FHA borrowers leave money in their escrow accounts when they pay off their loans. The average refund for each borrower is about $700. In addition to the more standard mortgages available in this program, the federal government has also allowed for more creative forms of home owners who could qualify, at least in part, from FHA funding. For example, FHA’s energy efficient mortgage program provides mortgage insurance for a person to purchase or refinance a principal residence and incorporate the cost of energy efficient improvements into the mortgage. The mortgage loan is funded by a lending institution, such as a mortgage company, bank, savings and loan association and the mortgage is insured by HUD. One of the most enjoyed benefits of the FHA, though, is that the down payment for an FHA mortgage can be 100% gift funds. Verification of the source of gift money is not required to benefit from this particular aspect of the legislation. However, it is necessary that the gift funds be deposited in the borrower's bank or savings account, or in an escrow account, prior to underwriting approval. Gift donors are restricted primarily to a relative of the borrower. They can also be certain organizations, such as a labor union or charitable organization. Contact your local branch for complete information. Additionally, proof of initial deposit is required. The Federal Housing Administration is one of the most successful government programs in American history and over the decades during which the program has been in existence, thousands upon thousands of home owners have been able to procure the home of their dreams when it may not have been possible otherwise.



Online Fha loans lower fees and raise acceptance

Financial freedom is everyone s dream

If you want to be financially free then you should know how to create unlimited income, control your income and become the master of your money. Beside, create multiple source of income, just like building multiple pipelines. But what obstacle came between you on your way to create wealth? Have you ever heard people say: 'I will never be rich…' 'Money is not important. It’s not everything…. ' 'I am not the kind of people that can be wealthy.... ' 'Only the rich can become richer. The poor people like us will become poorer… ' Yes, that's correct, because you have put yourself in the circle of the poor. May I ask: 'Before the rich became rich, were they rich or were they not?' If You Want To Be Rich, Change Your Mindset TODAY! Rich and poor is just a line apart. Everyone listen. Everyone see. Everyone lives in the same world. Opportunity lies in front. Why is there difference in wealth? Because in whatever the rich does they are one step ahead of others. Why does the poor become poorer? Because they do not have a strong desire to be rich and lack of action. The Four Natural Rules of Success: A Right Mindset Moving one step ahead Desire to be Rich Consistent Action With the right mindset, moving one step ahead of others, coupled with a strong desire to be rich and consistent action, you can build your wealth from nothing. Robert Kiyosaki mentioned two ways to create wealth in his book "Rich Dad Poor Dad”. There is building business and investing. Sure there is a risk in investment. It either brings you a great fortune, or costs you tremendous amount of money. The question is, when opportunity arrives, are you prepared? In the stock market, spending time and money in order to gain experience can be fatal. Before investing in the market, let’s see what problems a typical investor would face: Problem 1: Don’t know which stock to buy - invest wrong stock Problem 2: Don’t know when to buy - buying at the wrong time Problem 3: Don’t know when to sell - missed the profit take Problem 4: Unwilling to sell when losing money Problem 5: Gambling, not investing



Online Financial freedom is everyone s dream

How to select a consultant the three imperatives

Copyright © 2006 The National Learning Institute As a manager many years ago when faced with my first challenge of selecting an external consultant, I found myself all at sea. Fortunately for me, I intuitively hit two of the three selection targets. The project was to produce a communication video, so it was relatively easy to see and compare what each consultant had previously produced. I had a number of consultants to choose from, but finally chose the one that I felt most comfortable with and whose work impressed me most. The project was succesful and in the process, I learned a lot. Since that time, I have had to employ a number of consultants, I have been a consultant myself for almost 20 years, and I have worked with many other consultancies both large and small. The following suggestions for selecting a consultant are based on my experience as a manager and in the consultancy field. What are the three targets that one must hit to successfully select a consultant? (Note; I am using the term “consultant” to refer to either one person or a consultancy firm). Firstly and most obviously, the consultant must be able to actually do the work. Secondly, the consultant must be able to fit in with the people in your organisation and particularly those who will be working on this project. Finally, if the consultant is good, you should always improve your own knowledge as a result of the project. 1. Can the consultant do the work? Seems obvious, but there are some traps. For instance, I remember when starting out as a consultant in partnership with another (who was also new to the role), submitting a tender for a fairly large job and being selected in the final few for interview. Individually, we’d had some experience in the type of work, but not as a partnership, nor had we worked in the prospective client’s industry. We won the job. Why? The client saw in us some creativity and freshness that was not evident in our competitors. However, this was an unusual client. Normally, I would not suggest taking on a consultant (like us) who has not had the depth nor breadth of experience in the project. So, unless one of your criteria is “freshness”, in terms of selecting for experience here are some tips: • What are your specifications? Be very clear on the outputs you will require in the project. These should always be measured in terms of quality, quantity, time and cost. Use these output criteria to compare consultants. • Who has recommended this consultant? Check their references – ask for the contact of the last job they did. When checking references, use your above “output criteria” as a guide. • Are you looking for someone to implement solutions to a problem you have identified, or are you looking for someone to help you identify and clarify the problem? Or both? Sometimes it can be useful to split the project into these two parts. • In discussion with the prospective consultants, do they really give you the time to say what you want before jumping to conclsuons? If they appear to “have all the answers”, chances are they do not listen very well. • Does their suggested solution appear to be specifically designed for you or is it a “one size fits all”? Be wary if it is not specifically designed to meet your project criteria. • Do they explain the things they can’t do as well as those they can? This is always a good test of integrity, truefulness and reliability. • Is their initial response to your request up to your quality standards, sufficiently detailed (but not overly so) to make a decision, and within your time expectations? • Does the consultant have depth of expertise in the subject matter and breadth of expertise in its application? • Ask the consultant what is unique about him or her? What makes them stand out from all the other consultants you might choose? 2. Secondly, will the consultant fit in with the people they will be working with? This is a critical implementation issue, as whilst they might be able to do the work, if they can’t work harmoniously with the people, the results will be less than optimal. For instance, we once worked on a major government project (total budget in excess of M$43) where the client continually kept us at arm’s length (for example, on a residential workshop, we were not encouraged to eat or mix socially with the client project leaders). We met the output requirements for the client, but had we been allowed to work more closely with the client, they would have received a lot more value added service. In this case, the client should have selected another consultant. The following tips will help ensure you get the right client/consultant match. • Is the consultant likely to be able to gain the respect and trust of your key stakeholders? • Could you trust this person (people)? • What is the process they will use? i. e, How will they work within the organisation? How will they be seen? Try to visualise the consultant working with you and the other people as they complete the project. Will it work? Is it likely to be a good partnership? • Who specifically (from the consultancy) will be working on the project and what will be their role? For example, will the people you are interviewing be carrying out the work? Be wary of consultancies that have “front people” that win the jobs, then send in less experienced people to do the work. • Ask the consultant to describe what a “good working relationship” looks like to them. Is the description the consultant gives you of a “good working relationship” likely to be, and to be seen to be, a partnership? 3. Thirdly, will you be able ot learn from this consultant? One of the reasons you hire a consultant is that you (or your organisation) does not have the depth nor breadth of experienece to successfully carry out the project. One of your aims should be to increase your own experience through this project. For example: • Why did you decide to employ a consultant? What were the gaps you could not fill internally? • What will you be likely to learn from this consultant? • Will you increase your knowledge of both process management (how the consultant works) as well as content management (their area of expertise)? • Will the consultant strengthen and support your role in the organisation? Finally, if all of your criteria have been met and you cannot decide between two apprently equal consultants, consider setting them a small task or part of the project to complete as part of the selection process. For example, some years ago we were in competition with another large consultancy for a sizeable project with an initial budget in excess of M$1. The client could not decide between the two of us, so he asked us each to undertake a small project (for which he paid us both), which would ultimately become part of the larger project. When we each completed the small project, he had an excellent idea of both our capability and the manner in which we worked. After all, isn’t the final selection criterion is actually trying the consultant out? Oh, yes. In case you’re wondering, we won the job!



Online How to select a consultant the three imperatives

Debt settlement consolidation or bankruptcy

Which Is Worse--Debt Settlement Consolidation or Bankruptcy? Many lawyers will take loads of cases, leading their clients into bankruptcy, rather than helping them to find a solution. The lawyers are paid large amounts for their work; therefore, they are out to make a buck in most instances. Now, if you are in debt and need help, you should make a visit to the attorney's office as your lost resort. There are a number of solutions for settling your debts, including debt management, debt consolidation, debt negotiation, and even do-it-yourself strategies. In other words, if you want to cutback, find ways to make extra cash, work toward paying off your debts to avoid bankruptcy and the subsequent lawyer fees. If you have recently ruined your credit or filed for bankruptcy, repairing your credit is the most important thing you will ever do. If you have bad credit, it will always be hard to get an apartment, to get a house, to refinance a loan, or to get any other form of credit loans, including even credit cards.

Similarly, if you have not established credit, it is frequently easier said than done to get a line of credit from most banks. Consequently, it is imperative that you protect your credit rating. There are more than a few ways to build credit, as well as to repair credit. If you are repairing your credit, it will usually take around six months before most banks will allow you to apply for a loan; however, since more than 4% of the population is in debt, companies are coming up with solutions to help these debtors out. United Way and Credit Unions have joined together to help millions resolve their credit issues every single day and get out of debt. If you want to rely on an honorable source to help you, then United Way or Credit Unions for debt consolidation are your best bet.



Online Debt settlement consolidation or bankruptcy

Ebay sellers how to market your auctions

eBay Sellers: How to Market Your Auctions Are you an eBay seller? If you are, your goal is likely to make as much money as you can by selling products that you no longer need or want on eBay. Unfortunately, there are now thousands, if not millions, of individuals who are interested in doing the same thing. For you, this often means a steady increase in competition. However, even with competition, you should still be able to make a profit when using eBay, but you may need a little bit of help. That help could from marketing. When many of us think of internet marketing, we often automatically think of online retail stores or online websites. Although you are not running your own online retail store, you are trying to make a profit online; therefore, you are, in a way, like a retailer. Just having your for sale items listed on eBay is enough to get your eBay items exposure, but you may want to think about taking it a step farther. There are a number of different ways that you can go about marketing your for sale eBay items, without having to spend a dime. Perhaps, one of the best ways to go about marketing your eBay items is by joining the eBay community, otherwise known as the online message boards. When you talk with other eBay community members your screen name used is also your eBay name. In the eBay community forum, every time that you start a new message or respond to an existing one your name is left, with a link to your main eBay webpage. That is the age that outlines all of the items that you currently have available for sale. Many eBay community members click other member’s pages just out of curiosity, but it not uncommon for someone to find something that catches their eye. Simply starting a few conversations with other eBay community members, even just occasionally, may help to up your eBay exposure. Another relatively easy way that you can market your eBay auction listings to the general public is by posting on a number of message boards, besides eBay. There are a number of message boards that allow internet users, just like you, to post information on items that they have available for sale, both on and off of eBay. Providing a link, as well as short description of some of the items that you are looking to sell is a great way to increase your eBay exposure and up your chances of making a sale. When taking this internet marketing approach, it is important that you only advertise your eBay listings in areas designated for doing so. Spamming is not permitted on many online message boards and it may actually get you a bad reputation. Speaking of using online message boards, there are a number of online message boards or forums that allow members to have signatures. Signatures are where many people leave their name or a favorite quote of theirs, but some message boards allow members to use it as space to promote their products or businesses. Before posting a link to your eBay auctions, you are advised to examine the online message board’s policy concerning signature advertising. Should it be allowed, you are advised to take advantage of this free internet marketing. You will want to post a link to your eBay sales page, but be sure to mention that eBay is where all clickers will be going. Another easy that you can promote your eBay items, particularly if you have multiple items for sale, is by putting a “please checkout my other eBay auctions,” message at the end of each of your eBay listings. As with all of the other above mentioned internet marketing tactics, this is easy and free to do. Word Count 629



Online Ebay sellers how to market your auctions

Pinot gris or grigio this grape makes great wine

One of the most popular imported wine styles in America is Pinot grigio. Nearly all of the Pinot grigio consumed in the US comes from Italy, but as we shall see this is likely to change soon. Pinot grigio is very popular with consumers, but it receives mixed reviews from wine judges and wine critics. One reason may be that wines made from Pinot grigio do not have a consistent and distinctive varietal character. Consumers are just attracted to the crisp which goes well with a wide variety of foods. Another problem is that there are two names for the variety in common use. The names Pinot Grigio and Pinot Gris mean Grey Pinot in Italian and French respectively. 'Pinot' refers to the characteristic pine one shaped bunch of this group of varieties. In Australia, winemakers, marketers and wine writers haven’t really sorted out which name to call the variety. Some have dodged the issue and refer to “Pinot G.” This variety closely is related to the much better Pinot Noir variety and is believed to be a mutation of Pinot Noir. In fact in the vineyard Pinot grigio is difficult to distinguish from its putative ancestor until the berries ripen when those of the grigio will have much less pigment.

There is another variety, Pinot blanc which has little or no pigment in the berries. There is considerable clonal variation within the variety. Jancis Robinson says that the variety hardly knows if it is a dark or a light grape. It has several synonyms including Burot and Malvoise in France and Rulander and Tokayer in Germany.

In Europe the variety is widely planted. Given the inherent variation and geographic dispersion it is hardly surprising that a wide range of wine styles are produced from it. In Alsace under the name of Tokay d'Alsace, it produces a rich, almost oily wine. In Northern Italy the Pinot Grigio's are light and even spritzig. Under the name of Rulander in Germany it produces wines somewhat similar to white burgundies. The variety has attracted serious interest in Australia only over the past few years. It is now producing some remarkable wines in regions such as the Mornington Peninsula, Geelong and the Adelaide Hills. Casella wines in the Riverina wine region are very interested in this variety.

They believe they can make first class wines even in warmer wine regions, and are devoting some resources to developing a wine suitable for export to the US. Remember Casella is the company who developed the yellowtail range of wines which exploded onto the US market a couple of years ago. There is a great deal of experimentation with the variety and it may take several more years before the optimal combination of terroir and winemaking technique emerges. In the meantime some great wines are already available for those who are looking for new experience. The style varies from light bodied and fairly straight forward to rich and complex wines that are almost overwhelming in their voluptuousness. This is one occasion when reading some tasting notes about a particular wine before buying is worthwhile.



Online Pinot gris or grigio this grape makes great wine

Get growth from your plants

Have you experienced the frustration trying to grow plants that never grow? If you have, there may be some things to consider before you attempt to see growth happen again. A first thing to considering as you try to plant seeds and see their growth is the location. Where will you grow the plants? What are the conditions of that area? If you attempt to grow plants outside, what is it like? If you are hoping to achieve plant growth inside, what kind of environment are you using for the growing? Be sure that you understand how wet, dry, sunny or cloudy your chosen areas are. Having a correct picture of these things will save you time and money as you begin to look for the right kinds of seeds and plants to experiment with.

It is important not only that you understand the environment in which you hope to see growth from your plants, but it is also important to choose the right kinds of seeds to plant. You must be careful to match a proper kind of seed with your environment. If you live somewhere that is dry and hot most of the time you should choose seeds that require a dry heat for maximum growth. Other varieties of plants will grow better in areas that are sunny but wet, and still others will have maximum growth in areas that are cool and wet. So learn your growth environment well and then choose plants wisely and accordingly. You will not see proper growth happen from even the best, most expensive varieties of plants if you have chosen a seed that does not match your growing environment. Once you have determined the kinds of environments you have and you have selected the right kinds of seeds to plant you can begin the process of planting the seeds. Take some time to research this process. Are there particular kinds of soils that will bring growth quicker than others?

Is there a plant food that will promote growth for your chosen varieties? These are important things to know. How much water does your plant require for healthy growth? Over or under watering a plant can quickly be the death of it. Is this process sounding more complicated than you thought it would be? Take heart, you are almost on your way to seeing amazing growth from every seed you plant. The most important steps, if done properly, will almost ensure the results you are hoping for. Perhaps your best bet is to pick up a book on growth and planting from your library or from a friend. Learn as much as you can and then enjoy. Maybe you will want to start with some cheaper seeds first so that you can practice doing everything necessary for their growth before you spend too much money. Whatever you decide, just have fun. Determine the right environment for growth, pick the right seeds, then treat your seeds with the individual care they need. In no time you will be surrounded by a wealth of beautiful plants and flowers.



Online Get growth from your plants

The golf academy of arizona an sdga golf school hits a hole in one with its new and improved campus

“FORE!” It’s a common cry from green pastures throughout the United States. Perhaps kicked off by the introduction of Tiger Woods to the pro circuit in 1996, the nation’s interest in golf has catapulted in recent years. Men and women, young and old, black and white, it seems these days that everyone is gearing up for a swing at the tee, or some sort of crack at the industry. But with little or no experience, many people are finding their dreams of a PGA Championship (or LPGA Championship for that matter) stymied. Aspiring golfers have increasingly been turning to the pros for instruction and guidance.

Now one academy in Chandler, AZ is better equipped than ever to handle the influx of novices as well as the more seasoned golfer looking to break into this tough business. Strategically located just outside of Scottsdale, the Mecca of the golf world, The Golf Academy of Arizona, has relocated into expanded, more modern quarters. As a campus of the San Diego Golf Academy, the oldest, largest and one of the most esteemed golf schools in the world, TGAA’s management team correctly identified the need for rejuvenation and wasted no time in getting this project underway. “We feel that we offer a truly unique program,” explains TGAA Director Tim Eberlein, his pride in the course clearly evident. “It’s so much more than just a golf school or lessons. Our students are coached in every aspect of the sport – from how to teach the game of golf, to managing a golf complex. We prepare our students for a true golf career.

” He goes on to admit, “And truthfully we were outgrowing our original facility. We recognized the need to grow and change, much like the sport itself has grown and changed over the years. It was a natural progression.” Now with over 10,000 square feet for classrooms and instruction, TGAA's new campus also acquired a new golf simulator to add to its expansive teaching and learning aids. The state-of-the-art facilities also include a computer lab, administrative offices, student and placement service areas, a lounge, and library. The San Diego Golf Academy is well above par when compared to ordinary golf instruction courses. It’s an intensive 16-month Associate of Applied/Occupational business degree program. The curriculum is divided between golf instruction and business management, operating on the principle that golf is no longer merely a sport, but an industry, and one that is brimming with opportunity. Paul Zagnoni, President of SGDA adds, “It is our job to show students how to turn their love of the green into green. Now more than ever, we provide our students with all of the necessary tools for a successful career in golf.” He concludes with a smile, “The finished product has far exceeded our every expectation.” For more information regarding TGAA and its new campus, please call Tim Eberlein at 480-857-1574.



Online The golf academy of arizona an sdga golf school hits a hole in one with its new and improved campus

The new healthcare discount benefit plans

Copyright 2006 Gary Dunaway Maintaining good oral health, as well as correcting dental problems, is essential to a healthy lifestyle. However, a growing number of Americans are finding themselves without effective dental coverage to treat and maintain their dental health needs. This is due in part to businesses increasingly cutting back on dental benefits for their employees. As a result, people have started looking online to explore their dental benefit options. The main question people are asking is, “What’s the difference between Dental Insurance and Discount Dental Plans?” There are distinct differences between the way “traditional dental insurance plans” and “discount dental plans” work. As a general rule, dental insurance is utilized by large groups and businesses to cover their employee’s dental care. Dental insurance requires paying monthly premiums for defined coverage. Dental insurance is not readily accessible to individuals and families, unless provided by their employer. Some drawbacks of dental insurance include annual spending maximums, deductibles, waiting periods for certain procedures, and limitations and exclusions on care. There are also tedious claims forms to fill out and submit. Dental insurance usually covers the cost of preventive services (such as cleanings and exams) only after deductibles are met. Annual deductibles vary from $25 to $50 per covered individual, depending on the policy. The cost of deductibles should be considered when calculating the overall costs associated with dental insurance. While you are able to use any dentist, the monthly premiums for dental insurance may be as much as $30 per month for individuals and over $100 per month for family plans. Discount dental plans, on the other hand, are available for the millions of Americans that do not receive dental benefits through their work or business. Discount dental plans are designed to provide consumers access to dental networks at reduced rates. These plans, are commonly known as “referral” or “reduced fee” plans, and are not considered an insured dental plan. Discount dental plans are affordable to join and are the most widely available dental programs for individuals and families. These discount plans work differently than dental insurance plans, yet provide consumers with real and substantial savings on most dental procedures. Discount dental plans are membership-based programs that usually provide coverage on an annual basis. Consumers pay a membership fee in exchange for secured discounts on most dental services, such as dental exams, routine cleanings, fillings, extractions, root canals, dentures, crowns, and braces. These plans typically save our members 30% to 80% on most dental procedures when visiting a participating network provider. Most discount dental plans provide a “fee schedule” with the discounted fees listed out in the membership materials to ensure consumers will receive their promised savings. While there are several differences between traditional dental insurance plans and discount dental plans, they can also be used together in certain situations to maximize savings.



Online The new healthcare discount benefit plans

Pleasure and empowerment through art therapy

They say that art imitates life. It is a medium of expression of one's creativity. It conveys a whole lot of ideas and feelings. Art is a product of human activity that stimulates the senses and evokes different types of emotions. It is the mind's interpretation of what it perceives, and expresses it in symbols, words, drawings, music, dance, plays, etc. It comes from the mind of its creator.

If art imitates life, and an expression of human activity, then art can help us understand an individual's state of being through his works. Some artists paint on canvasses while others find satisfaction in something deeper: the art of inner healing. Artists who are knowledgeable about human development, psychological theories, clinical practice, including spiritual, multicultural and artistic traditions have discovered the healing potentials of art. Art therapy is the therapeutic use of art by people who experience a variety of challenges in life, such as stress and anxiety, emotional problems, depression, illnesses, and other health conditions. It is also for people who seek personal development and fulfillment. Art creations and its processes increase self-awareness and the ability to cope with struggles in living which include coping with symptoms, stress, and traumatic experiences. Art therapy helps to enhance cognitive abilities and provides life-affirming pleasures. In art therapy, creation may start with an urge to make a doodle or sketch, or with a certain feeling, dreams, memories or just a plain idea. The next step is to give it a physical form with the use of a clay or paint or any tool one would like to use for his creation.

This is a creative play that provides a means to express something that has no word, or is not yet understood. There are a number of reasons why people come to art therapy. Most people who are grieving a loss of a loved one, undergoing depression, trauma, sexual abuse, and drug or substance addiction find relief and courage through creative expression. Others who are mending broken relationships, exploring their dreams, or seeking for renewal and meaning in their lives have found the depth of art therapy to be very helpful and effective. Art therapy can provide a deep sense of safety as it becomes to be a trusted place to consider these private images or expressions. Picture, sculptures and other forms of art offer a kind of nourishment, healing insights, and a fresh respect for one's creativity.

There are people who prefer to work in silence. But there are also times when a unique dialogue between a client and a therapist takes place. The finished art work remains as a source of further reflection after the session. For art therapy, creativity, its process and the experience is given more emphasis than coming up with a beautiful product. A drawing of an ugly picture can be an important expression. Just the act of picking up a crayon and making a mark can be a powerful expression to some people who have not done any art since grade school.

Engaging in artworks can evoke feelings and relive memories of those days Art therapists with proper training have also become professionals in the field of aesthetics and therapy. They are experts about the healing potential of art. They use art in treatment, assessment and research. They provide consultations to allied health professionals and work with people of all ages, individuals, couples, families, groups, and communities. Services are provided individually or as part of clinical teams in different locations and settings that include mental health, rehabilitation, medical and forensic institutions; community outreach programs; wellness centers; schools; nursing homes; corporate structures; open studios and independent practices. To experience and to regain creativity can be empowering, as well as pleasurable. Connecting creativity with therapy greatly helps in exploring the struggles and challenges of daily normal life.



Online Pleasure and empowerment through art therapy

Creating inexpensive gifts with coffee mugs

During the holidays you may become overwhelmed by the list of people you need gifts for. When trying to find gifts it can be difficult to get cute presents at inexpensive prices. The more people on your list however, the more important cheap gifts are however. When trying to put together inexpensive gifts for people like teachers, neighbors, or church members, you should consider using coffee mugs. Coffee mugs are great because there are several different ways of giving them as gifts, depending on who you are giving to. Use these fun and inexpensive ideas to help your holiday gift list become a little shorter. Candy If the person on your list loves sweets, then consider taking a lovely coffee mug and filling it with his or her favorites. You can fill the large coffee mug with candy, wrap tissue paper or cellophane wrap around it, secure it with a bow, and be finished. This is an adorable idea for teachers or church members. It is inexpensive and you can even choose mugs that depict the recipient’s favorite hobby or color. Besides, everyone loves a little candy during the holidays. For an extra special treat, consider making your own homemade candy for the gift. Coffee As ironic as it may sound, sometimes coffee is the best gift to give within a coffee mug. For a friend who can’t resist gourmet coffee, this can be a quick and easy gift idea. Simply fill an oversized coffee mug with a small bag or two of specialty gourmet coffee. This is an adorable way to give an inexpensive, yet personal gift. Consider adding a specialty spoon along for extra flair as well. Gift Cards If you are giving a gift card this season and want to find a way to make it a little more interesting, consider putting it inside a coffee mug. You can fill the mug with a little tissue at the bottom and then place the gift card inside. You can also use shredded confetti tissue for filler. This is a great way to give your gift card as well as a cool coffee mug to the recipient. This is perfect for the coffee or tea drinker as well. You can fill coffee mugs with a gift card for a local coffee shop, a restaurant, or anything else. It is also a good way to avoid losing the gift card under the tree. When it is wrapped into a coffee mug, there is less of a chance it will be accidentally tossed. Soaps If you need a feminine gift that does not cost a lot, consider filling a pretty coffee mug with little soaps or lotions. You can usually get these for very inexpensive prices at your local bath or beauty store. These are perfect for young girls as well who love to experiment with things like lip gloss and other makeup. Just fill the mug and wrap a little tulle around it along with a ribbon for a feminine look.



Online Creating inexpensive gifts with coffee mugs

How to act on a first date

The key to a successful first date is to relax and just be the real you. If you try to act in a way that you think the other person will like, then they may start liking someone who you are not, and in the end you will wind up breaking up and getting hurt, so honest truly is the best policy, and in the end if you are just being you and it does not work you, you know they were not the one for you. Dating is like gambling at poker, sure a good bluff may win you a hand or two but you are not going to win the World Series of Poker by bluffing, only by playing the best you can. This is no different from dating if you make things up to try and impress this person they are not liking you but are liking the fake you and eventually they will see the two are no the same. Try to think back to the things you talked about when the both of you spoke on the phone and see if you learned anything that may help you decide where to go for your date, but if you do not have enough information about them to know what they may like you sometimes have to gamble and throw the dice, and hope you don’t crap out. The most important thing to do on a first date is to have a good time, the bigger a deal you make of it the harder it is going to be and the higher the chances of you making a jerk of yourself. If you are nervous before the date take a few minutes and take a few deep breaths and if this does not help then I recommend you do what I like to do in the casinos when my nerves are bothering me I simply have a drink. The alcohol in one drink will usually calm me down enough to concentrate. The key to having a nice first date is simple: Take her/ him to a nice place, quite but not too quiet, you should be able to hear each other but other distractions are also good for those uncomfortable moments. Do not take her/ him to a place where your friends hang out, this will make her/ him feel as if they are being ganged up on or they may feel out of place and resent you for making them feel that way. It is very important to have the whole night planned out already before the date and have a backup idea just incase. The tricky part is making it look like it was not all planned. Let's say you decide that you are going to take her for dinner, then after you want to take a walk on the beach do not just say hey after dinner let's take a walk on the beach. I would recommend you wait till after dinner and ask her if she wants to take a walk to burn off dinner and then take her to the beach. Then when you are on the beach take her/his hand while walking, this makes a physical connection between you and makes it easier later on when you go for your first kiss. Just remember that dating is a gambling sometimes you are going to get a bad hand and eventually if you play your cards right you will find the right person and win the jackpot.



Online How to act on a first date

West indians retuning home for retirement bear this in mind

Copyright 2006 Nicholas Marr During the late 1950s and through the 1960s the UK positively encouraged West Indians under their wings to find fortunes in the UK. England at this time was short of labour and needed workers to fill the more menial posts. West Indians travelled in their droves in ships landing at the docks to a new life in the cold and the rain. These workers settled, buying houses, having children and building up pensions. Many always thought of moving back home one day. This dream of returning home is a calling from the heart. Why should they stay when after all the work is done? Their children are grown and have lives for themselves. Many have bought property and now have substantial sums of money as a base to move back home. Just think what a person could buy in Jamaica for the price of a London home for example. Think twice the dream may not come true Having paid taxes and contributed to the economy many West Indian retirees have reasonable pensions. This income will mean even more in the Caribbean and returnees are set for comfortable retirements back home. But serious thought needs to be given to a move back home. Returning home to the Caribbean should not be a knee jerk action even though this was the master plan. Many returnees have not visited home for many years. The memory of home may be viewed with rose coloured glasess. Home may not be how they remember. Many friends may not be there. A returnees culture may now not be the culture of back home. Living in country for most of your life will change a person and those returning home may not be as happy with life as they thought. Retiring to home the biggest consideration As we get older our health becomes even more of an issue. Health care on some islands in the Caribbean is below the standard that many West Indians living in Europe have become used to. Paying for your health care is probably the best alternative but this often has a high price. Some insurance companies will happily take your money for healthcare. But if you have suffered an illness in the past they may well opt you out if a similar problem arises in the future. So care and understanding needs to be applied to this issue. If you became ill whilst back home and thought you will return back to the UK for example think again. Some illnesses may not allow you to fly and without a permanent address in the UK you may have lost your entitlement for free care. Many Caribbean Islands want returnees. Caribbean governments have seen the benefit of their countryman returning back to the warm shores of the Cribbean. They bring foreign money with them and will act to help the economy. Returing home to Jamaica In recognition of the need to facilitate the relocation and resettlement of those Jamaicans who return home to retire, invest, work or share experiences and expertise gained abroad, the Government of Jamaica has instituted a number of procedures aimed at simplifying the process. The Returning Residents Facilitation Unit at the Ministry of Foreign Affairs and Foreign Trade in Kingston was established to provide guidance on import regulations and immigration procedures to Jamaicans who wish to relocate to Jamaica. The primary mission of the Returning Residents Facilitation Unit is the effective administration of the Returning Residents Programme through the establishment of an environment conducive to the return and reintegration of Jamaicans overseas and the provision of related services. The Facilitation Unit also liaises closely with the following Ministries, Departments and Agencies: Don’t burn your bridges It is good advice for those considering returning home not to just sell everything and go. Careful planning which leaves a home that can be rented is the best way to return home. This can be achieved by downsizing. Selling a large family home and buying an apartment for example has many benefits . It would release cash to buy a property back home. It would also allow the purchase of a home that could be let. This would provide further income and as place to come back to if all goes wrong . Returing home is set to be a happy time for those who have worked to gain financial independance. Preparation and having a contingency plan is the key to future security for those retiring back home.



Online West indians retuning home for retirement bear this in mind

What is thread count

Thread count is a measure of quality of fabrics used for bedding. This measure of quality looks at the fineness or coarseness of a fabric; in this case it mostly refers to bed linens like sheets and pillowcases. Thread count is the number of threads going each way in one square inch of fabric. Thread count is measured by counting the number of horizontal and vertical threads in one square inch of fabric. Thread counts average from lowest (80) to highest (1200).

Most are usually between 180 and 300, and anything above 300 is considered higher quality. Higher thread count means more threads, and this usually translates into a more densely woven fabric that lasts longer and is many times softer. Some exceptions to this rule are fabrics made of linen, flannel, or jersey. Fabrics like linen, flannel, or jersey are subject to low thread count because of the type of material they are made of and the properties of that material. For example, part of the softness of flannel comes from its low thread count because of the material it’s made from. Ply and thickness are two factors that also affect thread count.

The ply is defined as the number of threads that are wrapped into a single thread. Single-ply refers to the use of single threads in the construction of a fabric. Two-ply refers to materials that twist two threads together into a single thread, thus increasing the fabric’s thread count and creating a stronger thread. This creates a heavier, more durable fabric. Using finer threads often allows for softer, smoother fabrics and more fit into a square inch. Finer thread, like silk, create a lighter fabric, and are thus more desire able than coarser threads. They are also more fragile, so it is important to care for them especially well. While thread count is important in picking your bed linens, remember that cotton and silk are the main types of materials to judge based on a high or low thread count.

Other materials like linen, flannel, and jersey may have a lower thread count, but this doesn’t mean they aren’t comfortable. Blends are also common, and often create softer materials. Jersey-cotton blends, for example, are ideal for baby sheets and other types of baby bedding. When in doubt, see what feels the best. You’re best off visiting a fabric store and exploring the many different kinds of materials to find out how a fabric feels. Knowing what you’re going to get makes your sheet shopping experience easier and more rewarding, especially if you’re shopping online. http:// sheetworld. com



Online What is thread count

Death to fleas

Summers here in Texas can be brutal! The intense heat, the humidity. Not a summer passes without hearing of at least one person collapsing from heat exhaustion. I am fortunate to possess what every Texan aspires to own: air conditioning. Now that might seem as mundane as, say owning an indoor toilet, but truth be told, there's still many people here in Texas today who do not have A/C. In fact, until I was thirteen, I also lived in a house with no A/C. But I digress from the subject of this entry, which is FLEAS. I only mention that about the heat here in Texas as an example of however bad it may be, it does not even come within spitting distance of the horrors of FLEAS. See, with the coming of summer, the heat and humidity, we also get, you guessed it, FLEAS. Humans might dislike excessive heat, but these blood-sucking creatures LOVE the heat. It's their breeding time. People may do most of their conceiving during the winter months, but not FLEAS! Oh no, they like it hot, apparently a fan of the movie. Anyways, we have three cats, one inside cat and two outside cat. Now, dealing with these fleas every year, you'd think that we would have become smarter about it. But no, each June when the FLEAS start hatching, we do nothing to take any precautions until it's too late. What can I say? We've slept since last summer. So, our outside cats pick up the fleas, and presents them to our inside cat. Yes, I know what you're thinking: Why don't you keep your outside cats outside? Like I said, the FLEAS only get bad in early summer. The rest of the year they are not a problem; so we forget their existence until, you guessed it, it's too late! For the last two weeks, I have been cleaning my house much more than normal. I've been vacuuming my WHOLE house every day! Constantly shaking flea powder on the inside cat, Brat. I should just throw her fleabag butt out the door, but she's just too pretty! A holy terror for sure (hence the name) but beautiful nonetheless. Besides, she's just a baby still, and it's not her fault she has FLEAS. Poor thing, she runs and tries to hide whenever she sees me coming toward her now! So, back to cleaning. My house SHINES, it SPARKLES! Not a dustbunny anywhere. Martha Stewart would be proud. But the FLEAS remain. I've spent at least fifty dollars on flea and ant death powder to put on carpets and floors. The darn things won't sit still long enough to be killed. They jump and jump and jump all over my SPARKLING house, evading the death powder. How inconsiderate is that? My daughter, complaining of killer dust clouds in the house, ran away to a friend's house last weekend where she could, presumably, breathe without gasping. But still they're here. I was tired. I was discouraged. I was just about to admit defeat and remove myself to another lodging and let the FLEAS take over this house. THEN the fleas crossed the line. All the time I had been engaged in open warfare with the FLEAS, I had not felt any personal animosity towards them. They did their best to suck my blood; I did my best to stop them. Just the way of nature, right? I didn't hate them; not them personally. Of course, I hated it when they bit me, but I didn't hate them, even though I was doing my best to kill them. But then, like I hinted at above, they crossed the line. They, in their arrogance and perceived superiority, committed an error they will soon regret. One of their bloodsucking soldiers, either ignorant of or completely disregarding the rules of warfare with humans, that is, to stay within the bounds of feet and ankles, decided to reconnaissance my son's ear. He quickly paid for his transgressions. But it does not end with only the one transgressor dying a horrible death (being squashed between my fingernails). Oh no! Because now my blood is boiling! My hatred is rampaging! I will hunt down every single flea and make them ALL pay for the sins of the one! DEATH TO ALL FLEAS!



Online Death to fleas

Bean bags are a cozy combination of comfort and style

Bean bags are incredibly comfortable and the relaxing feeling of sinking into a snug and welcoming bean bag chair appeals to both kids and the young at heart. Bean bag furniture offers a quick and versatile way to furnish practically any room in the home, from a family room or childrens bedroom to a rec room or den. Bean bag chairs have come a long way from the traditional design we all remember from our childhood. These days bean bags come in a range of lounger and teardrop styles, some have arms, some are used as ottomans and sizes range from small kids bean bags and fun animal shapes to extra large sofa sized ones. A bean bag chair can make a great gift for children or teens. There are loads of colorful patterns to choose from, to add a splash of color to your dйcor or to blend in with a themed bedroom.

For sports fans of all ages, there are bean bags emblazoned with the logo of a number of professional and college teams. NHL, NBA and NASCAR bean bag chairs are popular among fans of all ages, and provide the perfect seat from which to kick back and enjoy the big game. Bean bags are easy to move around, so you can be sure of getting a premium viewing position! Bean bags are an affordable option when you're looking to combine comfortable furniture with casual style.

Many come with removable covers, or can simply be wiped clean when necessary. Fabrics include hardwearing cotton twill, faux leather, vinyl and velvet. Bean bag chairs are filled with either foam stuffing or polystyrene beads. Because bean bags are so comfy, they're likely to get a lot of use over the years, but they can instantly be given a new lease of life by plumping up the cushioning with refill beads or filling. Whether you're looking for a snug and cozy place to curl up with a good book, lounge around in front of the TV, or simply relax with friends and family, a bean bag chair could be the ideal solution.



Online Bean bags are a cozy combination of comfort and style

Navision database access via c odbc webservice asp net application

Navision (former Navision Attain) together with Microsoft Great Plains, Axapta, Solomon, Microsoft CRM and Microsoft RMS are now supported by Microsoft Business Solutions. Navision has various customization options. Today we will describe simple case of using C/ODBC driver. This driver and technology allows you to work with Native or C/SIDE Navision database. Navision is also available on Microsoft SQL Server – in this case you use traditional Microsoft technologies, such as OLEDB or MS SQL Server driver to open ADO. NET connection. Our goal is to help IT departments to support and tune Navision with in-house expertise and skills. The topic of this article is Navision Attain database access through Webservice, connected to Navision via C/ODBC based Linked Server – the mechanism available in MS SQL Server 2000 and transfer the results to ASP. NET application.

Our goal will be ASPX page accessing Navision Customers. Let’s begin 1. In our case we will use Navision Attain 3.6 with Navision Database Server, Navision Application Server and Navision Client. These components are installed on Windows XP. You also need to install C/ODBC component form Navision Attain CD. 2. Let’s create ODBC DSN for Navision data access. Select Control Panel -> Administrative Tools -> Data Sources (ODBC). Then select System DSN tab and press Add button. We’ll use C/ODBC 32-bit data access driver. We’ll name Data Source Name Navision, Connection leave Local. As the database (Database button) select Program FilesNavision AttainClientdatabase. fdb (demo database). Then click Company button – we’ll use CRONUS demo company. It is important for C/SIDE correct database access to setup proper options for C/ODBC connection. Press Options button and look at the options available – we’ll need Identifiers parameter – it defines identifiers types, which will be transferred to the client application. In order to work correct with MS SQL Server 2000 with C/ODBC source we need to use these type: “a-z, A-Z,0-9,_”. Now DNS is done. Let’s create Linked Server. 3. Open MS SQL Server Enterprise Manager. Open server tree for the server, which you plan to use, for this server open Security folder and Lined Servers. With right click select New Linked Server in context menu. In the dialog box opened in the Provider Name select Microsoft OLE DB Provider for ODBC Drivers. Let’s name our Linked Server NAVISION. In Data Source string enter ODBC DSN name - NAVISION in our case. Linked Server is ready! Let’s select tables list and look at the data from Navision Attain database. 4. Next we need to create small stored procedure for sales data selection. Here is the text of the procedure: SET ANSI_NULLS ON SET ANSI_WARNINGS ON GO CREATE PROCEDURE NavisionCustomers AS DBCC TRACEON(8765) SELECT No_, Name, Address, City, Contact FROM OPENQUERY(NAVISION, 'SELECT * FROM Customer') RETURN Let’s clarify some points here. TRACEON(8765) directive allows us to work with the data of variable length, returned by C/ODBC driver. Without it we can not select Navision tables fields – we will have these errors: OLE DB error trace [Non-interface error: Unexpected data length returned for the column: ProviderName='MSDASQL', TableName='[MSDASQL]', ColumnName='Ship_to_Filter', ExpectedLength='250', ReturnedLength='1']. Server: Msg 7347, Level 16, State 1, Line 1 OLE DB provider 'MSDASQL' returned an unexpected data length for the fixed-length column '[MSDASQL].Ship_to_Filter'. The expected data length is 250, while the returned data length is 1. OPENQUERY command opens linked server and gives it execution request, and returns record set selected. Directives ANSI_NULLS and ANSI_WARNINGS are required – they provide the possibility of the execution for heterogeneous requests. To test the procedure you can give its name in MS SQL Query Analyzer – EXEC NavisionCustomers 5. Now we need to create ASP. NET application. Let’s use free RAD environment ASP. NET WebMatrix. You can get infor and download it at http://asp. net/webmatrix . You need. NET SDK 1.1 installed, before WebMatrix installation. 6. Launch WebMatrix, select XML Web Service creation in the Wizard window. Leave all the parameters default, just change the file name to NavisionItems, class name to NavisionItems, and Namespace as NavDemo. Midify the WebService code as below (change connection string to actual names): Imports System Imports System. Web. Services Imports System. Xml. Serialization Public Class NavisionItems Function GetNavisionItems() As System. Data. DataSet Dim connectionString As String = "server='(local)'; trusted_connection=true; database='Alba'" Dim dbConnection As System. Data. IDbConnection = New System. Data. SqlClient. SqlConnection(connectionString) Dim queryString As String = "EXEC NavisionItems" Dim dbCommand As System. Data. IDbCommand = New System. Data. SqlClient. SqlCommand dbCommand. CommandText = queryString dbCommand. Connection = dbConnection Dim dataAdapter As System. Data. IDbDataAdapter = New System. Data. SqlClient. SqlDataAdapter dataAdapter. SelectCommand = dbCommand Dim dataSet As System. Data. DataSet = New System. Data. DataSet dataAdapter. Fill(dataSet) Return dataSet End Function End Class 7. Now let’s create ASP. NET application which will show the result set, returned by WebService. Create empty ASP. NET page with the wizard WebMatrix. Name it TestNavisionItems. aspx . Place these controls on the page: DataGrid and Button. Then switch to the Code mode and from the menu Tools launch WebService Proxy Generator. In the showing dialog screen specify http://localhost/NavisionItems. asmx as WSDL URL (if you launch webservice on the different host or web server works through different port – change the parameters accordingly). Note – in this time, if you are deploying webservice on the local machine, using WebMatrix web server Cassini, then it must be already running to this moment. Define Namespace as NavDemo and execute code generation. Next define Button handler: Sub Button1_Click(sender As Object, e As EventArgs) ' Insert page code here ' Dim wsProxy As New NavDemo. NavisionItems() DataGrid1.DataSource = wsProxy. GetNavisionItems() DataGrid1.DataBind() End Sub 8. Next launch our page, press the button on the for and we are getting Navision Items Navision Items! Happy customizing, implementing and modifying! If you want us to do the job - give us a call 1-866-528-0577 or 1-630-961-5918! help@albaspectrum. com



Online Navision database access via c odbc webservice asp net application