Re: ODBC drivers with VB 6.0 & ADO

But what about using data controls, ADODC. I am getting this error and don't know how to get around it: Run-Time Error '-2147467259 (80004005)' Insufficent base table information for updating or refreshing Automation Error(error 440) However if I use RDO, everything works fine. ----- Original Message ----- From: Dwight Rudolph Jr <dwight@rudolph.com> To: <informix-list@iiug.org> Sent: Thursday, April 29, 1999 2:44 PM Subject: Re: ODBC drivers with VB 6.0 & ADO > I'm doing it in VB6 with the Intersolv 3.01 (or 3.11) ODBC drivers > like this: > > dim db as ADODB.Connection > . > set db = New ADODB.Connection > db.ConnectionString = "DSN=dsn;" ' uses default login in ODBC setup > db.Open "dsn", "", "" > if db.Errors.Count <> 0 > if db.State <> adStateOpen > < emit nasty messages > > End If > End If > > What seems to be happening is that ADO gets an "option not implemented" > from ODBC, and reports an error. But it's not an option ADO *has* to have, > so it opens the connection anyway. > > In article <37275D5A.ADDA6342@wdn.com>, tsmith@wdn.com says... > > > >I am supporting a group that is attempting to implement with MS Visual > >Basic 6.0 via ADO against Informix 7.23 UC1 (quite a concept). They are > >having problems with their ODBC drivers indicating that certain > >functionality (e.g., scroll cursors) is not supported. Has anyone been > >successful with this combo? Does any mfr.'s ODBC driver work > >satisfactorily with VB 6 and Informix? Apparently neither Informix's, > >Intersolve's nor OpenLink's drivers work well enough to proceed with VB > >implementation. > > >