<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial, helvetica, sans-serif;font-size:10pt"><DIV></DIV>
<DIV><FONT face=Tahoma size=2>----- Forwarded Message ----<BR><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Daniel Antonic <daniel@dcnsolutions.net><BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> Michael Dorrington <mike@orbitaldesigns.com.au><BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Wednesday, May 6, 2009 8:41:26 PM<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> Re: [PHPwestoz] MYOB ODBC error<BR></FONT><BR>
<STYLE type=text/css>DIV {
MARGIN:0px;}
</STYLE>
</DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif">
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif">
<DIV><FONT face=Arial size=2>Thank you all for the quick response, will post the details as soon as I get a chance to try the driver download (thanks Kim). I havn't got a copy of MYOB on my machine, so it'll take a bit of time. Thanks again for the quick reply!</FONT></DIV>
<DIV><FONT face=Arial size=2><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 rel=nofollow><FONT face=Arial>dcnsolutions.net</FONT></A></FONT></DIV>
<BLOCKQUOTE style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV style="BACKGROUND: #e4e4e4; FONT: 10pt arial"><B>From:</B> <A title=mike@orbitaldesigns.com.au href="mailto:mike@orbitaldesigns.com.au" target=_blank rel=nofollow ymailto="mailto:mike@orbitaldesigns.com.au">Michael Dorrington</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=daniel@dcnsolutions.net href="mailto:daniel@dcnsolutions.net" target=_blank rel=nofollow ymailto="mailto:daniel@dcnsolutions.net">daniel@dcnsolutions.net</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Wednesday, May 06, 2009 2:02 PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Fw: [PHPwestoz] MYOB ODBC error</DIV>
<DIV><BR></DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif">
<DIV></DIV>
<DIV>Does this give you any real message:</DIV>
<DIV> </DIV>
<DIV>$result = odbc_exec($connect, $query) or die (odbc_errormsg($connect));</DIV>
<DIV> </DIV>
<DIV>I've never really done this with myob before, but perhaps you need to give the IIS user permissions to the myob file for reading?</DIV>
<DIV> </DIV>
<DIV>Mike<BR> </DIV><FONT size=1>This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited.</FONT>
<DIV><BR></DIV>
<DIV style="FONT-SIZE: 10pt; FONT-FAMILY: arial, helvetica, sans-serif"><BR>
<DIV style="FONT-SIZE: 12pt; FONT-FAMILY: times new roman, new york, times, serif"><FONT face=Tahoma size=2>----- Forwarded Message ----<BR><B><SPAN style="FONT-WEIGHT: bold">From:</SPAN></B> Daniel Antonic <daniel@dcnsolutions.net><BR><B><SPAN style="FONT-WEIGHT: bold">To:</SPAN></B> phpwestoz@lists.linux.org.au<BR><B><SPAN style="FONT-WEIGHT: bold">Sent:</SPAN></B> Wednesday, May 6, 2009 12:36:56 PM<BR><B><SPAN style="FONT-WEIGHT: bold">Subject:</SPAN></B> [PHPwestoz] MYOB ODBC error<BR></FONT><BR>
<STYLE></STYLE>
<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/" target=_blank rel=nofollow><FONT face=Arial>dcnsolutions.net</FONT></A></FONT></DIV></DIV></DIV></DIV>
<P>
<HR>
<P></P>_______________________________________________<BR>PHPwestoz mailing list<BR>PHPwestoz@lists.linux.org.au<BR>http://lists.linux.org.au/listinfo/phpwestoz<BR></BLOCKQUOTE></DIV></DIV></div></body></html>