Someone posting to PHPWestOz? Say it isn't so! :)<br><br>Could you post the error message you're getting from odbc_exec() when it fails please Daniel?<br><br><div class="gmail_quote">2009/5/6 Daniel Antonic <span dir="ltr"><<a href="mailto:daniel@dcnsolutions.net">daniel@dcnsolutions.net</a>></span><br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div bgcolor="#ffffff">
<div><font size="2" face="Arial">Hello all</font></div>
<div><font size="2" face="Arial"></font> </div>
<div><font size="2" face="Arial">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 size="2" face="Arial"></font> </div>
<div><font size="2" face="Arial">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 size="2" face="Arial"></font><font size="2" face="Arial"></font> </div>
<div><font size="2" face="Arial"><?php<br># connect to a DSN "mydb" with a user
and password</font></div>
<div><font size="2" face="Arial"> <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 size="2" face="Arial">
<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>}</div></font></div>
<div><font size="2" face="Arial"></font> </div>
<div><font size="2" face="Arial">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 size="2" face="Arial"></font></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/" target="_blank"><font face="Arial">dcnsolutions.net</font></a></div>
<br>_______________________________________________<br>
PHPwestoz mailing list<br>
<a href="mailto:PHPwestoz@lists.linux.org.au">PHPwestoz@lists.linux.org.au</a><br>
<a href="http://lists.linux.org.au/listinfo/phpwestoz" target="_blank">http://lists.linux.org.au/listinfo/phpwestoz</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>Cheers,<br>Keith<br>Australia is merely an island of Antarctica, and of no further significance.<br>