Validation SQL Driver Requirement
- foghorn_leghorn (Unlicensed)
- Tim Whitlock (Deactivated)
By default the desktops and servers do not have the SQL Client driver installed so when trying to run the Validation code, Editor etc for the first time they will often see an error like when the code tries to access the SQL server.
SQLNCLI Driver required
The database connections require the SQL Client Driver to be installed on the system running the code. Typical error from validation code
Traceback (most recent call last):
File "val.py", line 31, in <module>
File "rr\database\sqlserver.pyc", line 9, in connect
File "rr\database\ado.pyc", line 54, in connect
File "adodbapi\adodbapi.pyc", line 118, in connect
adodbapi.apibase.OperationalError: (com_error(-2147352567, 'Exception occurred.', (0, u'ADODB.Connection', u'Provider cannot be found. It may not be properly installed.', u'C:\\Windows\\HELP\\ADO270.CHM', 1240655, -2146824582), None),'Error opening connection to "Provider=SQLNCLI11;Data Source=RR-SQL-Live;Initial Catalog=RenalReg;Integrated Security=SSPI;"')
In order to fix this the required driver needs to be installed. This can either be installed as part of the SQL Management Studio product or as a separate install. The necessary drivers are downloaded in the following directory on rr-storage-live R:\0 Software\Server Software\SQL Server Client either sqlncli_x64.msi (64bit Windows) or sqlncli_x86.msi (32 Bit Windows)
Management Studio Installer
When installing SQL Management Studio it will try to install the SQL Client Driver if that is already installed it will usually fail with an error "user exists". The solution is to uninstall SQL Client Driver before installing SQL Management Studio.