Articles About Finance And Refinancing

Credit Card Fraud Prevention Using ASP and MS-SQL Database

Credit Card Fraud Prevention Using ASP and MS-SQL Database

Hexasoft Development Sdn. Bhd. (645996-K) 1-2-15 Mayang Mall Complex, Jalan Mayang Pasir 1, 11950 Bandar Bayan Baru, Penang, Malaysia. URL: http://www.ip2location.com { sales@ip2location.com }

Credit card fraud has become pervasive on the Internet. According to MasterCard International, account takeover fraud has increased by 369% since 1995. It has become one of the fastest growing types of fraud, and one of the more difficult to combat. More than $700 million in online sales were lost to fraud in 2001, representing 1.14 percent of total annual online sales of $61.8 billion, according to GartnerG2. Even if the credit card company has given the authorization as to the validity of the card, there are several ways fraudulent cards can be used on your site. The card may have been lost or stolen, but the card owner is yet to report its loss. Or the number on the card (and not the card itself) may have been lifted without the knowledge of the owner. There is also a scam called identity theft, where the card has been issued under false pretenses using someone else's identity and data.

As an online merchant, you need to have a system to check the authenticity of orders placed to safeguard your business. While the effort may require additional time and money, it can save you the cost and stress caused by charge-backs for fraudulent orders. You lost your physical products; you lose the sale price; you lose another business opportunity; and you will be fined an additional $15-$50 charge-back fee. If you have a high percentage of charge-backs, your card services company can even blacklist you and cancel your merchant account. You will also spend time looking up the order and provide the requested information to your card services company. All of these hassles are things you can surely do without.

How can you protect your business from credit card frauds? Here are a few steps that can be taken to ensure that the transaction is being requested by the real cardholder.

Suspect shipping address. According to ClearCommerce Corporation, a provider of payment processing and fraud protection software for e-commerce, orders from Ukraine, Indonesia, Yugoslavia, Lithuania, Egypt, Romania, Bulgaria, Turkey, Russia and Pakistan have a very high incidence of fraud, and often have unverifiable addresses.

Untraceable email address. In many fraudulent orders, the customer's email address is often at one of the free email services, like hotmail.com and yahoo.com, which are relatively untraceable.

Expensive items. Be wary of expensive orders, especially for expensive brand-name items.

Multiple items. It can be a bad sign, for example, if someone orders three X-Box or three DVD players at once, especially where the items have a high resale value.

Express shipping. Most fraudulent orders specify overnight or 1-day shipping without hesitation.

Shipping address differs from billing address. Receiving point and billing address are different in fraud orders. If you are selling valuable items, it can be a good policy only to ship to the billing address of the card's holder.

Suspicious billing address. The address looks too simple or invalid. If the billing address is 123 Main St, New York, the order is probably fraud. You can use or online location tool to see if the address can be verified.

Leave at door or post office box. If the courier service cannot guarantee delivery of goods, the risk of fraud is very high.

The advancement of geo-targeting in the Internet allows us to pinpoint the geographical region for an order. The information can be used to reduce the fraud by verifying it with the billing address and delivery address. This method can identify the scenario where someone from country X has stolen the credit card data from country Y. The IP address lookup service will reveal the real country instead of relying on the country filled in the order form.

IP2Location™ provides technology to translate IP address to country origin. The lookup table is available in several formats such as database and COM. It is the perfect solution to automate the fraud detection using client side programming languages like C++ & Visual Basic; or service side programming languages like ASP, PHP, JSP and CFML.

For example, company XYZ received a credit-card order from IP address 161.139.12.3. The order details are as following:   Name: John Ma   Address: 123 Main St   City: New York   ZIP Code: 11111   Country: United States   Tel: (503) 111-1111   Credit Card No: 1234 5678 9012 3456   Expired Date: December 2010

Credit card merchant processor will authorize this order if the billing address matches the order details. Unluckily, the credit card data has been stolen earlier by Mr. ABC from another country through the Internet. Later, he made a purchase of digital products from company XYZ using the information. His order approved by the merchant because all the details matched John's record in the bank's database. IP2Location? technology can filter the difference between order's country and record's country upfront to protect your business. You can classify this kind of order for manual inspection before delivering the goods. You will be surprise how much this method will help in identifying fraud orders.

In this tutorial, we use the IP2Location? IP-Country database to lookup country of origin from the visitor's IP address. Instead of loading the full database with 50000+ records, we could simplify this tutorial with assumption only two different IP address ranges in the world. IP addresses 0.0.0.0 - 126.255.255.255 originate from United States. Meanwhile, IP addresses 127.0.0.0 - 255.255.255.255 originate from Japan. Here we are creating a database "IP2Location" with table "IPCountry" that consists of two IP address range records.

