Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 4 of 4 total
Thread ODBC Error
Sat, Nov 25 2006 12:52 AMPermanent 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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 PMPermanent 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 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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

Image