Re: DB_DataObjects ODBC
| From: | Alan Knowles | Date: | Tue, 25 Jan 2005 06:29:35 +0000 |
| Subject: | Re: DB_DataObjects ODBC | ||
| References: | 1 | Groups: | php.pear.general |
| Request: | Send a blank email to pear-general+get-17141@lists.php.net to get a copy of this message | ||
You could try using the project feature:
database_myproject = "odbc://uname:passwd@nemesys";
ini_myproject = c:/apachefriends/xampp/htdocs/slsa/SLSA_Members/include/DataObjects/myproject.ini
..... etc.
have a look at example.ini in the docs folder on cvs.
Regards
Alan
Barry Steele wrote:
Hi, I may have missed a whole lot of this, but I'm having some issues wityh odbc and DB_DataObjects 1.7.2. Below is an excerpt from the ini file [DB_DataObject] database = "odbc://uname:passwd@nemesys"; schema_location = c:/apachefriends/xampp/htdocs/slsa/SLSA_Members/include/DataObjects/class_location = c:/apachefriends/xampp/htdocs/slsa/SLSA_Members/include/DataObjects/require_prefix =c:/apach.../SLSA_Members/include/DataObjects/ ini_nemesys = c:/apac..../SLSA_Members/include/DataObjects/SLSV_Members.ini class_prefix = DataObject_ ignore_sequence_keys = 0 debug = 0 debug_ignore_updates = 0 As you may guess from above we are running XAMPP on Win32 with PHP5. It may seem like a silly question, but there seems no clear way to specify the database.ini file as the odbc DSN doesn't contain it. Is there a better config process that I can use to specify the .ini and .linls.ini files? With $obj->debugLevel(3), I get: <output> DataObject_EntityUser: QUERY: SELECT * FROM EntityUser DataObject_EntityUser: query: QUERY DONE IN 0.0015931129455566 seconds DataObject_EntityUser: __find: CHECK autofetchd 1 DataObject_EntityUser: __find: ABOUT TO AUTOFETCH DataObject_EntityUser: FETCH: a:2:{s:7:"user_id";s:5:"1.00 </output> In the same framework I use DBO's with a local MySQL database. It seems that I don't hace access to mssql drivers in my PHP as yet. Thanks in advance for your help, Barry