Intro This guide aims to demonstrate how to load the IP2Proxy PX12 (IPv6) CSV file into a Microsoft SQL Server 2017 table. If you’re using an earlier version of the SQL Server, you will need to refer to our FAQ page at https://www.ip2location.com/faqs/px12-ip-proxytype-country-region-city-isp-domain-usagetype-asn-lastseen-threat-residential-provider-fraudscore#database for technical information about creating the table […]
How to import IP2Proxy CSV data into MSSQL 2017 (IPv4)
Intro This guide aims to demonstrate how to load the IP2Proxy PX12 (IPv4) CSV file into a Microsoft SQL Server 2017 table. If you’re using an earlier version of the SQL Server, you will need to refer to our FAQ page at https://www.ip2location.com/faqs/px12-ip-proxytype-country-region-city-isp-domain-usagetype-asn-lastseen-threat-residential-provider-fraudscore for technical information about creating the table […]
How to automate downloading, unzipping & loading of IP2Proxy CSV data into Linux MySQL (IPv4)
Here is a guide for users to fully automate the updating of their IP2Proxy PX12 database. We will show how to download the IP2Proxy PX12 IPv4 CSV data from the web server and then unzip it before loading the data into a MySQL server on a Linux platform. The whole […]
How to automate downloading, unzipping & loading of IP2Proxy CSV data into Linux MySQL (IPv6)
Here is a guide for users to fully automate the updating of their IP2Proxy PX12 IPv6 database. We will show how to download the IP2Proxy PX12 IPv6 CSV data from the web server and then unzip it before loading the data into a MySQL server on a Linux platform. We […]
What is a residential proxy server?
Intro Before we jump into what is a residential proxy, we should explain what is a proxy server first. Let’s take the example of a person at home surfing the Internet. When they visit a webpage, their computer actually makes a connection to the web server hosting that webpage. This […]
New IP2Proxy PX9 & PX10 packages
Introduction IP2Location is pleased to announce the release of the IP2Proxy PX9 and PX10 packages. These 2 packages cater to the users who are security-conscious and also online merchants looking to detect fraudulent purchases. What’s new in IP2Proxy PX9 package? With the release of the IP2Proxy PX9 packages, there is […]
How to add a sub account in IP2Location
You can create up to 3 sub accounts if you are a paid customer, granting them different rights to access the features in the customer area. Below are the access rights that you may grant for each module. License Download Invoice IP2Location Batch Service IP2Proxy Batch Service The sub account […]
Using CLR code in SQL Server 2017 to convert IPv6 to IP number
Intro One of the useful things in SQL Server 2017 is the ability to use any Common Language Runtime (CLR) languages to create user-defined functions. This is a good way to bypass some limitations in SQL Server such as the ability to convert an IPv6 address into a 128-bit number. […]
How to block IP addresses from a country using IPset
Introduction Blocking IP addresses from a specific country is a practice known as geoblocking or IP geolocation filtering. Organizations may implement geoblocking for various reasons, depending on their specific needs and circumstances. Steps to block IP address In this tutorial, we’ll cover how we can block large IP ranges using […]
Report of Firewall List in Year 2019
IP2Location Firewall List by Country is a free web service allowing users to export an IP address list of the targeted countries for firewall filtering purposes. The service supports a wide range of formats such as Apache .htaccess, Linux iptables, CIDR, Netmask, Inverse Netmask, IIS web.config, Cisco ACL, PeerGuardian2, network-object, […]