(odbtp) troubles with connection to foxpro dbf
| From: | Sebastián Arechederreta | Date: | Thu, 01 Jan 1970 00:00:00 +0000 |
| Subject: | (odbtp) troubles with connection to foxpro dbf | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-21831@lists.php.net to get a copy of this message | ||
Hello List...
I want to connect to foxpro files with odbtp.
I have 2 servers, one with Fedora 3, php 4.3.11, odbtp 1.0.3, pear DB, all configured and working fine; the other with windows SBS, winservice odbtpctl installed and running, odbc dns define, odbc Microsoft Visual Foxpro Driver 6.01.8629.01.
My php script is:
<?php
require_once 'DB.php' ;
$DB_dbType = 'odbtp(vfp)';
$DB_user = '';
$DB_pass = '';
$DB_host = '192.168.100.2';
$DB_dbName = 'osepc';
$dsn = $DB_dbType . "://" . $DB_user . ":" . $DB_pass . "@"
. $DB_host . "/"
. $DB_dbName;
$options = array(
'debug' => 2,'portability' => DB_PORTABILITY_ALL, ); $db =& DB::connect($dsn, $options); if (PEAR::isError($db)) { die($db->getMessage()); } //... etc ?> And get the follow error: Standard Message: DB Error: connect failed Standard Code: -24 DBMS/User Message: [nativecode=[S1000][1][Microsoft][ODBC Visual FoxPro Driver]Fox Error 1] ** odbtp(vfp)://:@192.168.10.3/HCU DBMS/Debug Message: [nativecode=[S1000][1][Microsoft][ODBC Visual FoxPro Driver]Fox Error 1] ** odbtp(vfp)://:@192.168.10.3/HCU I changed to other database like mysql and worked fine, but I must to connect to dbf files. What is wrong ?? thanks to all Sebastián