[PHPwestoz] MYOB ODBC error

[Keith Moss]

Someone posting to PHPWestOz? Say it isn't so! :)

Could you post the error message you're getting from odbc_exec() when it
fails please Daniel?

2009/5/6 Daniel Antonic <daniel at dcnsolutions.net>

>  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
>
>


-- 
Cheers,
Keith
Australia is merely an island of Antarctica, and of no further significance.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.linux.org.au/pipermail/phpwestoz/attachments/20090506/b9952a72/attachment.htm