DataObject multi-connection MSSQL and MYSQL

From: Date: Thu, 24 Mar 2005 11:43:24 +0000
Subject: DataObject multi-connection MSSQL and MYSQL
Groups: php.pear.general 
Request: Send a blank email to pear-general+get-18301@lists.php.net to get a copy of this message
Hi, I'm trying to use 2 different databases (MSSQL and MYSQL) with DO. I configured my dataobject.ini file like this : --------------------------------------------------- [DB_DataObject] database_quickvisionweb_beta = mysql://***:***@localhost/quickvisionweb_beta ;dsn database_pcbx = mssql://***:***@localhost/pcbx ;dsn table_superV = pcbx ;i only want to map one table --------------------------------------------------- When I generate my classes with the createtables script, it's ok for MYSQL but I've got this error with MSSQL : --------------------------------------------------- db_dataobject_generator: 0: CREATING FOR pcbx [db_error: message="DB Error: unknown error" code=-1 mode=return level=notice prefix="" info="EXEC SP_COLUMNS[_HISTORIQUE_ALARME_SYSTEME] [nativecode=-20 - Impossible d'envoyer des données Unicode dans un classement uniquement Unicode ou des données ntext aux clients utilisant DB-Library (par exemple ISQL) ou ODBC version 3.7 ou antérieure.]"] --------------------------------------------------- 1-Perhaps a problem for detecting some MSSQL types (i've got some GUID in this table). Do you have a solution for this ? 2-The other problem is that the generator wants to map all the tables of my MSSQL database but I only want to get one table definition (look at my dataobject.ini with table_superV = pcbx) Do you have some ideas ? Thx for all, JP. Dumont

« previous php.pear.general (#18301) next »