Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_databases thread: Connection String (using OLEDB)


Message #1 by "Pete Cofrancesco" <pcofran@y...> on Fri, 25 May 2001 19:05:55
Im getting the following error when trying add a record.

   "Microsoft JET Database Engine error '80040e09' 

    Cannot update. Database or object is read-only." 



Why do I get this error when using the following connecion string?

  strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source="& sPath &  

    sdatabase & "; Persist Security Info = false"



But this connecion string works

  strConn = "driver={Microsoft Access Driver (*.mdb)}; dbq=" & sPath & 

    sdatabase & "; uid=;pwd=;" 

  Return to Index