请看下列代码: <?php $conn = odbc_connect("odbc1", "", ""); $query = "select title,url from learning"; $result_id = odbc_do($conn, $query); while(odbc_fatch_row($result_id)) { $AA1 = odbc_result($result_id, 1); $AA2 = odbc_result($result_id, 2); echo $AA1." ".$AA2."<br>\n"; } odbc_close($conn); ?> 出现错误以下提示: Warning: SQL error: [Microsoft][ODBC 驱动程序 管理器] 未发现数据源名称并且未指定默认驱动程序, SQL state IM002 in SQLConnect in d:\apache\htdocs\dzts.php on line 2Warning: Supplied argument is not a valid ODBC-Link resource in d:\apache\htdocs\dzts.php on line 4Fatal error: Call to undefined function: odbc_fatch_row() in d:\apache\htdocs\dzts.php on line 5 php(for w2k)连接 ODBC 是否需要配置?怎样配置?
你的数据源odbc1没有配置好控制面板——ODBC数据源———系统dsn——添加 按对话框提示进行
php.ini还需要其它设置吗? 为什么我设了系统dsn,仍然会出现: Warning: odbc_do(): supplied argument is not a valid ODBC-Link resource in F:\root\odbc.php on line 15Fatal error: Call to undefined function: odbc_fatch_row() in F:\root\odbc.php on line 16好像odbc_do()和odbc_fatch_row()这两个函数不起作用?请指教,谢谢!
好,那就用com,如下: <?php $conn=new com("ADODB.Connection"); $connstr="DRIVER={Microsoft Access Driver(*.mdb)}; DBQ="f:\\root\\worldcup2002.mdb"; $conn->Open($connstr); $rs=new com("ADODB.RecordSet"); $rs->Open("select * from player",$conn,1,1); while(! $rs->eof) { echo $rs->Fields["content"]->value."<br/>"; $rs->MoveNext(); } ?>出现错误:Parse error: parse error, unexpected T_STRING in F:\root\adodb.php on line 3WHY???????请高手指点,谢谢!
to 强壮妇女: 第三行 $connstr="DRIVER={Microsoft Access Driver(*.mdb)}"; ~~漏掉了
<?php
$conn = odbc_connect("odbc1", "", "");
$query = "select title,url from learning";
$result_id = odbc_do($conn, $query);
while(odbc_fatch_row($result_id)) {
$AA1 = odbc_result($result_id, 1);
$AA2 = odbc_result($result_id, 2);
echo $AA1." ".$AA2."<br>\n";
}
odbc_close($conn);
?>
出现错误以下提示:
Warning: SQL error: [Microsoft][ODBC 驱动程序 管理器] 未发现数据源名称并且未指定默认驱动程序, SQL state IM002 in SQLConnect in d:\apache\htdocs\dzts.php on line 2Warning: Supplied argument is not a valid ODBC-Link resource in d:\apache\htdocs\dzts.php on line 4Fatal error: Call to undefined function: odbc_fatch_row() in d:\apache\htdocs\dzts.php on line 5
php(for w2k)连接 ODBC 是否需要配置?怎样配置?
按对话框提示进行
为什么我设了系统dsn,仍然会出现:
Warning: odbc_do(): supplied argument is not a valid ODBC-Link resource in F:\root\odbc.php on line 15Fatal error: Call to undefined function: odbc_fatch_row() in F:\root\odbc.php on line 16好像odbc_do()和odbc_fatch_row()这两个函数不起作用?请指教,谢谢!
<?php
$conn=new com("ADODB.Connection");
$connstr="DRIVER={Microsoft Access Driver(*.mdb)};
DBQ="f:\\root\\worldcup2002.mdb";
$conn->Open($connstr);
$rs=new com("ADODB.RecordSet");
$rs->Open("select * from player",$conn,1,1);
while(! $rs->eof) {
echo $rs->Fields["content"]->value."<br/>";
$rs->MoveNext();
}
?>出现错误:Parse error: parse error, unexpected T_STRING in F:\root\adodb.php on line 3WHY???????请高手指点,谢谢!
$connstr="DRIVER={Microsoft Access Driver(*.mdb)}";
~~漏掉了
<?php
$conn = new com("ADODB.Connection");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . getcwd() . "\\worldcup2002.mdb";//注意是一行
$conn->Open($connstr);
$rs = new com("ADODB.RecordSet");
$rs->Open("select * from player",$conn,1,1);
while(! $rs->eof) {
$f = $rs->Fields(0);//0取第一列,1取第二列...
echo $f->value;
$rs->MoveNext();
}?>
另一个问题:用ODBC,代码如下:
<?
$odbcDsn="soccer";
$odbcUser="";
$odbcPass="";
$Conn=odbc_connect($odbcDsn, $odbcUser, $odbcPass);
$sql="select * from player";
$result_id =odbc_do($conn, $sql);
while(odbc_fatch_row($result_id))
{
$AA1 = odbc_result($result_id, 1);
$AA2 = odbc_result($result_id, 2);
echo $AA1." ".$AA2."<br/>\n";
}
odbc_close($conn);
?>
错误如下:
Warning: odbc_do(): supplied argument is not a valid ODBC-Link resource in F:\root\odbc.php on line 7Fatal error: Call to undefined function: odbc_fatch_row() in F:\root\odbc.php on line 8为什么?是不是PHP.INI中还要加入支持ODBC的.DLL文件?
请教高手
<?
$odbcDsn="soccer";
$odbcUser="";
$odbcPass="";
$conn=odbc_connect($odbcDsn, $odbcUser, $odbcPass);
$sql="select * from player";
$result_id=odbc_do($conn,$sql);
while(odbc_fetch_row($result_id))
{
$AA1 = odbc_result($result_id, 1);
$AA2 = odbc_result($result_id, 2);
echo $AA1." ".$AA2."<br/>\n";
}
odbc_close($conn);
?> 如果是我发的贴子,我会自觉给你分,在结贴的;可惜我不是
应该是odbc_fetch_row();