ChuckRush
asked on
Run time error 429
Good morning experts. I coding an application in VB access a MySQL DB. I am getting a runtime error 429 -- indicting that an Active X object cannot be created - - i must be miss a library reference but i cannot figure out which one -- thoughts?
Nor can we without further information. Can you show the code, please?
ASKER
I am sorry - i am using the following code to just test:
Private Sub cmdConnect_Click()
Dim cn As New rdoConnection
Dim qry As New rdoQuery
Dim rs As rdoResultset
dim wStr as String
cn.CursorDriver = rdUseOdbc
cn.Connect = "uid=r183;pwd=Test4351;ser ver=172.4. 34.2;drive r={MySQL ODBC 3.51 Driver};database=SDesk;dsn =KACE;"
cn.EstablishConnection
With qry
.Name = "queryName"
.SQL = "select * from HD_CATEGORY"
.RowsetSize = 1
Set .ActiveConnection = cn
Set rs = .OpenResultset(rdOpenKeyse t, rdConcurRowVer)
End With
loop through the record set processing the
records and fields.
Do Until rs.EOF
With rs
wStr = rs!CATEGORY
msgbox wStr
rs.MoveNext
End With
Loop
rs.Close
cn.Close
End Sub
Private Sub cmdConnect_Click()
Dim cn As New rdoConnection
Dim qry As New rdoQuery
Dim rs As rdoResultset
dim wStr as String
cn.CursorDriver = rdUseOdbc
cn.Connect = "uid=r183;pwd=Test4351;ser
cn.EstablishConnection
With qry
.Name = "queryName"
.SQL = "select * from HD_CATEGORY"
.RowsetSize = 1
Set .ActiveConnection = cn
Set rs = .OpenResultset(rdOpenKeyse
End With
loop through the record set processing the
records and fields.
Do Until rs.EOF
With rs
wStr = rs!CATEGORY
msgbox wStr
rs.MoveNext
End With
Loop
rs.Close
cn.Close
End Sub
Not many RDO applications about - I've never used it.
There's nothing obvious, but I doubt that it is a references problem. That you give you a different error.
Which line does it fail on?
There's nothing obvious, but I doubt that it is a references problem. That you give you a different error.
Which line does it fail on?
FYI, the reference that you need is for the Microsoft Remote Data Object. If it were missing you would get a 'User-defined type not defined' error.
ASKER
Thanks -- I must still be sleeping this morning -- i forgot to give you the ones i have loaded.
VA for Applications
Outlook 14.0 Object Library
Forms 2.0 Object Library
Remote Data Services 6.0 Library
Remote Data Services Server 6.0 Library
Remote Data Object 2.0
Office 14.0 Object Library
ActiveX Data Objects 6.0 Library
ADo Ext.for DDL and Security
I am using a Windows 7 (64) desktop
Thanks
VA for Applications
Outlook 14.0 Object Library
Forms 2.0 Object Library
Remote Data Services 6.0 Library
Remote Data Services Server 6.0 Library
Remote Data Object 2.0
Office 14.0 Object Library
ActiveX Data Objects 6.0 Library
ADo Ext.for DDL and Security
I am using a Windows 7 (64) desktop
Thanks
It's late afternoon here but I am beginning to droop, too.
On the code that you posted you only need the VBA and the RDO libraries.
Note that it would be useful to know where the error is raised.
On the code that you posted you only need the VBA and the RDO libraries.
Note that it would be useful to know where the error is raised.
ASKER
Cñ.cursordriveru=rduseodbc
Sorry, I can't reproduce the problem. It works OK for me, so I guess that there is something wrong somewhere with your support files (DLLs, etc).
There is some more detailed advice and a fix programme at Wiki Errors, here:
http://www.wiki-errors.com/err.php?wiki=429
There is some more detailed advice and a fix programme at Wiki Errors, here:
http://www.wiki-errors.com/err.php?wiki=429
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Graham. I managed a workaround using ADO . The site you sent me has given me more tings to research.
I wise move to use ADO. It doesn't have or need a CursorDrver property.
I would have suggested it, but most questioners don't like to be advised to do something completely different, and for all I knew you have thousands of lines in RDO.
I would have suggested it, but most questioners don't like to be advised to do something completely different, and for all I knew you have thousands of lines in RDO.
ASKER
I want to give Graham the points since he gave me a research direction. This error is clearly system dependent.
Thanks I am sorry for the confusion
Thanks I am sorry for the confusion