---------------------
I get the following error.
run time error '429':
Active x component can't create object
the pocedure that it is in is below
-------------
Private Sub open_database_connection() 'open the connection to access Database (s)
rdoDefaultLoginTimeout = 40 'set the default as 40 sec. --> the error is here
Set EN = rdoEnvironments(0) 'EN.CursorDriver = 1
conn$ = "DSN=picasso;UID=sa;PWD=;DATABASE=blackcar;" 'where to connect
Set cn = EN.OpenConnection("", rdDriverNoPrompt, False, conn$) 'connect
End Sub
I get the following error.
run time error '429':
Active x component can't create object
the pocedure that it is in is below
-------------
Private Sub open_database_connection() 'open the connection to access Database (s)
rdoDefaultLoginTimeout = 40 'set the default as 40 sec. --> the error is here
Set EN = rdoEnvironments(0) 'EN.CursorDriver = 1
conn$ = "DSN=picasso;UID=sa;PWD=;DATABASE=blackcar;" 'where to connect
Set cn = EN.OpenConnection("", rdDriverNoPrompt, False, conn$) 'connect
End Sub