<!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>On my computer, no I cant. There isnt a simple way
to access an accounting v18 database on a machine not running MYOB?</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/"><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; font-color: black"><B>From:</B>
<A title=sutterp@sopac.com.au href="mailto:sutterp@sopac.com.au">Peter
Sutter</A> </DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=phpwestoz@lists.linux.org.au
href="mailto:phpwestoz@lists.linux.org.au">phpwestoz@lists.linux.org.au</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, May 08, 2009 12:27 AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [PHPwestoz] MYOB ODBC
error</DIV>
<DIV><BR></DIV>Is the MYOB company file configured for ODBC? Make
sure?<BR><BR>Can you access the MYOB database via ODBC on windows? i.e. via
msquery?<BR><BR>Little Systems has created an Open Source MYOB ODBC Bridge to
Linux.<BR>See: <A
href="http://www.littlesystems.com.au">http://www.littlesystems.com.au</A>
(Downloads)<BR><BR>Peter<BR><BR>On Wednesday 06 May 2009 12:36, Daniel Antonic
wrote:<BR>> Hello all<BR>><BR>> I'm writting a program that will
interface a customer's MYOB database file<BR>> with her web site so that
people can pay online, and it is all recorded in<BR>> her MYOB file
immediately.<BR>><BR>> MYOB Accounting V18 is running in Windows XP Pro,
I have set up a System<BR>> DSN, but PHP just cant see the database. I got
this snippet of code from<BR>> another web site:<BR>><BR>>
<?php<BR>> # connect to a DSN "mydb" with a user and
password<BR>><BR>> $connect = odbc_connect("test","", "");<BR>> echo
$connect . "<P>";<BR>> # query the users table for name and
surname<BR>> $query = "SELECT * FROM Employees";<BR>><BR>> # perform
the query<BR>> $result = odbc_exec($connect, $query) or die ("cannot find
table");<BR>><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>>
}<BR>><BR>> It fails at $result, I put in the DSN name, username and
password in the<BR>> odbc_connect() directive. I really need help on this,
please!<BR>><BR>> Kind regards,<BR>> Daniel Antonic<BR>>
Proprietor DCN Solutions<BR>><BR>> Mob: 0438 303 429<BR>> Web:
dcnsolutions.net<BR><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">http://lists.linux.org.au/listinfo/phpwestoz</A><BR></BLOCKQUOTE></BODY></HTML>