Share
Report
30Hi All,
We are into development of MS RMS Addins and we have developed hook to login into Store Operation Manager using QSRules.dll. we regularly face issues with the login when Store Ops and HQ are installed in the wrong sequence, i.e. Store first and then HQ, when signing on to a store database it tries to select the login info from the HQ User table and throws an error saying the table not found.
I have attached the piece of code and also the error that we encounter.
Can somebody please help us on this.
Dim objQSRules As Object
Dim objQSConn As Object
objQSRules = CreateObject("QSRules.SessionClass")
objQSConn = CreateObject("QSRules.ConnectionInfo")
With objQSConn
.ApplicationMode = 0
.provider = "SQLOLEDB.1"
.InitialCatalog = strDbName
.UserID = strUserId
.Password = strPassword
.RegisterNumber = 1
.DataSource = strServerName
End With
If objQSRules.Database.OpenConnection(objQSConn) Then
If objQSRules.LogIn(strUser, StrPasswrd) Then
Return True
Else
Return False
End If
End If
The error we get while logging in is as follows
"The connection cannot be used to perform this operation. It is either closed or invalid in this context.
SELECT * FROM [HQUser]"
Regards
Prashant
*This post is locked for comments
I have the same question (0)
All responses (
Answers (
