I am accessing DBISAM tables through PHP/ODBTP and the DBISAM ODBC Driver.

I have received the following error:

ODBTP_last error [HY0][11047][Elevate Software][DBISAM] Invalid data type for 'DriverId'

I do not know what this means -- the DBISAM docs say to contact the Technical Suport.

I do know that the error happens infrequently (perhaps three times per month which is
approximately 1 in 1,000 ODBC calls).

When the error does happen, however, it brings my app to a halt, so I would like to
troubleshoot to get it fixed.

Any ideas?

-Ed

Ed,

<< I am accessing DBISAM tables through PHP/ODBTP and the DBISAM ODBC
Driver.

I have received the following error:

ODBTP_last error [HY0][11047][Elevate Software][DBISAM] Invalid data type
for 'DriverId'

I do not know what this means -- the DBISAM docs say to contact the
Technical Suport.

I do know that the error happens infrequently (perhaps three times per
month which is approximately 1 in 1,000 ODBC calls).

When the error does happen, however, it brings my app to a halt, so I would
like to troubleshoot to get it fixed. >>

What version of the ODBC driver ?  In 4.x, I'm not aware of any error with
that actual text.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

From the ODBC Driver Dialogue Box in Windows, the DBISAM Driver is Version 4.24.00.01

Thanks,

Ed







"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

Ed,

<< I am accessing DBISAM tables through PHP/ODBTP and the DBISAM ODBC
Driver.

I have received the following error:

ODBTP_last error [HY0][11047][Elevate Software][DBISAM] Invalid data type
for 'DriverId'

I do not know what this means -- the DBISAM docs say to contact the
Technical Suport.

I do know that the error happens infrequently (perhaps three times per
month which is approximately 1 in 1,000 ODBC calls).

When the error does happen, however, it brings my app to a halt, so I would
like to troubleshoot to get it fixed. >>

What version of the ODBC driver ?  In 4.x, I'm not aware of any error with
that actual text.

--
Tim Young
Elevate Software
www.elevatesoft.com

Ed,

<< From the ODBC Driver Dialogue Box in Windows, the DBISAM Driver is
Version 4.24.00.01 >>

Okay, I finally found the error message - it's a registry error in Delphi's
registry functionality.  However, no where does the stock DBISAM ODBC driver
access a registry key called DriverID.  Has the ODBC driver been modified at
all that you know of ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

Thanks for looking into this -- I was on vacation, so sorry for the late reply.

I simply installed the ODBC driver as downloaded from Elevate -- no modifications whatsoever.

I am not accessing through Delphi, but rather PHP so I don't know how the error message is
being thrown.

There is a Delphi app (a point of sale system) that is running on the same box -- it uses
a customized version of dbsrvr, but, again, I don't see why I am getting this error.

-Ed


"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

Ed,

<< From the ODBC Driver Dialogue Box in Windows, the DBISAM Driver is
Version 4.24.00.01 >>

Okay, I finally found the error message - it's a registry error in Delphi's
registry functionality.  However, no where does the stock DBISAM ODBC driver
access a registry key called DriverID.  Has the ODBC driver been modified at
all that you know of ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Ed,

<< I am not accessing through Delphi, but rather PHP so I don't know how the
error message is being thrown. >>

Are you providing a connection string via PHP to the ODBC connection
functionality ?  If so, what is it ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

I have a DSN configured on the machine and I only pass the DSN within my code.

-Ed

Ed,

<< I have a DSN configured on the machine and I only pass the DSN within my
code. >>

Well, I'm officially out of ideas.

Do you know how to generate an ODBC trace log ?  If so, then turn on tracing
in the ODBC Administrator, perform the actions necessary to reproduce the
problem, turn off tracing in the ODBC Administrator, and then send me the
log.  This should at least give me an idea of where the error is coming
from.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

I will turn on logging and send you the trace when I get an error.

Thanks for your help,

Ed

Ed,

<< I will turn on logging and send you the trace when I get an error. >>

Thanks,

--
Tim Young
Elevate Software
www.elevatesoft.com