need help for connecting the db in php

[BigZero]

hello i m new to php
i m working on project that has interface with simple html and php i m
thinking to use
i got some problem with the connecting to DB here is the code for
connecting db

$db = "Snmp_Dba";
// $connection_id = odbc_connect_custom($db);
$db_connection = odbc_connect("DRIVER={Microsoft Access Driver
(*.mdb)}; DBQ=$db", "ADODB.Connection", "", "SQL_CUR_USE_ODBC");
// $query = "SELECT * FROM System_Master";
//$result_id = odbc_exec($connection_id,$query);
$result = odbc_tables($db_connection);
while (odbc_fetch_row($result)) {
if(odbc_result($result,"TABLE_TYPE")=="TABLE") {
echo "<br />" . odbc_result($result,"TABLE_NAME");
?>
by doing this i got error in ie as follows

Parse error: parse error in c:\program files\easyphp1-8\www\search.php
on line 25

any body help me to slove this problem

Thanks
Vijay

[Jerry Stuckle]

BigZero wrote:

hello i m new to php
i m working on project that has interface with simple html and php i m
thinking to use
i got some problem with the connecting to DB here is the code for
connecting db

$db = "Snmp_Dba";
// $connection_id = odbc_connect_custom($db);
$db_connection = odbc_connect("DRIVER={Microsoft Access Driver
(*.mdb)}; DBQ=$db", "ADODB.Connection", "", "SQL_CUR_USE_ODBC");
// $query = "SELECT * FROM System_Master";
//$result_id = odbc_exec($connection_id,$query);
$result = odbc_tables($db_connection);
while (odbc_fetch_row($result)) {
if(odbc_result($result,"TABLE_TYPE")=="TABLE") {
echo "<br />" . odbc_result($result,"TABLE_NAME");
?>
by doing this i got error in ie as follows

Parse error: parse error in c:\program files\easyphp1-8\www\search.php
on line 25

any body help me to slove this problem

Thanks
Vijay

Which is line 25?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[Roger]

On Apr 26, 7:05*am, BigZero <[e-mail]:

hello i m new to php
i m working on project that has interface with simple html and php i m
thinking to use
i got some problem with the connecting to DB here is the code for
connecting db

$db = "Snmp_Dba";
* // *$connection_id = odbc_connect_custom($db);
$db_connection = odbc_connect("DRIVER={Microsoft Access Driver
(*.mdb)}; DBQ=$db", "ADODB.Connection", "", "SQL_CUR_USE_ODBC");
* *// $query * * * * = "SELECT * FROM System_Master";
* * //$result_id * * = odbc_exec($connection_id,$query);
$result = odbc_tables($db_connection);
while (odbc_fetch_row($result)) {
* * if(odbc_result($result,"TABLE_TYPE")=="TABLE") {
* * * * echo "<br />" . odbc_result($result,"TABLE_NAME");
?>

by doing this i got error in ie as follows

Parse error: parse error in c:\program files\easyphp1-8\www\search.php
on line 25

any body help me to slove this problem

Thanks
Vijay

I think this
$db_connection = odbc_connect("DRIVER={Microsoft Access Driver
(*.mdb)}; DBQ=$db", "ADODB.Connection", "", "SQL_CUR_USE_ODBC");

needs to be this
$db_connection = odbc_connect("DRIVER={Microsoft Access Driver
(*.mdb)}; DBQ=" . $db, "ADODB.Connection", "", "SQL_CUR_USE_ODBC");

[BigZero]

Thanks
i got solution for that,
i chabged UserDsn to SystemDSN setting in control panel

and all did change in code is
$con = odbc_connect('MSAccessDriver','','');

any way thanks
Regards
Vijay