Re: Data_Object Error
| From: | Justin Patrin | Date: | Mon, 04 Oct 2004 17:13:40 +0000 |
| Subject: | Re: Data_Object Error | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-14750@lists.php.net to get a copy of this message | ||
On Mon, 4 Oct 2004 13:57:08 -0300 (ART), Jacques Nunes
<iacques@yahoo.com.br> wrote:
> People, I need a help with de auto generate data object class via ODBC connection. The ODBC
> connection is ok with DB class, but when i go to generate the dataobject class, i get the error:
>
> // file generator.php
> require_once 'lib/core/config.php';
> $_SERVER['argv'][1] =
> JEN_FRAMEWORK_ROOT.'modules/cache/dao/class/config.ini';
> require_once 'DB/DataObject/createTables.php';
>
> The config.ini:
> [DB_DataObject]
> database = odbc://@CacheDataObject // a dbc ok conection
> schema_location = C:/desenvolvimento/framework/bin/modules/cache/dao/class
> class_location = C:/desenvolvimento/framework/bin/modules/cache/dao/class
> require_prefix =
> class_prefix = DataObject_
> debug = 0
> debug_ignore_updates = false
> dont_die = false
>
> The error:
> #!/usr/bin/php -q db_dataobject_generator: 0: CREATING FOR 0
> [db_error: message="DB Error: not supported" code=-6 mode=return level=notice
> prefix="" info=""]
>
> The database is : Chaché 5.0 (www.intersystems.com)
>
> Ps: with the native mysql (mysql database) DSN, the generator is ok!
>
People ask this very often. Try searching the archives before you post.
The error is exactly what it says. The ODBC backend doesn't support
auto generation. Make the tables in mysql, autogenerate, then switch
the DSN to ODBC.
--
paperCrane --Justin Patrin--