[Resolved] odbc_connect issues

ow-phil

Good day all,

I have been working on a php script to pull information from an Access Database into MySQL locally on the webserver. Over the weekend the server (Cobalt RAQ4, running php4, MySQL 3.23.54) was upgraded with MyODBC and was declared by the server guru as being functioning.

HOWEVER...

I am getting an error on the script:

"Fatal error: Call to undefined function: odbc_connect() in /home/sites/home/web/test.php on line 3"

What I think this means is that PHP doesn't know the odbc_connect function. Is this a feature that has to be turned on or something?

The code I am using is:

<?php
$odbc = odbc_connect('testing.mdb','','');
$mysql = mysql_connect('localhost');
mysql_select_db ('testing', $mysql);
mysql_query('delete from testing');
$sql = "select * from testing";
$res = odbc_exec($odbc, $sql);
while (odbc_fetch_into($res,$row)) {
$flds = "'" . join("','" , $row) . "'";
$res1 = mysql_query("INSERT INTO testing VALUES ($flds)");
}

The Access DB is called testing.mdb and has no username or password on it.

Before I close, the situation with having an AccessDB and pulling info into MySQL isnt the Ideal one, I know. However that is the situation I have been left with. 🙁

Phil

Any thoughts on this?

bastien

odbc functions need to be set in the ini file...see here

ow-phil

Our server admin installed ODBC into the ini file. Just finished a minute ago. Thank you for the help. Now I just have to figure out how to define a DSN in PHP.

bastien

<?php

  // Program to test connecting to a Microsoft Access ODBC Data Source
  $connection = odbc_connect("postcard", "", "");
  print "Connected to datasource<BR><BR>";

  if ($result = odbc_exec($connection, "SELECT * FROM postcard"))
    print "Command executed successfully<BR><BR>";
  else
    print "Error while executing command<BR><BR>";

  // Print results
  while(odbc_fetch_row($result))
    print odbc_result($result, 1) . "   " . odbc_result($result, 2) . "   " . odbc_result($result, 3) . "   " . odbc_result($result, 4) . "   " . odbc_result($result, 5) . "<BR>";

  odbc_close($connection);
  print "<BR>Connection closed.";

?>

bastien

hey there,

i think that you may be out of luck trying to set a dsn in linux...this is an ms only product...you could try posting this on a linux forum to see if there is an answer...plus you may not be able to run the access program in the linux os...though WINE might be able to make it go...