freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: "Rodel P Hipolito" <rhipolito AT ecommsite.com>
- To: "Freetds" <freetds AT lists.ibiblio.org>
- Subject: [freetds] error in connecting using odbc
- Date: Thu, 9 Jan 2003 11:11:56 +0800
Hi guys,
When i tried running the sample connection script below, im getting this
errors: thanks for your help!
===========================================================
Call to undefined function: odbc_connect() in
/usr/local/apache/htdocs/ucarbide/test.php on line 16
===========================================================
===========================================================
Php Script
===========================================================
<?php
putenv("LD_LIBRARY_PATH=/usr/local/src/odbcsdk/lib");
putenv("ODBCINSTINI=/path/to/odbcinst.ini"); //this location will be
determined by your driver install.
putenv("ODBCINI=/path/to/odbc.ini"); //odbc.ini contains your DSNs, location
determined by your driver install.
$dsn="DSN_NAME"; // this is a valid DSN can be tested in odbctest
$user="username";
$password="password";
$sql="SELECT * FROM table"; //replace table with a table name
if ($conn_id=odbc_connect("$dsn","","")){
echo "connected to DSN: $dsn";
if($result=odbc_do($conn_id, $sql)) {
echo "executing '$sql'";
echo "Results: ";
odbc_result_all($result);
echo "freeing result";
odbc_free_result($result);
}else{
echo "can not execute '$sql' ";
}
echo "closing connection $conn_id";
odbc_close($conn_id);
}else{
echo "can not connect to DSN: $dsn ";
}
?>
-
[freetds] error in connecting using odbc,
Rodel P Hipolito, 01/08/2003
- Re: [freetds] error in connecting using odbc, Peter Harvey, 01/08/2003
Archive powered by MHonArc 2.6.24.