Step 1: Start SQL Query Analyzer. Create and connect to 'IP2Location' database

 CREATE DATABASE IP2Location;   USE IP2Location;

Step 2: Create 'IPCountry' table 

 CREATE TABLE [dbo].[IPCountry] (   [ipFROM] [float] NOT NULL ,   [ipTO] [float] NOT NULL ,   [countrySHORT] [nvarchar] (2),   [countryLONG] [nvarchar] (64)   ) ON [PRIMARY]   GO 

Step 3. Insert dummy records to the database. 

 INSERT INTO IPCountry VALUES (0, 2130706431,'US','UNITED STATES');  INSERT INTO IPCountry VALUES (2130706432, 4294967295,'JP','JAPAN');

The full version of IP-Country database is available for subscription at $49/year from http://ip2location.com. If you have the full version of IP2Location? IP-Country database, import process is easy done by using the Database Transformation Service (DTS) in MS-SQL.

We create a script to compare the lookup country and data given in the order authorization flow. It serves as a filter to reduce fraud. All rejected orders will be manual verify by merchants.

verify.asp

<%   Dim conn, myDNS, mySQL, rs     ' Country info filled in the form (US is only an example)   BillingCountry = "US"     ' SQL database connection. NOTE: Replace servername, username and password to your own values.   Set conn = Server.CreateObject("ADODB.Connection")   myDSN = "DRIVER={SQL Server};SERVER=servername;UID=username;PWD=password;DATABASE=IP2Location"   conn.open myDNS     ' retrieve visitor IP address and translate it to IP address number   IPno = Dot2LongIP(Request.ServerVariables("REMOTE_ADDR"))     ' SQL query to lookup valid range of IP address   mySQL = "SELECT countrySHORT FROM IPCountry WHERE " & IPno & " BETWEEN ipFROM AND ipTO"     Set rs = Server.CreateObject("ADODB.Recordset")   rs.open mySQL, conn     ' assign country name for reference   CountryName = rs("countrySHORT")     ' close and free connections   rs.close   conn.close   set rs = nothing   Set conn = nothing     If CountryName = BillingCountry Then   IP address originates from country in billing address   ' Low Fraud Risk   Else   ' IP address different from country in billing address   ' High Fraud Risk   End If     ' function to convert IP address to IP number   Function Dot2LongIP (ByVal DottedIP)   Dim i, pos   Dim PrevPos, num   If DottedIP = "" Then   Dot2LongIP = 0   Else   For i = 1 To 4   pos = InStr(PrevPos + 1, DottedIP, ".", 1)   If i = 4 Then   pos = Len(DottedIP) + 1   End If   num = Int(Mid(DottedIP, PrevPos + 1, pos - PrevPos - 1))   PrevPos = pos   Dot2LongIP = ((num Mod 256) * (256 ^ (4 - i))) + Dot2LongIP   Next   End If   End Function %>

IP2Location.com 1901 60th PL, L1020 Bradenton, FL 34203, United States. Tel: - +1 (866) 614-6288 Fax: - +1 (941) 240-2105 Website: http://www.ip2location.net

Other Article Sites

findabook.com  moneycd.info  a-mortgage.info   about-lemon-laws.info  aboutstudentloans.info
all-about-publishing.info  auctions-articles.info  bestcollege-university.com  bestispconnection.com
biblefolder.com  blogger-website.com  books-used.info  brokers-guide.info  buywindows.info  cable-dsl.info
career-miner.com  carpel-tunnel.info  cashinaflash.info  cashloanreviews.info  casinobell.com  chat-house.info
clearmycredit.info  collegeloantips.info  crones.info  depression-articles.info   dirnic.net  dishguides.info
divers-below.com  expodog.info   financewizz.com  fire-insurance.info  getgood.info  handleit.net   it-idea.info
health-supplies.info  hosting-right.com  insidealert.com  insurance-facts.info  jobs-employment.info
justgood.info  lookgold.net   lowcost-travel.info  money-source.info  myhostzone.info  numisblog.com
peoplesearchfinder.info  pr-articles.info  realeas.com   refinancing-guides.info  spyware-remove.info
telelot.info  the-law.info   toppaid.info  travel-deals.info  travelcorrect.com  wedding-guide-site.com
your-blog.info  your-credit.info

MORE ARTICLES:

