Jump to content
Sign in to follow this  
Whenever

Access to Database tables not possible

Recommended Posts

Whenever

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

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  

×