Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 6 of 6 total
Thread DBISAM ODBC driver issue in Acrobat 9 running Windows 7
Mon, Dec 3 2012 2:36 AMPermanent Link

Marty

For a number of years I have been using the DBISAM ODBC driver (file version 4.27.0.4) along with Acrobat ADBC connectivity driver to import as well as export data to/from DBISAM tables for assigning/exporting values to/from Acrobat form fields in using Acrobat versions 6 through 9 in Windows XP. Everything seemed to be working just fine until I recently upgraded to Windows 7. The issue appears to be related to my SQL whereby I am no longer able to insert/delete records to/from my DBISAM tables from inside Acrobat as I was able to do in using Windows XP. What's puzzling is that I am still able to open and view table data for populating my drop down form fields inside Acrobat 9 in Windows 7. Since Acrobat 9 is supposed to be compatible with Windows 7, I'm just wondering if there are any SQL compatibility issues in using the DBISAM ODBC driver version 4.27 in Windows 7. I for one would really like to be able to get this to work again but I obviously don't want to waste time if there exist compatibility issues in using the DBISAM ODBC driver in Windows 7. Any comments or suggestions regarding this issue are most appreciated.
Mon, Dec 3 2012 2:51 AMPermanent Link

Marty

Marty wrote:

For a number of years I have been using the DBISAM ODBC driver (file version 4.27.0.4) along with Acrobat ADBC connectivity driver to import as well as export data to/from DBISAM tables for assigning/exporting values to/from Acrobat form fields in using Acrobat versions 6 through 9 in Windows XP. Everything seemed to be working just fine until I recently upgraded to Windows 7. The issue appears to be related to my SQL whereby I am no longer able to insert/delete records to/from my DBISAM tables from inside Acrobat as I was able to do in using Windows XP. What's puzzling is that I am still able to open and view table data for populating my drop down form fields inside Acrobat 9 in Windows 7. Since Acrobat 9 is supposed to be compatible with Windows 7, I'm just wondering if there are any SQL compatibility issues in using the DBISAM ODBC driver version 4.27 in Windows 7. I for one would really like to be able to get this to work again but I obviously don't want to waste time if there exist compatibility issues in using the DBISAM ODBC driver in Windows 7. Any comments or suggestions regarding this issue are most appreciated.

Oh, I also forgot to mention that I am no longer able to edit tables using the DBISAM Database System Utility running inside Windows 7 as the menu items I once used to add, edit or delete records now appear to be disabled or grayed out. Hence, this would give reason to the SQL behavior described above in my not being able to insert/delete records to/from my DBISAM tables. While the answer is probably starring me right in the face, it continues to elude me. Please Help if you can.
Mon, Dec 3 2012 8:44 AMPermanent Link

Raul

Team Elevate Team Elevate

Marty,

DBSYS does allows editing of the tables in Win7 in general.

