Versions Compared

Version Old Version 1 New Version Current
Changes made by

foghorn_leghorn (Unlicensed)

Tim Whitlock (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Updated the details and added local links

The End user will use the Validation application on the R Drive.

...

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.

Note
titleSQLNCLI 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;"')This driver may not be installed on some desktops and usually will not be installed on the servers by default. Download available from Microsoft site in the SQL Server Feature pack for SQL Server 2012 SP1 https://www.microsoft.com/en-gb/download/details.aspx?id=35580

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)


Warning
titleManagement 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.

...