If your data is in a Sybase SQL Database you can link to this data by entering the following information into the ADO connection string box.

For Standard Sybase System 11

Driver={SYBASE SYSTEM 11};Srvr=myServerAddress;Uid=myUsername;Pwd=myPassword; Database=myDataBase;

If you are using Sybase System 11 a problem has been noted when linking to data elements with a type of Real to ProAdmin numeric field types through ADO. These values may come through as truncated amounts. To fix this you will need to use the Override SQL feature in the Database Linkage for these fields.

The following is an example of a cast statement for the scalar field Prior Plan Benefit where SSN is the personID field.

SELECT SSN,CAST(PriorPlanBenefit as FLOAT) FROM tb_PriorPlanBen WHERE SSN = $PID

The following is an example of a cast statement for the array field Pay where SSN is the personID field:

SELECT SSN,CAST(PAY as FLOAT),START,STOP FROM tb_Earnings WHERE SSN = $PID

For more complex statements please contact your DBA.

For Standard Sybase System 12

Driver={SYBASE ASE ODBC Driver};Srvr=myServerAddress;Uid=myUsername;Pwd=myPassword;