However if the file/folder permissions do not allow editing then dbsys
switches to read-only mode - my first guess would be to check the
file/folder permissions on where the dbisam files are (especially if
they are in "c:\program files\..." as that is definitely read only by
default.

Raul



On 12/3/2012 2:51 AM, Marty wrote:
> Marty wrote:
>
> For a number of years I have been using the DBISAM ODBC driver (file version 4.27.0.4) along with Acrobat ADBC connectivity driver to import as well as export data to/from DBISAM tables for assigning/exporting values to/from Acrobat form fields in using Acrobat versions 6 through 9 in Windows XP. Everything seemed to be working just fine until I recently upgraded to Windows 7. The issue appears to be related to my SQL whereby I am no longer able to insert/delete records to/from my DBISAM tables from inside Acrobat as I was able to do in using Windows XP. What's puzzling is that I am still able to open and view table data for populating my drop down form fields inside Acrobat 9 in Windows 7. Since Acrobat 9 is supposed to be compatible with Windows 7, I'm just wondering if there are any SQL compatibility issues in using the DBISAM ODBC driver version 4.27 in Windows 7. I for one would really like to be able to get this to work again but I obviously don't want to waste time if there
exist compatibility issues in using the DBISAM ODBC driver in Windows 7. Any comments or suggestions regarding this issue are most appreciated.
>
> Oh, I also forgot to mention that I am no longer able to edit tables using the DBISAM Database System Utility running inside Windows 7 as the menu items I once used to add, edit or delete records now appear to be disabled or grayed out. Hence, this would give reason to the SQL behavior described above in my not being able to insert/delete records to/from my DBISAM tables. While the answer is probably starring me right in the face, it continues to elude me. Please Help if you can.
>
Thu, Dec 13 2012 4:53 PMPermanent Link

Marty

Thank you for the reply. While I had full control under Adm/User I didn't realize that I also needed to change permissions to full control under 'users' which resolved this particular issue. Only other problem I'm having has to do with my deleting a record/row from one of my three DBISAM tables whereby the SQL fails to execute on my first attempt but does so on my 2nd attempt in deleting the selected row. Ironically, this behavior only occurs with one table and not the other two when deleting a record/row. Since the error generated is from inside Acrobat which merely states 'General operation failed' when the SQL statement failes to execute from inside my Acrobat app, I don't know whether this error is due to Acrobat ADBC, Windows 7 or DBISAM ODBC. Funny thing is I never experienced this behavior when I was running Windows XP. While Acrobat has deprecated the use of their ADBC connection object in Acrobat version 10, it's still supposed to be functional inside Acrobat 9. All said, any further comments or suggestions regarding this subject matter are most appreciated.

Raul wrote:

Marty,

DBSYS does allows editing of the tables in Win7 in general.

However if the file/folder permissions do not allow editing then dbsys
switches to read-only mode - my first guess would be to check the
file/folder permissions on where the dbisam files are (especially if
they are in "c:\program files\..." as that is definitely read only by
default.

Raul



On 12/3/2012 2:51 AM, Marty wrote:
> Marty wrote:
>
> For a number of years I have been using the DBISAM ODBC driver (file version 4.27.0.4) along with Acrobat ADBC connectivity driver to import as well as export data to/from DBISAM tables for assigning/exporting values to/from Acrobat form fields in using Acrobat versions 6 through 9 in Windows XP. Everything seemed to be working just fine until I recently upgraded to Windows 7. The issue appears to be related to my SQL whereby I am no longer able to insert/delete records to/from my DBISAM tables from inside Acrobat as I was able to do in using Windows XP. What's puzzling is that I am still able to open and view table data for populating my drop down form fields inside Acrobat 9 in Windows 7. Since Acrobat 9 is supposed to be compatible with Windows 7, I'm just wondering if there are any SQL compatibility issues in using the DBISAM ODBC driver version 4.27 in Windows 7. I for one would really like to be able to get this to work again but I obviously don't want to waste time if there
exist compatibility issues in using the DBISAM ODBC driver in Windows 7. Any comments or suggestions regarding this issue are most appreciated.
>
> Oh, I also forgot to mention that I am no longer able to edit tables using the DBISAM Database System Utility running inside Windows 7 as the menu items I once used to add, edit or delete records now appear to be disabled or grayed out. Hence, this would give reason to the SQL behavior described above in my not being able to insert/delete records to/from my DBISAM tables. While the answer is probably starring me right in the face, it continues to elude me. Please Help if you can.
>
Thu, Dec 13 2012 4:57 PMPermanent Link

Marty

Raul,

Thank you for the reply. While I had full control under Adm/User I didn't realize that I also needed to change permissions to full control under 'users' which resolved this particular issue. Only other problem I'm having has to do with my deleting a record/row from one of my three DBISAM tables whereby the SQL fails to execute on my first attempt but does so on my 2nd attempt in deleting the selected row. Ironically, this behavior only occurs with one table and not the other two when deleting a record/row. Since the error generated is from inside Acrobat which merely states 'General operation failed' when the SQL statement fails to execute from inside my Acrobat app, I don't know whether this error is due to Acrobat ADBC, Windows 7 or DBISAM ODBC. Funny thing is I never experienced this behavior when I was running Windows XP. While Acrobat has deprecated the use of their ADBC connection object in Acrobat version 10, it's still supposed to be functional inside Acrobat 9. All said, any further comments or suggestions regarding this subject matter are most appreciated.

Raul wrote:

Marty,

DBSYS does allows editing of the tables in Win7 in general.

However if the file/folder permissions do not allow editing then dbsys
switches to read-only mode - my first guess would be to check the
file/folder permissions on where the dbisam files are (especially if
they are in "c:\program files\..." as that is definitely read only by
default.

Raul



On 12/3/2012 2:51 AM, Marty wrote:
> Marty wrote:
>
> For a number of years I have been using the DBISAM ODBC driver (file version 4.27.0.4) along with Acrobat ADBC connectivity driver to import as well as export data to/from DBISAM tables for assigning/exporting values to/from Acrobat form fields in using Acrobat versions 6 through 9 in Windows XP. Everything seemed to be working just fine until I recently upgraded to Windows 7. The issue appears to be related to my SQL whereby I am no longer able to insert/delete records to/from my DBISAM tables from inside Acrobat as I was able to do in using Windows XP. What's puzzling is that I am still able to open and view table data for populating my drop down form fields inside Acrobat 9 in Windows 7. Since Acrobat 9 is supposed to be compatible with Windows 7, I'm just wondering if there are any SQL compatibility issues in using the DBISAM ODBC driver version 4.27 in Windows 7. I for one would really like to be able to get this to work again but I obviously don't want to waste time if there
exist compatibility issues in using the DBISAM ODBC driver in Windows 7. Any comments or suggestions regarding this issue are most appreciated.
>
> Oh, I also forgot to mention that I am no longer able to edit tables using the DBISAM Database System Utility running inside Windows 7 as the menu items I once used to add, edit or delete records now appear to be disabled or grayed out. Hence, this would give reason to the SQL behavior described above in my not being able to insert/delete records to/from my DBISAM tables. While the answer is probably starring me right in the face, it continues to elude me. Please Help if you can.
>
Tue, Jan 8 2013 12:06 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Marty,

<< Thank you for the reply. While I had full control under Adm/User I didn't
realize that I also needed to change permissions to full control under
'users' which resolved this particular issue. Only other problem I'm having
has to do with my deleting a record/row from one of my three DBISAM tables
whereby the SQL fails to execute on my first attempt but does so on my 2nd
attempt in deleting the selected row. Ironically, this behavior only occurs
with one table and not the other two when deleting a record/row. Since the
error generated is from inside Acrobat which merely states 'General
operation failed' when the SQL statement failes to execute from inside my
Acrobat app, I don't know whether this error is due to Acrobat ADBC, Windows
7 or DBISAM ODBC. Funny thing is I never experienced this behavior when I
was running Windows XP. While Acrobat has deprecated the use of their ADBC
connection object in Acrobat version 10, it's still supposed to be
functional inside Acrobat 9. All said, any further comments or suggestions
regarding this subject matter are most appreciated. >>

The best way to figure out what is going on is to use the ODBC trace
facilities.  Do you know how to turn on ODBC tracing ?

Tim Young
Elevate Software
www.elevatesoft.com
Image