Access to Database tables not possible

[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. 

 

[Danp2]

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