Installation Problems over Office2K (VB 6.0 )

Topic

New Reply

On a test machine, we upgraded Office 97 to Office 2K, including all the extra service packs. Now I want to installl VB 6.0 but, for some reason, I’m getting this error:

“sqlparse.dll was unable to register itself in the system registry”

I can’t find any documentation anywhere as to what this means, and it’s preventing us from successfully installing VB 6.0. We need do this to test out one more thing before we upgrade the entire office this weekend.

Help?

Reply | Quote

Replies

I’m not sure what SQLPARSE.DLL does (parse SQL, perhaps?), but it seems very likely that you are running into the problem of overwriting a newer version of the DLL. If you are planning to do your upgrades from an Administrative Install point, you might be able to roll updates into the administrative install to avoid that kind of problem. But if there is some other reason for this, I don’t know.

Reply | Quote

There are two versions of sqlparse.dll – one that VB6 is trying to load to the System32 directory and one that’s in the Office directory under Microsoft. The second one is newer than the one VB6 is trying to load but I have no idea how the second, newer one got there to begin with. I went over the VB code we use and only found one place where it’s specifically using “Microsoft.Jet.OLEDB.3.51”, which I need to change to 4.0, I think. The other apps call DBEngine, so I hope that this is okay.

Reply | Quote

There are two versions of sqlparse.dll – one that VB6 is trying to load to the System32 directory and one that’s in the Office directory under Microsoft. The second one is newer than the one VB6 is trying to load but I have no idea how the second, newer one got there to begin with. I went over the VB code we use and only found one place where it’s specifically using “Microsoft.Jet.OLEDB.3.51”, which I need to change to 4.0, I think. The other apps call DBEngine, so I hope that this is okay.

Reply | Quote

I’m not sure what SQLPARSE.DLL does (parse SQL, perhaps?), but it seems very likely that you are running into the problem of overwriting a newer version of the DLL. If you are planning to do your upgrades from an Administrative Install point, you might be able to roll updates into the administrative install to avoid that kind of problem. But if there is some other reason for this, I don’t know.

Reply | Quote

Do you have Crystal Reports installed? There are some newsgroup threads that mention the error you get in connection with Crystal Reports. The manufacturer http://www.crystaldecisions.com[/url%5D seems to have a patch available.

Reply | Quote

Yes, we do have Crystal reports already on the test machine. I’ll look and see what they say.

Thanks Jerry and Hans!

Reply | Quote

Yes, we do have Crystal reports already on the test machine. I’ll look and see what they say.

Thanks Jerry and Hans!

Reply | Quote

Do you have Crystal Reports installed? There are some newsgroup threads that mention the error you get in connection with Crystal Reports. The manufacturer http://www.crystaldecisions.com[/url%5D seems to have a patch available.

Reply | Quote