dbadmin

I thought that 2399 was the ODBC port?

Ok so I tested now the same select w/mySQL and same odbc_exec / odbc_do and it works fine on mySQL, not FMSA7v2 DB Admin

Nope, not writing a ODBC driver, (there are number of companies doing it) but a library of calls as mentioned in the previous post. I did notice it is slow, but for what we are doing it should be good enough. The idea is to modularize and get away from webfm which we were using. Also, i did manage to find a huge that I think is a bug. Beware on selects of 35+ fields. The data disappears. Lec

Another quick q. Where do we submit bugs online, cannot find it on the fm website??. It seems that this version also has a problem with odbc_exec and odbc_do. I have tried this on mySQL and now on fmsa7v2 again with same version of php and mySQL odbc returns the data whereas the filemaker odbc is bugy. DB Admin

I am writing my own PHP library that interfaces to FM7 via ODBC. If anyone is interested in this let me know. I hope to make this eventually publically avaiable. Right now I am interested in folks working together to make it better. Thanks DB Admin

Anyone know where the docs are that tell us what was updated / patched? They are not inside of the zip nor could I find them on the website. Thanks.

So I have ODBC running, and been nicely coding PHP w/odbc, I ran into some minor issues and was able to resolve them, but now I see a bug in the driver or FM. - or so I think - When I perform SELECT name1, name2,...name[N] with odbc_exec I get result but if N > 35, meaning if I select more then 35 columns I get the result in a circular fassion. Values returned for name[36] go into name[1] and so on. This overwrites my values in name[1]... brrr.. Is there a limit on number of columns you can select on? Is this a bug? Basically I cannot select on more then 35 columns, which I despratelly need result for. The browser does not time out don't worry. And I am using PHP 4.3 to accomplish all this with odbc_exec command. Thanks.