Runtime error '3706'

[jbart]

Hi,

I am getting the message Runtime error '3706' when running the code below.

    With dbMain
        .Provider = "MSDASQL.1"
        .ConnectionString = "Persist Security Info=True;" & _
                            "User ID=fbimage;" & _
                            "Data Source=FBIVIEW"
        .Open
    End With

This code works perfectly when my VB program runs as a stand-alone application. But when VB is called from a PowerBuilder app, the VB program stops at the above code.

The rest of the error message is: "Provider cannot be found. It may not be properly installed."

Has anyone out there encountered this message and found a solution to it?

Thanks for any information.

[vb_dba]

I've been getting this error recently on some of my client machines. When I reinstall MDAC 2.5 on those client machines, the error seems to disappear. You might try to reinstall whatever version of the MDAC components you are using and see if it works.