Created : 31 January 2018
Last Modified : 31 January 2018

***********************************************************************************
Contents:

A. SUMMARY
B. PRE-REQUIREMENT
C. FILE STRUCTURE
D. INSTALLATION INSTRUCTION
E. CHANGES
F. CONFIGURATION SETTINGS
G. DATABASE TABLES MODIFIED
H. LANGUAGE SETTINGS CHANGED
I. CHANGE LOGS
J. TROUBLESHOOTING
K. FAQ
L. COPYRIGHT NOTICE
M. TERMS AND CONDITIONS
***********************************************************************************

A. SUMMARY
==========
1. Default SQL Server Driver is {SQL Server}
Driver {SQL Server} does not support TLS 1.2 protocol, so if SQL Server is not same server as your web server, merchant are adviced to install this patch
2. Install this patch if:
2a. Web server and SQL server both are diabled TLS 1.0.
2b. SQL server and web server are not in same server.
***********************************************************************************

B. PRE-REQUIREMENT
===================

1. Please check from your host provider, other than {SQL Server}, what SQL Server Driver that host already installed in web server.
You only need either 1 SQL Server Drivers from below:
1a. {SQL Server Native Client 11.0} : The SQL Server Native 11.0 can be downloaded from https://www.microsoft.com/en-us/download/details.aspx?id=50402
1b. {ODBC Driver 11 for SQL Server} : The ODBC Driver 11 for SQL Server can be downloaded from https://www.microsoft.com/en-us/download/details.aspx?id=36434
1c. {ODBC Driver 13 for SQL Server} : The ODBC Driver 13 for SQL Server can be downloaded from https://www.microsoft.com/en-us/download/details.aspx?id=53339

***********************************************************************************

C. FILES STRUCTURE
===================

Files included in the zip are:
- $readme_sqlotherdrivers800.txt
- shop$db_sqlserver.asp
- admin\admin$db_sqlserver.asp
- admin\shopa_modules_subs.asp
- admin\sqlotherdrivers800_setup.asp
- admin\sqlotherdrivers800_setup_config.asp
- admin\sqlotherdrivers800_setup_process.asp
- admin\images\*
- admin\setup\*
- admin\sqlscripts\*

***********************************************************************************

D. INSTALLATION INSTRUCTION
============================
1. Upload all root files into your shopping cart root folder

2. Upload all admin folder files into your shopping cart folder

3. Edit config/shop$config.asp

3a. Scroll to the bottom and locate %>

3b. Before %> , process either 3bi, 3bii or 3biii

3bi. if SQL Server Native 11.0 is installed pleaes insert:

const xsql_driver="SQL Server Native Client 11.0"

3bii. if ODBC Driver 11 for SQL Server is installed pleaes insert:

const xsql_driver="ODBC Driver 11 for SQL Server"

3biii. if ODBC Driver 13 for SQL Server is installed pleaes insert:

const xsql_driver="ODBC Driver 13 for SQL Server"

3c. Save and upload to server

4. Edit /config/shop$config.asp

4a. Scroll to the bottom and locate %>

4b. Before %> , process either 4bi, 4bii or 4biii

4bi. if SQL Server Native 11.0 is installed pleaes insert:

const xsql_driver="SQL Server Native Client 11.0"

4bii. if ODBC Driver 11 for SQL Server is installed pleaes insert:

const xsql_driver="ODBC Driver 11 for SQL Server"

4biii. if ODBC Driver 13 for SQL Server is installed pleaes insert:

const xsql_driver="ODBC Driver 13 for SQL Server"

4c. Save and upload to server

5. Edit shop$db.asp

5a. Locate below line, estimate line 3:
<!-- #include file="config/shop$version.asp" -->

5b. Below this line, please insert:
<!-- #include file="shop$db_sqlserver.asp" -->

5c. Locate below line:
sub ProcessSQLServer(connection)

Rename this line to:
sub ProcessSQLServer_old(connection)

5d. Save and upload to server

6. Edit /admin$db.asp

6a. Locate below line, estimate line 2:
<!-- #include file="config/shop$config.asp" -->

6b. Below this line, please insert:
<!-- #include file="admin$db_sqlserver.asp" -->

