Modify Your CA Business Intelligence r3.2 Installation to CA Business Intelligence Release 03.3.00 › Migration from MySQL to SQL Anywhere Database › SQL Anywhere Database Preparation Using Manual Procedures › Test the ODBC Connections

Test the ODBC Connections

Use the commands that apply to your environment to test the ODBC connections.

Note: The command line syntax in this procedure contains the variables that are defined in Command Line Syntax Variables. Replace these variables (in italics) with the values that are appropriate for your environment.

Follow these steps:

1. Open a command prompt window.
2. (Windows) Execute the following command to test the connection to DSN for the CMS Repository database.

   SQLANYWHERE_DIR\dbping.exe -c "uid=BOE_UID;pwd=BOE_PWD;
   server=SQLANYWHERE_SERVER;host=SQLANYWHERE_HOST:SQLANYWHERE_PORT;
   dbn=DATABASE_NAME" -d
   

3. (UNIX) Execute the following command to test the connection to DSN for the CMS Repository database.

   $SQLANYWHERE_DIR/dbping -c "uid=$BOE_UID;pwd=$BOE_PWD;
   server=$SQLANYWHERE_SERVER;host=$SQLANYWHERE_HOST:$SQLANYWHERE_PORT;
   dbn=$DATABASE_NAME" -d
   

4. (Windows) Execute the following command to test the connection to DSN for the Audit database.

   SQLANYWHERE_DIR\dbping.exe -c "uid=BOE_UID;pwd=BOE_PWD;
   server=SQLANYWHERE_SERVER;host=SQLANYWHERE_HOST:SQLANYWHERE_PORT;
   dbn=AUDIT_DATABASE_NAME" -d
   

5. (UNIX) Execute the following command to test the connection to DSN for the Audit database.

   $SQLANYWHERE_DIR/dbping -c "uid=$BOE_UID;pwd=$BOE_PWD;
   server=$SQLANYWHERE_SERVER;host=$SQLANYWHERE_HOST:$SQLANYWHERE_PORT;
   dbn=$AUDIT_DATABASE_NAME" -d