Active Duty Loan Military - Military Loans For Service Personnel
From times immemorial, we have been dependent on our dedicated military personnel to safeguard the interests of the country While they do so much to ensure that the country remains safe, they are faced up with many difficulties of day-to-day life

Interop Snapshot: Strong Interest in Virtualization, VoIP, and WAN Optimization -- NetQoS and Network Instruments On-Site Survey Reveals Trends and
Interop attendees signaled strong interest in VoIP, virtualization, and WAN optimization technologies, according to a study released today by Network Instruments(R) and NetQoS(R) Inc. The on-site survey of 117 network engineers and IT executives found:

Why We Should All Take More Interest in Flowers
Flowers are available all year round with exotic and tropical flowers being grown under heat or imported from all corners of the world the choices are varied and affordable There are so many different occasions when sending flowers can be apt, a thoughtful and special way to show someone you care about them or are thinking about them

Payment Methods While Shopping Online
While internet shopping is very popular with people around the world, there are still a few people who refuse to shop online. Some believe that processing payments will be a difficult thing to do and other prospective shoppers do not think that their personal information is secure when they make payments online. Internet shopping sites take great care to ensure all financial transactions are secure and spend a good portion of their profits to make payment processing easy for everyone.

Take a Second Mortgage For Improving Your Home
When you need finance for a home improvement project, you have many options at your reach. However, one that is not often considered and can turn out to be a very cheap source of founds is to take a second mortgage on the same property you are planning to improve. Home equity loans or second mortgages are the right tool for financing home improvements. The fact that these loans are based on equity and that you are planning to improve the property that is guaranteeing them has several implications that need to be taken into account. Both the lender and the borrower will benefit from the fact that the loan will be used to improve the asset that is guaranteeing the loan. Home Equity Loans (Second Mortgages)Home equity loans or second mortgages...

A Bad Credit Mortgage Broker Can Turn You From A Walking Liability To A Sound Investment
Who does not fear risk? We all do, especially when it involves money. While risk is an inherent part of business, a good businessman chooses risks wisely. This is especially true in the mortgage industry which is rife with unscrupulous lenders and unreliable borrowers.

No Credit? – You Will Need a Bad Credit Loan
So you have never taken out a loan? You don't have a credit card and you don't have a mortgage? You always pay cash? You're a student, a recent widow, a divorcee or from an ethnic minority group who have a tendency not to have any lines of credit? If you are any of the above then your credit score will not necessarily reflect your ability to pay as you have little or no credit history whatsoever. This will make it difficult to obtain any form of loan and in these circumstances you may have to take out a bad credit loan.

Purchase Your Notebook With a Personal Loan
Though the prices have lowered considerably, notebooks are still expensive items. Nevertheless, they are becoming increasingly essential for many jobs and especially for those who travel a lot. In order to purchase a new notebook most people need some sort of finance and though the usual method of financing these purchases is credit cards, truth is that personal loans are an excellent choice too and they also might be less expensive.

Low Interest Student Loans
Student loans have become a primary concern for most people across the globe. With so many students dreaming of continuing their education, education loans have become a priority.

How to Get a Business Loan in Five Steps
Need funds to startup or expand your business? Follow these steps:A lender looks at a loan request in three sections known as the "three C's". They are:Credit.

Credit Scores and Loan Applications
Keep Your Credit History Clean - Remove A Negative Credit Record From Your Credit ReportIt can make a difference of up to 18% in loan repayment costs. For example, on a 30-year, $150,000 fixed rate mortgage, a borrower with the best credit score, 760-850, will pay 5.

Need Cash Now? A Payday Loan Online Can Help
When the going gets tough, the tough can just run right out the door. That's the way you should really feel when an emergency comes about. However, that's not the way it always works, especially when the emergency involves money that you don't have. The saying, "money is the root of all evil" is certainly not an exaggeration when the lack of money can mean life or death or can result in a negatively life altering situation. Fortunately, there are lenders that can offer you a payday loan online to satisfy your emergency quickly so that you can go on with your life as it was before.

Instant Approval Credit Card- Disaster
Are you safe when you apply online for instant approval credit card? Do you know the facts when it comes to placing a request for credit on the Internet today? Is your spouse and family members identity secure when trusting many of today online credit sites?

5 Easy Tips For To Save Money On Credit Card Balance Transfers
In today's financial market more and more people are turning to credit card balance transfers instead of the traditional home equity lines that they have been used in the past During the refinance hay-day throwing a tax deductible line of credit on the home to wipe out the credit cards was a no-brainer