How do I connect to an MS Access database?

[reub77]

I'm trying to connect to a MS Access database and am having difficulty doing so. I'm only accustomed to mySQL connections. I have a client that has built an Access database. It has a name ending with the extension .mdb. Inside the database there is a table called "demographics". There isn't any username or password associated with it so it should be pretty straight forward. This is what I tried to type:

<?PHP
function db_connect(){
$myDB = odbc_connect('capd','','');
if(!$myD😎
return(false);
if(!odbc_select_db('capd')){
return(false);
return($myD😎;
}
}
?>

I built the connection as a function to save replicating the same code. Please someone help.

[ereptur]

check out the articles section of this site. there is already a tutorial there on exactly how to do this.

[jimson]

i wrote this last time when i am using Ms ACCess

try this... maybe can help

http://www.geocities.com/jimsonchang/doc_adodb.html

[reub77]

Nothing I've found seems to work. I thought maybe it was because the host server didn't support MS Access and so I installed IIS on my own box. I run XP Professional. I installed it and then moved all the pertinent files into the 'wwwroot' folder and then typed in the url. The page shows up but there is nothing from the database showing. No errors either.

I'm a novice when it comes databases other than mySQL. Please help me.

[jimson]

have u install PHP into ur box?

[reub77]

That would help wouldn't it! I just installed it, I can't believe I didn't think of that! Here's my code:

<?PHP
//$conn = db_connect();
$myDB = odbc_connect('capd','','');

//declare query
$query = "SELECT * FROM Demographics";

//execute query
$result = odbc_exec($myDB, $query);

$x = 0;
while ($x < odbc_fetch_row($result)) :
$lName = odbc_result($result, $x, 'lastName');
$fName = odbc_result($result, $x, 'firstName');
$init = odbc_result($result, $x, 'initial');
$Title = odbc_result($result, $x, 'title');
$desig = odbc_result($result, $x, 'designation');
$pos = odbc_result($result, $x, 'position');
$org = odbc_result($result, $x, 'organization');
$st = odbc_result($result, $x, 'street');
$City = odbc_result($result, $x, 'city');
$prov = odbc_result($result, $x, 'province');
$post = odbc_result($result, $x, 'postal');
$ctry = odbc_result($result, $x, 'country');

print "<tr bgcolor='#FFFFFF'>";
print "<td>$lName</td><td align='center'>$fName</td><td align='center'>$init</td><td>$Title<br>$desig<br>$pos<br>$org<br></td><td>$st</td><td align='center'>$City</td><td align='center'>$prov</td><td align='center'>$post</td>";
print "</tr>";
$x++;
endwhile;
print "</table>";
odbc_close();
?>

Here are my errors:

Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in c:\inetpub\wwwroot\sfpd.php on line 83

Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in c:\inetpub\wwwroot\sfpd.php on line 89

Warning: odbc_fetch_row(): supplied argument is not a valid ODBC result resource in c:\inetpub\wwwroot\sfpd.php on line 92

Warning: Wrong parameter count for odbc_close() in c:\inetpub\wwwroot\sfpd.php on line 112

What is the problem now? It wasn't working on the hosts servers either and so I knew there was a lot of stuff wrong.

[jimson]

if u use my script...
then u have dsnless connection, no need to register in ODBC...