p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

activex_data_objects thread: Re: ActiveX Error Message


Message #1 by "Beata Chrulkiewicz" <moominek@h...> on Thu, 2 Aug 2001 21:16:14
Roy,



Make sure your Dao360.dll is registered on the client machine. You may 

want to check out that article from Microsoft:



http://support.microsoft.com/support/kb/articles/Q248/7/90.asp



Beata







> Not sure if this is the right place to post this but here goes...I am 

> attempting to link from my Excel worksheet to an ODBC data source and 

keep 

> getting the message "Run Time Error 429. ActiveX Component can't create 

> object" when using DAO to make the link.

> 

> I have got all the references to DAO set and the code runs fine on my 

> standalone PC. But when I install it on a client's machine it gives me 

the 

> above error. Is it something to do with workgroup membership??

> 

> The offending code is:

> 

> Dim wrkODBC As Workspace

> Dim conBOM As Connection

> Dim strConnect As String

> 

>     Set wrkODBC = CreateWorkspace("ODBCWorkspace", "Roy", "", dbUseODBC)

>     strConnect = "ODBC;DATABASE = SageLine132;UID = Roy;DSN=SageLine132"

>     Set conBOM = wrkODBC.OpenConnection("BOM", , , strConnect)        

>     etc, etc. 

> 

> The error is raised on the first line.

> 

> Any suggestions gratefully received.

> 

> Roy Thompson

> 


  Return to Index