<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.6000.16825" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hello all</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I'm writting a program that will interface a
customer's MYOB database file with her web site so that people can pay online,
and it is all recorded in her MYOB file immediately.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>MYOB Accounting V18 is running in Windows XP
Pro, I have set up a System DSN, but PHP just cant see the database. I got this
snippet of code from another web site:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2><?php<BR># connect to a DSN "mydb" with a user
and password</FONT></DIV>
<DIV><FONT face=Arial size=2> <BR>$connect = odbc_connect("test","",
""); <BR>echo $connect . "<P>";<BR># query the users table for name
and surname <BR>$query = "SELECT * FROM Employees";
</FONT></DIV><FONT face=Arial size=2>
<DIV><BR># perform the query <BR>$result = odbc_exec($connect, $query) or
die ("cannot find table"); </DIV>
<DIV><BR># fetch the data from the database
<BR>while(odbc_fetch_row($result)){ <BR> $name =
odbc_result($result, 1); <BR> $surname = odbc_result($result,
2); <BR> print("$name $surname<br>\n");
<BR>}</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>It fails at $result, I put in the DSN name,
username and password in the odbc_connect() directive. I really need help on
this, please!</FONT><FONT face=Arial size=2></DIV>
<DIV><BR><FONT face=Arial>Kind regards, <BR>Daniel Antonic <BR>Proprietor DCN
Solutions <BR><BR>Mob: 0438 303 429 <BR>Web: </FONT><A
href="http://dcnsolutions.net/"><FONT
face=Arial>dcnsolutions.net</FONT></A></FONT></DIV></BODY></HTML>