J
JDA
My problem: When I filter by adding records one date at a time i.e.
#9/1/2004#, the query works fine. When I try to filter the date by any other
means i.e. "Between #9/1/2004# and #9/30/2004#" or >#9/1/2004#, etc. the DB
sits for awhile and then I get this error:
[IBM][CLI Driver][DB2] SQL30081N A communication error has been detected.
Communication Protocol being used: "TCP/IP". Communication API being used:
"SOCKETS". Location where the error was detected "". Communication function
detecting the error: "recv'. Protocol specific error code(s): "9","*","*".
SQLSTATE=08001(#-30081)
After this happens I have to shut down Access and re-open the database to
use any of the link-tables, like the host has closed my connection to the DW.
What does this mean? Am doing something wrong with my delimiters?
Thank for your help in advance,
JDA
#9/1/2004#, the query works fine. When I try to filter the date by any other
means i.e. "Between #9/1/2004# and #9/30/2004#" or >#9/1/2004#, etc. the DB
sits for awhile and then I get this error:
[IBM][CLI Driver][DB2] SQL30081N A communication error has been detected.
Communication Protocol being used: "TCP/IP". Communication API being used:
"SOCKETS". Location where the error was detected "". Communication function
detecting the error: "recv'. Protocol specific error code(s): "9","*","*".
SQLSTATE=08001(#-30081)
After this happens I have to shut down Access and re-open the database to
use any of the link-tables, like the host has closed my connection to the DW.
What does this mean? Am doing something wrong with my delimiters?
Thank for your help in advance,
JDA