DSN-Less in NT

Results 1 to 2 of 2

Thread: DSN-Less in NT

  1. #1
    Join Date
    Dec 1969

    Default DSN-Less in NT

    I am accessing an access database in windows 2000, buy doing this...<BR>--&#062;data_source = "Data Source=" & Server.Mappath("flexicon.mdb") & ";Provider=Microsoft.Jet.OLEDB.4.0;"<BR><BR> but the site as now been moved to an NT server and it is no longer working. I am getting this error...<BR>--&#062; Microsoft JET Database Engine error &#039;80004005&#039; <BR>--&#062; Operation must use an updateable query.<BR>I am guess that its because the JET engine isn&#039;t installed, how do i go about installing this? Or is it something else? Does access have to be installed to install the JET engine? <BR>thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: DSN-Less in NT

    You might try this version:<BR><BR>dim conn<BR>dim rs<BR>dim strID<BR>dim strconn<BR><BR><BR>strconn = "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath("youdb.mdb")<BR><BR>set conn = server.createobject("adodb.connection")<BR>conn.op en strconn<BR><BR>set rs = server.createobject("adodb.recordset")<BR><BR>your code.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts