Re: Visual Basic 6.0 problem!
- From: "William Vaughn [MVP]" <billvaNoSPAM@xxxxxxxxx>
- Date: Wed, 30 Apr 2008 09:39:21 -0700
You did not tell us what kind of error you're getting.
You're using SSPI authentication. This assumes that the SQL Server has an account setup for the Windows user or the group in which they are a member.
I would also double-check the version of the COM libraries to make sure they are correct as this is the most common reason for this type of failure.
I would also transition your skills to VB.NET.
--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
____________________________________________________________________________________________
<kevinpublic@xxxxxxxxxx> wrote in message news:30fe1dce-84d1-443f-95ca-1aef3d881078@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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!
.
- References:
- Visual Basic 6.0 problem!
- From: kevinpublic
- Visual Basic 6.0 problem!
- Prev by Date: Visual Basic 6.0 problem!
- Next by Date: Re: ado connection object in vb6
- Previous by thread: Visual Basic 6.0 problem!
- Index(es):
Relevant Pages
|
