Oninit cdi / Archive
Talk to an expert →

ODBC problem?

Posted in 2001

Topics: Connectivity: ODBC / JDBC / .NET

John Smith — — source: Informix-list mailing list archive (1991-1998)

Hi, I had Cli SDK 2.40 and ODBC work fine DNS-less connection, fetching TEXT field, rs.Fields("something").ActualSize returns value > 0 When I try Cli SDK 2.50, same situation but rs.Fields("something").ActualSize returns 0 Same problem with Cli SDK 2.60 My OS is w2k, database server is DS 7.22.UC1 Any suggestions? Thnx in advance JS

↪ replying to John Smith
Earle A Long — — source: Informix-list mailing list archive (1991-1998)

Is 2.6 Client SDK available for Windows 2000 .... the downloads list says NO. Yours -- Earle A Long (Senior DBA) SINGLEPOINT UK LTD "John Smith" <js@ucsd.com> wrote in message news:95b9g6$m7p$1@bagan.srce.hr... > Hi, > I had Cli SDK 2.40 and ODBC work fine > DNS-less connection, fetching TEXT field, > rs.Fields("something").ActualSize returns value > 0 > > When I try Cli SDK 2.50, same situation but > rs.Fields("something").ActualSize returns 0 > > Same problem with Cli SDK 2.60 > > My OS is w2k, database server is DS 7.22.UC1 > > Any suggestions? > Thnx in advance > JS > > > >

↪ replying to John Smith
Richard Spitz — — source: Informix-list mailing list archive (1991-1998)

John Smith schrieb: > I had Cli SDK 2.40 and ODBC work fine > DNS-less connection, fetching TEXT field, John, would you care to explain how a DSN-less connection is set up with ODBC? Regards, Richard -- +-----------------------------+-------------------------------------+ | Dr. med Richard Spitz | Mail: spitz@ana.med.uni-muenchen.de | | Klinik für Anaesthesiologie | Tel : +49-89-7095-6110 | | Klinikum der Univ. München | FAX : +49-89-7095-6420 | | 81366 München, Germany | GSM : +49-172-8933578 | +-----------------------------+-------------------------------------+

↪ replying to Earle A Long
John Smith — — source: Informix-list mailing list archive (1991-1998)

Yap, but I also used 2.50 with no success Thnx for answer JS "Earle A Long" <earle@btclick.com> wrote in message news:FByf6.13076$qC1.133614@NewsReader... > Is 2.6 Client SDK available for Windows 2000 .... the downloads list says > NO. > > Yours > -- > Earle A Long (Senior DBA) > SINGLEPOINT UK LTD > > > > When I try Cli SDK 2.50, same situation but > > rs.Fields("something").ActualSize returns 0 > >

↪ replying to Richard Spitz
John Smith — — source: Informix-list mailing list archive (1991-1998)

Maybe like this... Global cn As ADODB.Connection ... cn.CursorLocation = adUseServer cn.Open "driver={INFORMIX 3.31 32 BIT};DB=MyDB;" _ & "HOST=myhost.mydomain.com;SRVR=myserver;SERV=myport;PRO=onsoctcp;" _ & "CLOC=hr_hr.cp1250;DLOC=hr_hr.8859-2;TOPT=1;VMB=1;CURB=2;OPT=;" _ & "SCUR=1;ICUR=0;OAC=1;OPTOFC=1;ODTYP=0;", "mylogin", "mypassword" cn.Execute "set lock mode to wait 5" cn.Execute "set isolation to dirty read" ... Dim R As ADODB.Recordset R.Open "select blobfield from blobtable where key = " & keyValue, cn, _ adOpenForwardOnly, adLockOptimistic If Not R.EOF Then If R.Fields("blobfield").ActualSize > 0 Then txtFromTEXTField = R.Fields("blobfield").GetChunk(R.Fields("blobfield").ActualSize) Else txtOpisPredmeta = "" End If txtOpisPredmeta.ForeColor = 0 End If R.Close ... JS "Richard Spitz" <Richard.Spitz@ana.med.uni-muenchen.de> wrote in message news:3A800CDD.B5DAE3FC@ana.med.uni-muenchen.de... > John Smith schrieb: > > > I had Cli SDK 2.40 and ODBC work fine > > DNS-less connection, fetching TEXT field, > > John, > > would you care to explain how a DSN-less connection is set up with > ODBC? > > Regards, Richard > -- > +-----------------------------+-------------------------------------+ > | Dr. med Richard Spitz | Mail: spitz@ana.med.uni-muenchen.de | > | Klinik f'r Anaesthesiologie | Tel : +49-89-7095-6110 | > | Klinikum der Univ. M'nchen | FAX : +49-89-7095-6420 | > | 81366 M'nchen, Germany | GSM : +49-172-8933578 | > +-----------------------------+-------------------------------------+