Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM ODBC Driver » View Thread |
Messages 1 to 4 of 4 total |
ODBC Error |
Sat, Nov 25 2006 12:52 AM | Permanent Link |
Ed Blackburne | I need to query my database through a php interface (refer to
http://www.elevatesoft.com/scripts/newsgrp.dll?action=openmsg&group=14&msg=903&page=4 ) Since there is not, nor will likely ever be, an sort of linux driver for DBISAM tables, I have successfully installed odbtp (linux client and win server) and built and installed php extensions. HOORAY!!! -- I can query my DBISAM tables from a php script running through apache2 on my linux box. To date, I have been using Ms Access and the DBISAM 4 ODBC Driver to query my tables. These tables are sitting on a Samba share on my linux box and I have no problems (Well, not exactly. I did post http://www.elevatesoft.com/scripts/newsgrp.dll?action=openmsg&group=14&msg=1379&page=1 and I have fixed the problem. It turns out that my router only had ports 137-138 rather than the required 137-139 open for Samba. As unlikely as it seems, the only problems I noticed is with "disappearing tables" as mentioned above. That is strange because I use the Samba Server with Quickbooks, etc with no known problems...but I digress) What I CAN'T do.... Get the PHP script through odbtp to work when the files are sitting on my linux box (samba share). I have, of course, updated the DSN accordingly. I have checked, and rechecked, file permissions. The DSN works in other apps. The specific error I get is Warning: [42S02][11010][Elevate Software][DBISAM] DBISAM Engine Error # 11010 Table or backup file 'ActivityLog' does not exist in /var/www/ipc/phpinfo.php on line 13 Again, what works: If I copy the ActivityLog table to the same machine as the Windows odbtp server (and change the DSN to point to the new location) I am able to execute the query with no errors. I had read that sometimes windows responds better to mapped drives versus unc paths -- I have tried both with no success. Any ideas? I must be missing something simple. I have cross-listed this message on the odbtp forum, but I was wondering if there was anything I need to do to allow an odbc bridge to work? |
Mon, Nov 27 2006 1:19 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Ed,
<< The specific error I get is Warning: [42S02][11010][Elevate Software][DBISAM] DBISAM Engine Error # 11010 Table or backup file 'ActivityLog' does not exist in /var/www/ipc/phpinfo.php on line 13 Again, what works: If I copy the ActivityLog table to the same machine as the Windows odbtp server (and change the DSN to point to the new location) I am able to execute the query with no errors. >> This sounds like a simple matter of either Samba access not working properly or there being a user rights issue with respect to "seeing" the tables. -- Tim Young Elevate Software www.elevatesoft.com |
Mon, Nov 27 2006 3:18 PM | Permanent Link |
Ed Blackburne | Tim,
Thank you and the problem is fixed. As it turns out the ODBC bridge service was running under local system priveleges which did not have rights to the network share. I am now able to query the tables. For curiosity's sake: What would be required to get Linux odbc drivers made -- is this an impossibility? Would any of the Open Source projects be able to? Thank you, Ed "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote: Ed, << The specific error I get is Warning: [42S02][11010][Elevate Software][DBISAM] DBISAM Engine Error # 11010 Table or backup file 'ActivityLog' does not exist in /var/www/ipc/phpinfo.php on line 13 Again, what works: If I copy the ActivityLog table to the same machine as the Windows odbtp server (and change the DSN to point to the new location) I am able to execute the query with no errors. >> This sounds like a simple matter of either Samba access not working properly or there being a user rights issue with respect to "seeing" the tables. -- Tim Young Elevate Software www.elevatesoft.com |
Tue, Nov 28 2006 11:53 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Ed,
<< For curiosity's sake: What would be required to get Linux odbc drivers made -- is this an impossibility? Would any of the Open Source projects be able to? >> We could probably do one using Kylix with no problem. However, the issue is time vs. return. Since we've offered Kylix versions of DBISAM, our Linux sales have not been particularly robust. That may have something to do with Kylix being left out in the wilderness by Borland, so it might be worth our while to revisit a straight-up ODBC driver for Linux that would target other non-Borland developers on Linux. The main parts that require porting are the configuration forms and any MS ODBC-specific parts such as the registry access. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Wednesday, March 27, 2024 at 05:29 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |