[PHPwestoz] MYOB ODBC error

[Kim Richardson]

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