"3706 : Provider cannot be found. It may not be properly installed."

What could be the possible cause of this error?

I was using Pervasive SQL 2000i in my machine, using ADO connection. My query works just fine, but when deployed to the client, it wont work. They are using PSQL2000 which was, as they have told me, almost the same as PSQL2000i.

I wonder why it wont work. And then when I uninstall then install PSQL2000 (same version with them) in my machine, I also get that error. How can I resolve this?

I need an immediate response if possible, please help!

Thanks in advance.

Hi.

I've figured it out myself last month. I just thought I could share it to someone just in case he/she would encounter the same error.

I replaced my provider. I didn't use pervasive provider but microsoft's instead. The connection string simply becomes
Provider = "DSN="&dsnName

It worked for me.