DSN-Less Chalenge

Results 1 to 2 of 2

Thread: DSN-Less Chalenge

  1. #1
    Join Date
    Dec 1969

    Default DSN-Less Chalenge

    Can anyone fix the code below so that it does not use a dsn, that is make it dsn-less???<BR><BR><BR>Session("DataConn_ConnectionStr ing") = "_DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath("Datafied.mdb")<BR>&#039 End of Automatic DataConnection<BR><BR>strconn = Session("DataConn_ConnectionString")<BR>set conn = server.createobject("adodb.connection")<BR>set rs = server.createobject("adodb.recordset")<BR>conn.ope n rs<BR><BR>RS.Open "SELECT * FROM Ads", Conn, adOpenKeyset,adLockReadOnly <BR><BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: DSN-Less Chalenge

    I have faith that you can do it! Check out the technique illustrated in the following article:<BR><BR>A Nifty Way to Create Connection Strings<BR>http://www.4guysfromrolla.com/webtech/070699-1.shtml<BR><BR>It discusses a sure-fire way to create connection strings for your DSN-less connections!

Posting Permissions

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