6c. Locate below line:
sub ProcessSQLServer(connection)

Rename this line to:
sub ProcessSQLServer_old(connection)

6d. Save and upload to server

7. Log into super admin

8. Execute setup file: eg: http://www.yourdomain.com/yourshoppingcartfolder/youradminfolder/sqlotherdrivers800_setup.asp

8a. Click "Install Now" button to install this patch
***********************************************************************************

E. CHANGES
===============

NONE

***********************************************************************************

F. CONFIGURATION SETTINGS
=================

NONE


G. DATABASE TABLES MODIFIED
===========================

NONE

***********************************************************************************

H. LANGUAGE SETTINGS CHANGED
============================

NONE

***********************************************************************************

I. CHANGE LOGS
============================

2018.12.14 - Compatible with v9

***********************************************************************************

J. TROUBLESHOOTING
============================

Please submit a ticket to our helpdesk at https://helpdesk.vpcart.com and our support team will assist you.

***********************************************************************************

K. FAQ
============================

NONE

***********************************************************************************
L. COPYRIGHT NOTICE
============================

Copyright (c) 1999-2019 Rocksalt International Pty. Ltd.
All rights reserved.

This software and documentation constitute a published work and
contains valuable trade secrets and proprietary information
belonging to Rocksalt International Pty. Ltd. .
None of the foregoing material may be copied,
duplicated or disclosed without the express written permission
of Rocksalt International Pty. Ltd. .

LICENSEE ACCEPTS VP-ASP Shopping Cart "AS IS" "WITH ALL FAULTS",
Rocksalt International Pty. Ltd. accepts no responsibility for the
operation or performance of the VP-ASP Shopping Cart.
The entire risk of use and consequences of use of the
VP-ASP Shopping Cart falls completely on the Licensee
and Rocksalt International Pty. Ltd. shall not be liable in any respect
for any claims, loss or injury alleged to have resulted
from use of or in reliance on VP-ASP Shopping Cart.

Licensee acknowledges that it has read the foregoing
disclaimers of warranty and limitation of liability
and understands that Licensee assumes
the entire risk of using VP-ASP Shopping Cart.


***********************************************************************************

M. TERMS AND CONDITIONS
============================
ROCKSALT INTERNATIONAL GRANTS TO THE LICENSEE A NON-EXCLUSIVE,
NON-SUB LICENSABLE, NONTRANSFERABLE LICENSE
TO INSTALL AND USE THIS APPLICATION ON A SINGLE DOMAIN FOR
A SINGLE SHOP.

THE CODE IN THE APPLICATION MAY BE MODIFIED FOR USE IN
SETTING UP A SINGLE SHOPPING SITE ON THE WORLD WIDE WEB.

LICENSEE MAY MAKE A COPY OF THE APPLICATION FOR
BACK-UP AND ARCHIVAL PURPOSES, PROVIDED THAT ANY COPY
MUST CONTAIN ALL PROPRIETARY NOTICES INCLUDED
WITH THE APPLICATION.

LICENSEE IS PROHIBITED FROM SELLING OR DISTRIBUTING
THE APPLICATION IN ANY MANNER.

LIMITATION OF LIABILITY.

ROCKSALT INTERNATIONAL AND ITS LICENSORS SHALL
NOT BE LIABLE FOR ANY DAMAGES SUFFERED BY LICENSEE OR ANY
THIRD PARTY AS A RESULT OF USING OR DISTRIBUTING THIS
APPLICATION.

IN NO EVENT WILL ROCKSALT INTERNATIONAL OR ITS LICENSORS
BE LIABLE FOR ANY LOST REVENUE, PROFIT OR DATA,
OR FOR DIRECT, INDIRECT, SPECIAL,
CONSEQUENTIAL, INCIDENTAL OR PUNITIVE DAMAGES,
HOWEVER CAUSED AND REGARDLESS OF THE THEORY OF LI
ARISING OUT OF THE USE OF OR INABILITY TO USE THE SOFTWARE,
EVEN IF ROCKSALT INTERNATIONAL HAS BEEN ADVISED OF THE
POSSIBILITY OF SUCH DAMAGES.