[PHPwestoz] MYOB ODBC error

[Daniel Antonic]

On my computer, no I cant. There isnt a simple way to access an accounting v18 database on a machine not running MYOB?

Kind regards, 
Daniel Antonic 
Proprietor DCN Solutions 

Mob: 0438 303 429 
Web: dcnsolutions.net
  ----- Original Message ----- 
  From: Peter Sutter 
  To: phpwestoz at lists.linux.org.au 
  Sent: Friday, May 08, 2009 12:27 AM
  Subject: Re: [PHPwestoz] MYOB ODBC error


  Is the MYOB company file configured for ODBC? Make sure?

  Can you access the MYOB database via ODBC on windows? i.e. via msquery?

  Little Systems has created an Open Source MYOB ODBC Bridge to Linux.
  See: http://www.littlesystems.com.au (Downloads)

  Peter

  On Wednesday 06 May 2009 12:36, Daniel Antonic wrote:
  > Hello all
  >
  > 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.
  >
  > 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:
  >
  > <?php
  > # connect to a DSN "mydb" with a user and password
  >
  > $connect = odbc_connect("test","", "");
  > echo $connect . "<P>";
  > # query the users table for name and surname
  > $query = "SELECT * FROM Employees";
  >
  > # perform the query
  > $result = odbc_exec($connect, $query) or die ("cannot find table");
  >
  > # fetch the data from the database
  > while(odbc_fetch_row($result)){
  >   $name = odbc_result($result, 1);
  >   $surname = odbc_result($result, 2);
  >   print("$name $surname<br>\n");
  > }
  >
  > 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!
  >
  > Kind regards,
  > Daniel Antonic
  > Proprietor DCN Solutions
  >
  > Mob: 0438 303 429
  > Web: dcnsolutions.net

  _______________________________________________
  PHPwestoz mailing list
  PHPwestoz at lists.linux.org.au
  http://lists.linux.org.au/listinfo/phpwestoz
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.linux.org.au/pipermail/phpwestoz/attachments/20090508/ea8189d0/attachment.htm