provider not installed properly

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • gaya
    New Member
    • May 2007
    • 2

    provider not installed properly

    Hi,

    I really need help with issue...I have working on this for 2 days with not luck!!

    I keep getting the error message

    ADODB.Recordset (0x800A0E7A)
    Provider cannot be found. It may not be properly installed.
    /EMS/ShopFloor/LaborHistory.as p, line 33

    and line 33 is

    Set rstDBEdit = Server.CreateOb ject("ADODB.Rec ordset")
    rstDBEdit.Open strSQL, CONN_STRING_EMS , adOpenForwardOn ly, adLockReadOnly, adCmdText


    CONN_STRIN_EMS uses DSN=EMS, I checked the DSN and it works fine when I try to connect to it through excel..

    Please help!!!
Working...