Skip to Content.
Sympa Menu

freetds - [freetds] error in connecting using odbc

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • 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 ";
}
?>





Archive powered by MHonArc 2.6.24.

Top of Page