Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

ADOR.RecordSet and Vista

 
   Database Forums (Home) -> Visual Basic -> DAO RSS
Next:  Can WordML be put in a SQL Server XML column?  
Author Message
Oleg Yevteyev

External


Since: Apr 03, 2007
Posts: 2



(Msg. 1) Posted: Tue Apr 03, 2007 2:14 pm
Post subject: ADOR.RecordSet and Vista
Archived from groups: microsoft>public>vb>database>dao (more info?)

I've inherited two sets of VB6 based com components from another developer.
A set of client side activeX controls and a set of server side com controls.
Basically, browser activated client side activex controls invokes server side
control on Windows 2003 server as

Set objUser = OpenObject("SBOUserInfo.CUserInfo", strServer)
lngResult = objUser.ValidateUserInfo(strUserName, _
strPassword, _
mrsUser, _
mrsSubCompanyAccess, _
mrsWorkGroups, _
mrsADOError, _
mintPWDUserStatus, _
mintPWDDaysToExpired)

where all of these mrs... objects are ADOR.RecordSet objects
like Private mrsUser As ADOR.Recordset , etc..
Eventually passing ADOR.Recordset across the wire.
The application is working just fine in all Windows versions, but Vista.
ComChecker shows 2.81SP1 ADO version on client XP machines, "unknown" - on
Vista, which comes with it's own set of ADO dlls.
On Vista the client side ValidateUserInfo call to Windows 2003 server
machine produces -2147024809 error. - One or more agruments are invalid.
So, client-server calls like "any windows,but vista"-"any windows, but
vista" work fine, "vista"-"vista" calls work fine, but "vista"-"any windows"
- fail.
I suspect some kind of type differences between ADOR. RecordSet
implementations on Vista and XP. Question is - how to get around that problem.
Any help?
Thanks

 >> Stay informed about: ADOR.RecordSet and Vista 
Back to top
Login to vote
Oleg Yevteyev

External


Since: Apr 03, 2007
Posts: 2



(Msg. 2) Posted: Tue Apr 03, 2007 2:32 pm
Post subject: RE: ADOR.RecordSet and Vista [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

As an addition to the way of calling server side obect:

Public Function OpenObject(strSBO As String, strServer As Variant) As Object
..................
Dim rdsDataSpace As Object
Dim objSBO As Object
Set mobjRDS = CreateObject("RDS.DataSpace")
mobjRDS.InternetTimeout = 0

'Use the dataspace CreateObject method to instatiate remote object
Set objSBO = mobjRDS.CreateObject(strSBO, strServer)
Set OpenObject = objSBO
....................................
End Function

 >> Stay informed about: ADOR.RecordSet and Vista 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
dao recordset error trapping - I have a dao recordset which I update with the following code: With rsOrderShip .Edit !CustCode = frmOrders.txtSTCustCode.Text !stcustname = frmOrders.txtSTCustName.Text !staddress1 = frmOrders.txtSTAddress1.Text ....

Error 3167 recordset is delete - Hello, ich habe in verschiedenen Newsgroups gesucht aber keine Lösung zu dem folgenden Problem gefunden. Zwei Personen arbeiten gemeinsam mit einem VB6-Programm an einer ACCESS 2000 Datenbank Der Zugriff von VB auf ACCESS erfolgt mit DAO 3.60. Eine de...

Deleting records from DAO recordset - [posted earlier in other group] Hi All, I'm using the following code to delete one or more records from a DAO recordset. The code is working but I was wondering if I need to Update the recordset with: rsDel.Update? Public Function DelRecs(Lstview As....

Updating DAO Record Moves it to the End of the Recordset - I am trying to loop through a DAO recordset and replace characters as needed. However, when the replacement consists of just appending a character, the first record in the recordset seems to move to the end of the recordset after the first iteration..

Problem with Data1.recordset.AddNew - Hi All I have a Access97 Database and if I delete all the records compat the database when I use AddNew I get an error message Runtime Error '3426': This action was cancelled by an arseociated object. and highlights the Data1.recodset.AddNew line in..
   Database Forums (Home) -> Visual Basic -> DAO All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]