Yii With Sybase.

Hello All,

My all the application data are available in Sybase. Could anyone pleaes help on following?

  1. I Need to authenticate/login with user table in my Sybase database. I have used connection string as

    ‘connectionString’=>‘dblib:host=server:port;dbname=database;charset=UTF-8’,

    but I am unable to do this.

  2. I tried to create models using Gii but it fails with following error.

General error: 208 General SQL Server error: Check messages from the SQL Server [208] (severity 16) [(null)]. The SQL statement executed was: SELECT TABLE_NAME, TABLE_SCHEMA FROM [INFORMATION_SCHEMA].[TABLES]

WHERE TABLE_SCHEMA=:schema AND TABLE_TYPE in (‘BASE TABLE’,‘VIEW’)

Please help.