[PHPwestoz] MYOB ODBC error

[Daniel Antonic]

Just so you know, I did set up the  correct DSN/Username etc. for the MYOB datafile in question (Administrator etc.)

Kind regards, 
Daniel Antonic 
Proprietor DCN Solutions 

Mob: 0438 303 429 
Web: dcnsolutions.net
  ----- Original Message ----- 
  From: Daniel Antonic 
  To: PHP users in Western Australia (or nearby) 
  Sent: Thursday, May 07, 2009 9:50 PM
  Subject: Re: [PHPwestoz] MYOB ODBC error


  I tried the link (http://myobaustralia.custhelp.com/cgi-bin/myobaustralia.cfg/php/enduser/std_adp.php?p_faqid=30548) but that driver doesn't work with the data file of my customer (or any other that I got my hands on!) I installed that driver on my development machine which is Windows XP Pro, no other installation of MYOB.

  I get a 'cannot find table' error on the code that I was using on my client's machine (Windows PX Pro, MYOB Accounting Plus v18):

  <?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");  
  }
  ?>

  When getting the raw output of the $results variable, I get a boolean(NULL) result. Does that mean the DSN isn't setup correctly?


  Kind regards, 
  Daniel Antonic 
  Proprietor DCN Solutions 

  Mob: 0438 303 429 
  Web: dcnsolutions.net
    ----- Original Message ----- 
    From: Kim Richardson 
    To: PHP users in Western Australia (or nearby) 
    Sent: Wednesday, May 06, 2009 2:03 PM
    Subject: Re: [PHPwestoz] MYOB ODBC error


    I've done this previously before and from memory we had to get a MYOB
    ODBC driver to create the DSN.

    I think you can get it from here.

    http://myobaustralia.custhelp.com/cgi-bin/myobaustralia.cfg/php/enduser/std_adp.php?p_faqid=30548

    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 <http://dcnsolutions.net/>
    > ------------------------------------------------------------------------
    >
    > _______________________________________________
    > PHPwestoz mailing list
    > PHPwestoz at lists.linux.org.au
    > http://lists.linux.org.au/listinfo/phpwestoz
    >   

    -- 
    ---------------
    Kim Richardson
    Web Applications Developer
    Viewdale IT
    Tel: 1300 799 516 - Fax: (07) 3319 8932
    http://www.ausnix.com.au


    _______________________________________________
    PHPwestoz mailing list
    PHPwestoz at lists.linux.org.au
    http://lists.linux.org.au/listinfo/phpwestoz



------------------------------------------------------------------------------


  _______________________________________________
  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/20090507/8c68e152/attachment.htm