Information générale
Catégorie:
COM/DCOM et OLE Automation
Titre:
ADO and remote automation
I've written a COM exe with data access(to a foxpro table) on a remote server using racmgr32 and autmgr32. The com object works just fine remotely when using standard Foxpro data access commands(USE table_name, seek, ect.) What I can't get to work is ADO. (Trying to implement a stateless remote application) Here is my class function,
Function GetCustProfile(_CcustOrCemail1 as String) as ADODB.Recordset
*check to see if cust ID or email
If At('@',_CcustOrCemail1) # 0 && email address
cSQL = "Select ccust, cname, cnospam, cconmeth, cemail1 From v:\FoxWeb\Programs\Vicky\cust.DBF Where cemail1 = '" + _CcustOrCemail1 + "'"
Else && customer id
cSQL = "Select ccust, cname, cnospam, cconmeth, cemail1 From v:\FoxWeb\Programs\Vicky\cust.DBF Where ccust = '" + _CcustOrCemail1 + "'"
Endif
*ado connection string
cCN='Provider=VFPOLEDB.1;Data Source=v:\FoxWeb\Programs\Vicky\;Password="";Collating Sequence=MACHINE'
*create ado recordset object
ors = Createobject('ADODB.recordset') && Here is where I'm popping an error!!!
*set cursor location to client
ors.CursorLocation = 3
*open recordset, fires sql statement
ors.Open(csql,cCN)
*disconnect the recordset
ors.ActiveConnection = .F.
Return ors
Endfunc
It's popping an error when I try to create the ADODB.Recordset
Here are the error I'm getting back to my client, OLE error code 0x80004001: Not implemented. When I use createobjectex('ADODB.Recordset','ComputerName') I get back this error. OLE error code 0x80004002: No such interface supported.
Anyone ever come across this problem using ADO and remote automation??
FYI: I did get this function to work in the command window on the computer that the COM object resides with the createobject function, So I'm thinking it has something to do with RACMGR32. (is RACMGR32 the way to go?)
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement