Hello,

I was wondering if there is a way to get PHP to play nice with MAS200. I setup an ODBC connection to the mas200 database and successfully connected but I cannot read any tables. Here is my code:

<?php
$conn = odbc_connect('mas200','user','password') or die("cannot connect");

$query = "SELECT * FROM W02_WorkOrderMaterialDetail";

$result = odbc_exec($conn, $query) or die();
?>

and here is the error I am getting

Warning: odbc_exec() [function.odbc-exec]: SQL error: [ProvideX][ODBC Driver][FILEIO]Table is not accessible, SQL state S0000 in SQLExecDirect in C:\wamp\www\test\mas200.php on line 6

So the script is connecting I just cant query anything. The script is running on a PC separate from mas200. If anyone could help I would appreciate it. Thank you.

    Write a Reply...