Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM ODBC Driver » View Thread |
Messages 1 to 6 of 6 total |
DBISAM ODBC driver issue in Acrobat 9 running Windows 7 |
Mon, Dec 3 2012 2:36 AM | Permanent 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 AM | Permanent 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 AM | Permanent Link |
Raul 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 PM | Permanent 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 PM | Permanent 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 |
This web page was last updated on Saturday, April 27, 2024 at 08:52 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |