Hi,

I am getting the message Runtime error '3706' when running the code below.
Code:
    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.