ADO not receiving errors raised in sub procedure
Hi, I’v known for a while that ado has it’s limits when it comes to dealing with errors… but this one hurts: I have a StoredProcedure (SP) that calls a sub procedure. In the sub procedure an error is raised. The error does not reach ADO for some reason. After some research I find that [...]

Answer Question   |  September 16, 2010  11:42 AM
ActiveX, ActiveX Data Objects, ADO, ASP, SQL Server 2008, Stored Procedures, VBScript

Connect to Oracle 10g with VB6 using ADO
I created a query by using a query builder in Oracle 10g and I want to connect it to VB 6.0 through ADO. What steps should I follow? Please help me out. Thanks!

Answer Question   |  May 8, 2013  6:46 AM
ActiveX Data Objects, ADO, ADO Connection, Oracle 10g, Oracle connectivity, Oracle Query Builder, VB 6, VB 6.0, Visual Basic 6

Database connectivity using ActiveX control
Provide a sample code to how by using VB 6.0 connectivity can be done by ActiveX(ADO) Control tool with the database SQL Server 2000

Answer Question   |  January 6, 2009  1:04 PM
ActiveX, ActiveX Data Objects, ADO, Database connectivity, SQL Server 2000, VB 6, Visual Basic, Visual Basic 6

How to fill Combo Box at runtime in VB 6.0 …I’ve used RecordSet object but rec.count of rs obj returns (-1).I hv enough data in the DB
[Private Sub Form_Load() FillCombo End Sub Sub FillCombo() Dim rs As New ADODB.Recordset, SQL As String SQL = "Select Spare_Name from Spare" rs.Open SQL, Conn, adOpenDynamic, adLockOptimistic Dim i As Integer For i = 1 To rs.RecordCount cboSpare.AddItem rs("Spare_Name") rs.MoveNext Next MsgBox "Successss", vbOKOnly End Sub]

Answer Question   |  December 8, 2008  7:49 PM
ActiveX Data Objects, ADO, ADO Recordset Object, ComboBox, Database connectivity, Database programming, Recordset Object, RunTime, VB 6, Visual Basic, Visual Basic 6