PDA

View Full Version : [ubuntu] odbc and ms access on ubuntu 9.4



snake_eyes
May 14th, 2009, 09:11 PM
Hello,

I just prepared the server installed odbc, I configured the the required files as well , and here is the result:


+---------------------------------------+
| Connected! |
| |
| sql-statement |
| help [tablename] |
| quit |
| |
+---------------------------------------+
SQL> select * from table;


now I made some small php code:



$conn = odbc_connect("DSN","","");
$select = "SELECT * FROM TABLE";
$result = odbc_exec($conn, $select);
while ($row = odbc_fetch_array($result))
{
$rowid = $row['name1'];
$pwd = $row['password'];
}
echo "Row id :".$rowid;
echo "password : ".$pwd;


now I'm facing a problem with I browse the file it download and ask me to save or open it, although the other projects with php and mysql are working fine.

Any idea gentleman?

Cheers,

snake_eyes
May 15th, 2009, 01:21 PM
anybody there gentleman?