Visual Basic 6.0 problem!
- From: kevinpublic@xxxxxxxxxx
- Date: Mon, 28 Apr 2008 12:54:26 -0700 (PDT)
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!
.
- Follow-Ups:
- Re: Visual Basic 6.0 problem!
- From: William Vaughn [MVP]
- Re: Visual Basic 6.0 problem!
- Prev by Date: Re: ado connection object in vb6
- Next by Date: Re: Visual Basic 6.0 problem!
- Previous by thread: ADO Chunk Operations Truncated at 511,000 Bytes for Updates
- Next by thread: Re: Visual Basic 6.0 problem!
- Index(es):
Relevant Pages
|
