Sign in to follow this  
Followers 0
Whenever

Access to Database tables not possible

2 posts in this topic

Hello,

my problem this time is that I am trying to access data from a database, what happens is that I have an account with full permission to the database but yet I cannot access all database tables, my error handler keeps showing me the same messages which are the following: 

 

==> COM Error intercepted !
err.number is: 0x80020009
err.windescription: Exception occurred.
 
err.description is: Driver]You have no access to form. Overview_DB
err.source is: Microsoft OLE DB Provider for ODBC Drivers
err.helpfile is:
err.helpcontext is: 0
err.lastdllerror is: 0
err.scriptline is: 329
err.retcode is: 0x80004005
 
 
==> COM Error intercepted !
err.number is: 0x80020009
err.windescription: Exception occurred.
 
err.description is: Driver][iSAM]No data found
err.source is: Microsoft OLE DB Provider for ODBC Drivers
err.helpfile is:
err.helpcontext is: 0
err.lastdllerror is: 0
err.scriptline is: 329
err.retcode is: 0x80004005
 
I have checked the database connection which is working perfectly, I also checked the queries I use, they are copied from a previous project and should work as expected. here are the queries i use:
 
;$query = "SELECT SUM(GIEIST) FROM WOCapacity WHERE Workcenter<60" ; No access to form
$query = "SELECT Auftrag FROM Work" ; No data found although data exists
;$query = "SELECT SUM(IEist) FROM Overview_DB WHERE WorkCenter<60 and  IEist is not NULL" ; No access to form
;$query = "SELECT Artext FROM PriceList" ;shows data correctly
 
Those are a few example queries I made just to see if anything works.
 
I hope you can help me with it. 

 

Share this post


Link to post
Share on other sites



What database are you using? Post your code for authenticating to the database.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0