|
|
Posted by google on 07/06/07 21:16
On Jul 6, 9:29 am, "Richard" <root@localhost> wrote:
> Hi JPB,
> I read the "Table access error" as: there is something wrong with accessing
> the table you specify, not necesarily that the table doesnt exist... could
> also be a permissions problem, or a lot of other things.
The driver in question has always struck me as being a bit on the
primitive side. From what I can discern, access control is only due to
file read/write file system settings (in this case Windows 2000).
> As stated by someone else in this thread:
> On line 51 it says dbname, but this is of course tablename I hope?
Funny that you spotted that... it was, indeed a table name reference.
One of the things that's always bugged me about ANGOSS and SmartWare
is that they do not use the terms 'database' and 'table' in an
industry-standard manner.
To them, a single table resides in a single file (along with seperate
key and view files, which they then call a 'database'. In their
usage, a 'table' is part of a custom view - a linked table, usually
with a one-to-many relationship which is then rendered in a literally
tabular fashion.
In terms of their ODBC driver, they treat a single directory
containing many 'databases' as other servers would treat a database
and a many tables within that database.
Sometimes I mix & match my usage of the terminology. Sloppy, I
admit.
> Does the webserver have permission to access the database? Do you need to
> specify the allowed hosts anywhere (as in MySQL)? Maybe the hostname is
> reported differently when running from the IIS. Or not at all.
As far as I can tell, the server, running as LocalSystem, has read/
write access to the the database directory.
> Can you turn on error logging for the ODBC so you can see whats going on?
Tried that... I never managed to generate a log file. I may have
simply misplaced it, but I thought I set the paths correctly.
> What does ANGOSS docs say about this specific error?
The docs I have are kinda thin on the errors - especially ODBC-
related ones.
> Good luck,
> Richard
Thanks for the wishes and the questions.
-Joe
Navigation:
[Reply to this message]
|