连接 Visual FoxPro9 表时 php5 odbc_connect() 函数错误

发布于 2024-10-30 02:21:26 字数 1334 浏览 1 评论 0 原文

我在 Ubuntu10.10 服务器上运行 php5，其中已经安装了 unixODBC 和 php5-odbc 软件包。我在连接过程中不断收到错误 - 代码：

$data_source = 'DRIVER={Microsoft dBASE Driver (*.dbf)};Data Source=//128.251.xxx.xxx/lv_apps/AppsLON/CData/dbf/cdma';"", "");
$conn = odbc_connect($data_source, "", "");
if (!$conn)
    exit("Connection Failed: " .$conn );

错误消息：

1 Warning: odbc_connect(): SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect in /var/www/vfptest.php on line 6

我向两个文件添加了 extention=dbase.so 和 extention=odbc.so：/ etc/php5/apache2/php.ini 和 /etc/php5/cli/php.ini 并重新编译 php 安装：

sudo ./configure --prefix=/usr --enable-dbase=shared --with-unixODBC

我还转到了 unixODBC 和 pecl单独安装 unixODBC 和 dbase 库没有成功。

我还找到了这个链接： http://www.devlist.com/ConnectionStringsPage.aspx 其中指出，为了创建到 FoxPro 数据库的 ODBC 连接，我使用了以下行：

Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;SourceDB=c:\demo.dbc;Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO

但这对我来说仍然不起作用；可能是因为我没有安装 Visual FoxPro 驱动程序或我的 odbc.ini 文件指向驱动程序路径...但我不知道。

原文

I'm running php5 on Ubuntu10.10 server where the unixODBC and php5-odbc packages have already been installed. I keep getting an error during the connection process - code:

$data_source = 'DRIVER={Microsoft dBASE Driver (*.dbf)};Data Source=//128.251.xxx.xxx/lv_apps/AppsLON/CData/dbf/cdma';"", "");
$conn = odbc_connect($data_source, "", "");
if (!$conn)
    exit("Connection Failed: " .$conn );

error message:

1 Warning: odbc_connect(): SQL error: [unixODBC][Driver Manager]Data source name not found, and no default driver specified, SQL state IM002 in SQLConnect in /var/www/vfptest.php on line 6

I added extention=dbase.so and extention=odbc.so to both files: /etc/php5/apache2/php.ini and /etc/php5/cli/php.ini and re-compiled the php install with:

sudo ./configure --prefix=/usr --enable-dbase=shared --with-unixODBC

I've also gone to unixODBC and pecl to install the unixODBC and dbase libraries separately with no luck.

Also I found this link: http://www.devlist.com/ConnectionStringsPage.aspx
where it is stated that in order to create an ODBC connection to a foxpro database I use the line:

Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;SourceDB=c:\demo.dbc;Exclusive=No;NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO

this still did not work for me however; probably because I do not have the visual foxpro driver installed or my odbc.ini file pointing to the driver path...but I don't know.

分享到QQ

分享到微博