Invalid Autorization Specification

[Tenloe]

I am using VB6 and Crystal XI an dam getting this error when trying to connect. Here is my code.

Dim ADOConnection As ADODB.Connection
Dim ADOCommand As ADODB.Command

Set ADOConnection = New ADODB.Connection
ADOConnection.Open sConnectString

Set ADOCommand = New ADODB.Command
Set ADOCommand.ActiveConnection = ADOConnection
ADOCommand.CommandText = m_SCompany & "PCLM"
ADOCommand.CommandType = adCmdTable


objRpt.Database.AddADOCommand ADOConnection, ADOCommand

sConnectString = Provider=sqloledb.1;Initial Catalog=DEVPE90;Persist Security Info=True;Data Source=NYSQL2000

Any help is appreciated.

 

[Tenloe]

I added user id and password to the connection string and I got this to work, however my report already had 12 tables in it and i just want to add two more, instead it deleted all of my tables and just added two. Also it named them ado and ado_1 where I need them to be named the database name. I am upgrading reports here and not creating new ones. Any clues on how to do that? Thanks...