odbc-connect error--urgent

•

What is DaniWeb IT Discussion Community?

You're currently browsing the PHP section within the Web Development category of DaniWeb, a massive community of 427,731 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,898 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our PHP advertiser: Lunarpages PHP Web Hosting

Thread Tools Display Modes

Views: 711 | Replies: 3 | Solved

Previous Post in Thread

Next Post in Thread

•

Join Date: Jan 2008

Posts: 26

Reputation: abdulraqeeb33 is an unknown quantity at this point

Rep Power: 1

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>