In some scenarios it may happen that the Wonderware Information Server portal is using and old version of the SQL Native Client to create datasources. This may be due to a SQL Server upgrade, a Wonderware Information Server upgrade, and so on.
SQL Native Client for SQL Server 2005 is called SQLNCLI while for SQL Server 2008 this is called SQLNCLI10.
While creating datasources in Wonderware Information Server it may happen that the wrong SQL Native Client is used.
In order to use the right SQL Native Client you can edit the value in the Provider input box so the server will use the correct client when connecting to the server specified for this datasource. But at the next datasource creation you will have the same problem because the default values in the Wonderware Information Server configuration database are wrong.
To correct this you need to modify the default values that the portal is using; to do so:
1. Backup your database.
2. Open Microsoft SQL Server Management Studio.
3. Expand the Suitevoyager database.
4. Expand Tables.
5. Right-click the dbo.DefaultValues table and select Edit Top 200 Rows as shown in the picture below.
6. Look for the rows containing SQLNCLI.as shown in the picture below.
Alessandro Panzetta is a Sr. Technical Training Instructor for Wonderware products at Invensys Operations Management.
No comments:
Post a Comment