Re: Problems with ADO connection with VB
Posted in 2004
does the I-Login demo work?? "Ian Lloyd" <Ian.Lloyd@citytech.co.uk> wrote in message news:<cipav3$7hf$1@news.xmission.com>... > ----=_NextPart_ST_12_31_42_Tuesday_September_21_2004_13340 > Content-Type: text/plain; charset=US-ASCII > Content-Transfer-Encoding: 7bit > > Hi List > > My company has recently migrated an Informix database frrom an AIX > operating system to a Linux operating system. We have a visual basic > database that will not work with the new setup, we get the following > error > > [INFORMIX][INFORMIX ODBC DRIVER] Invalid string or buffer length > > Performing an ODBC trace reveals the following > > Project1 a00-fcc EXIT SQLDriverConnectW with return code 1 > (SQL_SUCCESS_WITH_INFO) > HDBC 038418D8 > HWND 00000000 > WCHAR * 0x74329A38 [ -3] "******\\ 0" > SWORD -3 > WCHAR * 0x74329A38 > SWORD 2 > SWORD * 0x00000000 > UWORD 0 <SQL_DRIVER_NOPROMPT> > > DIAG [IM006] [Microsoft][ODBC Driver Manager] Driver's > SQLSetConnectAttr failed (0) > > Has anybody got any ideas on how to overcome this problem. > The ODBC driver we are using is IBM INFORMIX 3.82 32 BIT > > Previously with AIX we were using IBM INFORMIX 3.32 32 BIT with no > problems > > If anybody can help I would be very grateful > > Thanks > > Ian Lloyd > > > _____________________________________________________________________ > This message is intended solely for the use of the individual or organisation to whom it is addressed. It may contain privileged or confidential information. If you have received this message in error, please delete accordingly. If you are not the intended recipient, you should not use, copy, alter, or disclose the contents of this message. All information or opinions expressed in this message and/or any attachments are those of the author and are not necessarily those of City Technology Ltd. > > City Technology Ltd accepts no responsibility for the loss or damage arising from its use, including damage from virus. > _____________________________________________________________________ > This message has been checked for all known viruses by UUNET delivered > through the MessageLabs Virus Control Centre. For further information visit > http://www.uk.uu.net/products/security/virus/ > ----=_NextPart_ST_12_31_42_Tuesday_September_21_2004_13340 > Content-Type: text/html; charset=ISO-8859-1 > Content-Transfer-Encoding: 8bit > Content-Description: HTML > > <HTML><HEAD> > <META http-equiv=Content-Type content="text/html; charset=iso-8859-1"> > <META content="MSHTML 6.00.2900.2180" name=GENERATOR></HEAD> > <BODY style="MARGIN: 4px 4px 1px; FONT: 10pt Tahoma"> > <DIV>Hi List</DIV> > <DIV> </DIV> > <DIV>My company has recently migrated an Informix database frrom an AIX operating system to a Linux operating system. We have a visual basic database that will not work with the new setup, we get the following error</DIV> > <DIV> </DIV> > <DIV>[INFORMIX][INFORMIX ODBC DRIVER] Invalid string or buffer length</DIV> > <DIV> </DIV> > <DIV>Performing an ODBC trace reveals the following</DIV> > <DIV> </DIV> > <DIV>Project1 a00-fcc EXIT SQLDriverConnectW with return code 1 (SQL_SUCCESS_WITH_INFO)<BR> HDBC 038418D8<BR> HWND 00000000<BR> WCHAR * 0x74329A38 [ -3] "******\\ 0"<BR> SWORD -3 <BR> WCHAR * 0x74329A38 <BR> SWORD 2 <BR> SWORD *   > ; 0x00000000<BR> UWORD 0 <SQL_DRIVER_NOPROMPT></DIV> > <DIV> </DIV> > <DIV> DIAG [IM006] [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed (0) </DIV> > <DIV> </DIV> > <DIV>Has anybody got any ideas on how to overcome this problem.</DIV> > <DIV>The ODBC driver we are using is IBM INFORMIX 3.82 32 BIT</DIV> > <DIV> </DIV> > <DIV>Previously with AIX we were using IBM INFORMIX 3.32 32 BIT with no problems</DIV> > <DIV> </DIV> > <DIV>If anybody can help I would be very grateful</DIV> > <DIV> </DIV> > <DIV>Thanks</DIV> > <DIV> </DIV> > <DIV>Ian Lloyd</DIV> > <BR> > _____________________________________________________________________<BR> > This message is intended solely for the use of the individual or organisation to whom it is addressed. It may contain privileged or confidential information. If you have received this message in error, please delete accordingly. If you are not the intended recipient, you should not use, copy, alter, or disclose the contents of this message. All information or opinions expressed in this message and/or any attachments are those of the author and are not necessarily those of City Technology Ltd.<BR> > <BR> > City Technology Ltd accepts no responsibility for the loss or damage arising from its use, including damage from virus.<BR> > _____________________________________________________________________<BR> > This message has been checked for all known viruses by UUNET delivered <BR> > through the MessageLabs Virus Control Centre. For further information visit<BR> > <A > href=http://www.uk.uu.net/products/security/virus/> > http://www.uk.uu.net/products/security/virus/</A><BR> > </BODY></HTML> > > ----=_NextPart_ST_12_31_42_Tuesday_September_21_2004_13340-- > > sending to informix-list