J
JDA
Hi,
In a database that I am building, I have an append query that transfers
records from our data warehouse to the local database (the DW is too slow to
use directly)
So, I have a query who's source is a link table (DB2 format) and destination
is a local table. When I query, I filter the records to add by date.
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
In a database that I am building, I have an append query that transfers
records from our data warehouse to the local database (the DW is too slow to
use directly)
So, I have a query who's source is a link table (DB2 format) and destination
is a local table. When I query, I filter the records to add by date.
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