This is a multi-part message in MIME format.
------=_NextPart_000_0009_01C11FF7.9F3CF540
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi all
I'm trying to run a SQL sentence which retrieves data from several =
tables which are in different libraries in a DB2 database.
I've created an ODBC to access to those libraries.
When CF is processing the query I get the foollowing mesage
[IBM][Client Access Express ODBC Controler (32 bits)][DB2/400 =
SQL]SQL0204 - *FILE type SIG00010 not found in SGBD_ATR=20
I think the problem could be that ColdFusion is only accessing the first =
library in the ODBC, so it doesn't recognize the tables which are in the =
other libraries.
How can this problem be solved?
Thanks in advance
Best regards=20
Manuel
------=_NextPart_000_0009_01C11FF7.9F3CF540
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.3103.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi all</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>I'm trying to run a SQL sentence which =
retrieves=20
data from several tables which are in different libraries in a DB2=20
database.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I've created an ODBC to access to those =
libraries.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>When CF is processing the query I get =
the=20
foollowing mesage</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>[IBM][Client Access Express ODBC =
Controler (32=20
bits)][DB2/400 SQL]SQL0204 - *FILE type SIG00010 not found in =
SGBD_ATR=20
</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>I think the problem could be that =
ColdFusion=20
is only accessing the first library in the ODBC, so it doesn't recognize =
the=20
tables which are in the other libraries.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>How can this problem be =
solved?</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanks in advance</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Best regards </FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Manuel</FONT></DIV></BODY></HTML>
------=_NextPart_000_0009_01C11FF7.9F3CF540--
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
