ODBC Connections

Posted in 2001

Topics: SQL Development & Query Writing, Connectivity: ODBC / JDBC / .NET

Mark Cyr — Thu, 11 Jan 2001 10:51:26 -0500 — source: Informix-list mailing list archive (1991-1998)

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C07BE6.5B1A03E0 Content-Type: text/plain Hi all. . . . I am a beginner to Informix and hopefully someone can point me in the correct direction. I am using CLI 2.6 to connect to an Informix 7.2 database on AIX. I connect ok to the database. Now the weird part. I run a basic select statement against a customer address database. Some days I will find all of the account numbers. On other days I will only find about 1/2 of the records even though I am entering in the same account numbers. Has anyone ever experienced anything like this? Are there log files in Informix I can check to see why the records aren't found? Trace utilities? Any suggestions would be greatly appreciated. Regards Mark ------_=_NextPart_001_01C07BE6.5B1A03E0 Content-Type: text/html Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3DUS-ASCII"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2650.12"> <TITLE>ODBC Connections</TITLE> </HEAD> <BODY> Hi all. . . . I am a beginner to Informix and = hopefully someone can point me in the correct direction. I am using CLI 2.6 to connect to an = Informix 7.2 database on AIX.  I connect ok to the database.  = Now the weird part.  I run a basic select statement against a = customer address database.  Some days I will find all of the = account numbers.  On other days I will only find about 1/2 of the = records even though I am entering in the same account numbers.  = Has anyone ever experienced anything = like this?  Are there log files in Informix I can check to see why = the records aren't found?  Trace utilities? Any suggestions would be greatly = appreciated. Regards Mark </BODY> </HTML> ------_=_NextPart_001_01C07BE6.5B1A03E0--