We're trying to adapt some vba scripts to Microstation Connect Edition.
One does an Microsoft Access Database import / export.
In SS4 we're establishing a connection to an access database with the following code
Set MyDBcon = New ADODB.Connection MyDBcon.CursorLocation = adUseClient 'db connection On Error GoTo Error_Connection MyDBcon.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + stMyDbFileLocal, "", "" On Error GoTo 0
This fails in CE.(The file which 'stMyDbFileLocal' points to exists.)
We have some references loaded in ss4 as you can see in the attached image.
Do we have to reference additional / other files to make this work in CE?
Ingo
Jan beat me to it, I was going also say my bet would be 32bit/64bit connection problem.
Nice profile pic by the way!
(Thanks ;-) long live the penguin!)
I'm trying to check all the components for 64 bit.
Is the ADO ext responsible for database connectivity?
I've tried to switch to ADO 6.0 but this didn't help on first sight.