ODBC problems

Coz

I am trying to connect to an Access database using the following script:

<html>
<body BGCOLOR="EEEEEE">
<?php
//we don't need a username & password.
//connect to a DSN called NDB with no username or password
$connect = odbc_connect("NDB","","" );
print_r($connect);
if (!$connect) {
echo "Connection failed";
exit;

};

else {
     echo "Connection  successful";
     };

odbc_close( $connect);
?>
</BODY>

</HTML>

However when I execute this script I just get a grey html screen. It does not even print out the $connect variable. Does any1 have any suggestions on what to look at, I have been struggling with this for over a week.

eoghain

Is your Web Server setup to parse this correctly?

Coz

I am using the Apache server 2.0.43, when I goto http://localhost it says the server is set up correctly. However I have to start apache in a command window first. I am trying to get everything working on my computer locally first. I have not made any changes to the apache files

eoghain

When I ask about the setup I mean is PHP installed properly and what extensions is Apache sending to the PHP interpreter? A standard PHP setup sends .php files to the PHP interpreter, somtimes .php3 is also sent. If these are setup correctly is the file you are trying to run named something.php? Cause what you are describing is that you are only getting the html back from accessing the page, and this would happen if Apache didn't know where it send the page. And the <?php ?> tags would get ignored.

Tracer

I have had this problem....Make sure that your ODBC driver is setup as SYSTEM. Also on windows, make sure that your apache service has sufficient priveleges to access the odbc driver. By default apache installs as a LOCAL ONLY account and you will have no network acess, so if you have your access db on another computer=no connection.

Coz

After doing some more research I downloaded the OpenSA package and started making some progress. Here is the error I am getting when I run my script:

Warning: SQL error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified, SQL state IM002 in SQLConnect in c:\opensa\apache\htdocs\database\input.php on line 8

line 8 is this line:
$connect = odbc_connect("NDB","","" );

Any tips?

Chris

Coz

WOO-HOO, got it working. I deleted the system dsn and re-made it and it worked! Thanks for all who helped, this forum is great.

Chris