Skip to main content
A
angusfz
Participant
March 29, 2007
Question

Unknow data access error ?

  • March 29, 2007
  • 5 replies
  • 884 views
hi guys, we have a particular problem with cf5 on windows2k box
"Unknow data access error" occurs at times

Any one have the same problem ?
This topic has been closed for replies.

5 replies

A
angusfzAuthor
Participant
April 2, 2007
Dear scooter5791 :
i dont have store produce on my cf5.i haved tried oracle's originally driver,from 9205->9206 ,the problem still cant be resolved, it returned the same error information.I will try to find other drivers for oracle,thanks for ur suggestion .
A
angusfzAuthor
Participant
March 31, 2007
Dear jdeline : in my cf application.log,it just logged "Data Access Error Unknown Data Access Error. SQL =........" ....it's too bad....
and i have tried to run the same code,but it appears functionally. at the same time , i check the database connection,there is nothing error......terrible,,,


Dear scooter5791:my cf5 box has restarted every night for a long time,but the
problem still occured..Now,i am trying to monitor cf' jvm memory status to find out some useful information
i have tried something like above,but the error still happend...
OS:win2k ->win2003
MDAC:2.7 ->2.7refresh->2.8=>2.8sp1
sniffer,NIC driver,network switch..........haha..haha...i am almost crazy...
S
scooter5791
Inspiring
March 31, 2007
This error seems to be just a generic error returned by the database driver - you may try changing drivers and see if the problem goes away or you get a different error message. What db/drivers are you using? Are you calling a stored procedure? If so try doing a straight CFQuery which may give you better error info back. Or try running the stored procedure directly in the database.

I can't tell you anything specific about cf5 and db connections - we went straight from 4.5 to MX 7. But someone here probably could help with that.
A
Anonymous
March 30, 2007
Do your ColdFusion and Java logs have anything useful in them?
S
scooter5791
Inspiring
March 30, 2007
I can tell you that when we were running cf 4.5 (not that long ago actually) we had a scheduled task to restart the cf services every night on our production boxes to avoid the memory leak issues. We did this for so long that I can't remember what types of errors we got prior to that - but I do know that we didn't get them any more after putting this procedure in place. I don't know if cf 5 suffers from the same sort of issue or not.
A
angusfzAuthor
Participant
March 30, 2007
edbrendel thanks for ur reply

here is the information

1,DB:oracle 9i
2,no stored procedures
3,DB Driver:9205(oracle net manager)
4,no
5,MDAC 2.8sp1
no stored procedures

i have check all google pages about the "Unknow data access error"
someone figure out that may caused by memory leak or cflok else

any suggestion will be appriciated

E
edbrendel
Participating Frequently
March 29, 2007
A few questions:

What database are you using? Is this happening when using stored procedures? What driver do you connect with? Does the problem go away when you use an ODBC driver? What version of MDAC are you on?

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices