There are three primary reasons why the SDK connection may fail or generate error messages after the initial install.
'[V}]Z>- ruiAEC<Ej 1. Invalid user account is being used to connect to the the SDK
tn>z%6;&Z KElzYZl8 The user name and password used to connect to the SDK must be a Project Management user account with {<Admin Superuser>} permissions or a user account with the Global Security Privilege 'View All Global/Project Data via SDK', i.e. "admin", "admin".
XqX6UEVR4 Errors will occur if the database user account is being used to connect to the SDK, i.e. privuser" or "pubuser"
x=] PE}<E Errors will occur if the user account name or password is incorrect.
ZxW4 i [ed6n@/O@ 2. The Database Alias is not configured correctly for the Primavera SDK ODBC DSN (Datasource Name)
(nL''#Ka Cause:
MhT.Zg\ (^,4{;YQ5 During the SDK installation the database connection should be configured. If this part of the installation is
*% 6NuZ not completed successfully then any connection to the SDK will fail.
-SO`wL NV ! 3&_#VO Resoultion:
UM[<v9NWE Configure the Database Alias for the Primavera SDK ODBC DSN connection using the following steps:
dB`3"aSN7 Launch the ODBC Administrator (from the Windows Control Panel, Administrative Tools, ODBC Datasources).
eksYIQZ] From the System DSN tab, locate the Primavera SDK DSN (default name is PrimaveraSDK) and select Configure.
m 3k}iIU7 Change the Database Alias from the default name PMSDK to a valid database connection.
4O
g&w] (rDB|kc^7 If the Project Management client is installed on the same workstation as the SDK, a simple fix would be to configure the Primavera SDK DSN to use the same database connection as the Project Management client. To find out the name to use, go to the Login screen for Project Management and use the name that is in the Database box at the bottom.
0uZ 'j If the Project Management tool is not installed, then click the Create Database Alias button and use the wizard to create a new database alias.
Y5rR
LY> -kz] 3. Incorrect user name or password for Primavera SDK ODBC DSN
o'uv5asdb The public username or password is incorrect in the ODBC DSN Configuration window. Follow the steps below to correct the problem:
D`|.% ~D[5AXV`^ Launch the ODBC Administrator (from the Windows Control Panel, Administrative Tools, ODBC Datasources).
*p&c}2' From the System DSN tab, locate the Primavera SDK DSN (default name is PrimaveraSDK) and select Configure.
)+!~xL Modify the Public Username and Public Password so they are correct for your database. In order to verify that they are correct, you will need to login to the Oracle or SQL Server database directly using this username and password.
