I am making a few minor updates to a VB6 application. It runs on a windows 2000 server connected to a SQL Server 2000 Database.
I took a copy of the source code from the server updated it and complied it locally. My local machine is running windows 7 64x. I copied the .exe file back to the server and when I tried to run it I received the runtime error 49: Activex component can't create object. I know this error occurs when the application tries to open a connection to the database using RDO.
I can run the .exe fine from my local machine and my virtual pc which is running windows xp.
This application was previously working on the server and the changes I made were to the contents of a file it outputs so no new references would be needed.
These are the lines it is falling over on:
rdoEnvironments(0).CursorDriver = rdUseNone
Set conDB = rdoEnvironments(0).OpenConnection("MRA", rdDriverNoPrompt, True)
You might be missing some DLLs for RDO to work on the server, try this:
http://support.microsoft.com/kb/195474 - How To Determine RDO Files Needed for Distribution of App