gbr
asked on
rdo data connection problem
I am using the following code to establish a rdo db connection .....
Global grdxConn As New rdoConnection
Sub InitializeDB()
Dim lstrConnect As String
rdoEngine.rdoDefaultCursor Driver = rdUseOdbc
'DSN Less connection
lstrConnect = "UID=;PWD=;" _
& "Driver={Microsoft Access Driver (*.mdb)};" _
& "DBQ=C:\Leica\sap-migratio n\sutosap. mdb;" _
& "DSN=;"
grdxConn.Connect = lstrConnect
grdxConn.EstablishConnecti on
Exit Sub
...this works on my machine (win95), but not on another win95 machine, ..I get the following error on the first line (rdoEngine.rdoDefaultCurso rDriver = rdUseOdbc) ...
"ActiveX component cannot create control" (error number 429)
...I've checked the dll versions for any rdo associated dlls, and they're the same on both machines, ...can anyone help ?
Global grdxConn As New rdoConnection
Sub InitializeDB()
Dim lstrConnect As String
rdoEngine.rdoDefaultCursor
'DSN Less connection
lstrConnect = "UID=;PWD=;" _
& "Driver={Microsoft Access Driver (*.mdb)};" _
& "DBQ=C:\Leica\sap-migratio
& "DSN=;"
grdxConn.Connect = lstrConnect
grdxConn.EstablishConnecti
Exit Sub
...this works on my machine (win95), but not on another win95 machine, ..I get the following error on the first line (rdoEngine.rdoDefaultCurso
"ActiveX component cannot create control" (error number 429)
...I've checked the dll versions for any rdo associated dlls, and they're the same on both machines, ...can anyone help ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I was also having the samoe problem with RDO. The RDO connection works fine on my machine, but when i run the same application on another machine which doesn't ahve vb i get a runtime error 429; ActiveX Cant' create object..
Can one please tell why i get this error with RDO.