DaniWeb Forum Index > Web Development > PHP

odbc-connect error--urgent

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Jan 2008

Posts: 26

Reputation: abdulraqeeb33 is an unknown quantity at this point

Solved Threads: 0

abdulraqeeb33 abdulraqeeb33 is offline

Offline

Light Poster

odbc-connect error--urgent

Apr 24th, 2008

Warning: odbc_connect() [function.odbc-connect]: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in C:\xampp\htdocs\xampp\display.php on line 5
Connection Failed:

php is working fine, ran other simple php scripts...
but this is the error when i connect to a ms access db

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<html>
<body>
 
<?php
$conn=odbc_connect("DB",'','');
if (!$conn)
  {exit("Connection Failed: " . $conn);}
$sql="SELECT * FROM customers";
$rs=odbc_exec($conn,$sql);
if (!$rs)
  {exit("Error in SQL");}
echo "<table><tr>";
echo "<th>IP</th>";
echo "<th>MAC</th></tr>";
while (odbc_fetch_row($rs))
{
  $name=odbc_result($rs,"ip");
  $macname=odbc_result($rs,"mac");
  echo "<tr><td>$name</td>";
  echo "<td>$macname</td></tr>";
}
odbc_close($conn);
echo "</table>";
?>
 
</body>
</html>
<html>
<body>

<?php
$conn=odbc_connect("DB",'','');
if (!$conn)
  {exit("Connection Failed: " . $conn);}
$sql="SELECT * FROM customers";
$rs=odbc_exec($conn,$sql);
if (!$rs)
  {exit("Error in SQL");}
echo "<table><tr>";
echo "<th>IP</th>";
echo "<th>MAC</th></tr>";
while (odbc_fetch_row($rs))
{
  $name=odbc_result($rs,"ip");
  $macname=odbc_result($rs,"mac");
  echo "<tr><td>$name</td>";
  echo "<td>$macname</td></tr>";
}
odbc_close($conn);
echo "</table>";
?>

</body>
</html>

the dsn exists and i have selected a db which has the table clients_online and other fields such as ip and mac exist

Last edited by peter_budo; Apr 26th, 2008 at 8:20 am. Reason: Keep It Organized - please use [code] tags

•

Join Date: Feb 2007

Posts: 1,614

Reputation: scru has a spectacular aura about

Solved Threads: 131

scru

Offline

Posting Virtuoso

Re: odbc-connect error--urgent

Apr 24th, 2008

Are you sure it is a system dsn and not a user dsn? You must you the system tab in ODBC in the Administrative Tools to set up a system dsn.

HTH

•

Join Date: Jan 2008

Posts: 26

Reputation: abdulraqeeb33 is an unknown quantity at this point

Solved Threads: 0

abdulraqeeb33 abdulraqeeb33 is offline

Offline

Light Poster

Re: odbc-connect error--urgent

Apr 25th, 2008

oh thanks, i changed it to a system dsn now...
but i get this error msg

Warning: odbc_connect() [function.odbc-connect]: SQL error: Failed to fetch error message, SQL state HY000 in SQLConnect in C:\xampp\htdocs\xampp\display.php on line 5
Connection Failed:

program being this

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
<html>
<body>
 
<?php
$conn=odbc_connect('data','','');
if (!$conn)
  {exit("Connection Failed: " . $conn);}
$sql="SELECT * FROM clients_online";
$rs=odbc_exec($conn,$sql);
if (!$rs)
  {exit("Error in SQL");}
echo "<table><tr>";
echo "<th>ip</th>";
echo "<th>mac</th></tr>";
while (odbc_fetch_row($rs))
{
  $compname=odbc_result($rs,"ip");
  $conname=odbc_result($rs,"mac");
  echo "<tr><td>$compname</td>";
  echo "<td>$conname</td></tr>";
}
odbc_close($conn);
echo "</table>";
?>
 
</body>
</html>
<html>
<body>

<?php
$conn=odbc_connect('data','','');
if (!$conn)
  {exit("Connection Failed: " . $conn);}
$sql="SELECT * FROM clients_online";
$rs=odbc_exec($conn,$sql);
if (!$rs)
  {exit("Error in SQL");}
echo "<table><tr>";
echo "<th>ip</th>";
echo "<th>mac</th></tr>";
while (odbc_fetch_row($rs))
{
  $compname=odbc_result($rs,"ip");
  $conname=odbc_result($rs,"mac");
  echo "<tr><td>$compname</td>";
  echo "<td>$conname</td></tr>";
}
odbc_close($conn);
echo "</table>";
?>

</body>
</html>