VB Forum / Database Access / April 2008

I have a fairly simple program I'm writing in VB6 to do basic project
scheduling.  It runs just fine on my computer.  I've created an
install set using the package & deployment wizard.  Here's the
problem... it only works on SOME of the computers I install it on.  I
have the following code:

Public CnxnCQ As ADODB.Connection
Public CnxnGP as ADODB.Connection
Public CnxnCV As ADODB.Connection
Public rsListOrders As ADODB.Recordset
Public UserInfo as clsUser
Public OrderInfo as clsOrder
Public strSQL as String

Sub Main()

  ConnectToTables

End Sub

Sub ConnectToTables()

  Set CnxnCQ = New ADODB.Connection
  CnxnCQ.ConnectionString = "Provider=SQLOLEDB;Data
Source=CORSICABINETS02;" & _
  "Initial Catalog=CorsiTables;" & _
  "Integrated Security=SSPI;"
  CnxnCQ.CursorLocation = adUseClient
  CnxnCQ.Open

  frmLogon.Show

For some computers, this code works just fine and the program runs
without incident.  For other computers, it gets as far as
'CnxnCQ.Open', then it gives me an "Object Required" error.

Please help!  I can't figure out why it's not working.  I've already
made sure the msado15.dll is correct for all the PCs I'm trying to
install it on.  Does anyone have any ideas why this would error out?

Thank you!