dsn problem

Results 1 to 3 of 3

Thread: dsn problem

  1. #1
    sahib Guest

    Default dsn problem

    hi,<BR>i&#039;m a newbie and would be greatfull if someone let me know how to change dsnless conn to dsn. dsn="test". below is the code;<BR><BR>&#060;%<BR><BR>&#039;Database Connection (can be DSN or DSN-less connection)<BR><BR> Session("sesDBConn") = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Inetpubwwwrootadminmydb.mdb;"<BR><BR>&#03 9;The name of the table which contains your user&#039;s information.<BR>&#039;If you&#039;re using the default database file, do not change this variable.<BR><BR> Session("sesUsersTable") = "customer"<BR><BR>&#039;Field to order tables by when displaying contents. (usually ID or Date field)<BR>&#039;*NOTE* If some tables lack this field, the script will give you a "page cannot be displayed" error.<BR><BR> Session("sesOrderBy") = "ID"<BR><BR>&#039;Field to start at when displaying fields. (normally field order is: ID=0, xDate=1, etc.)<BR><BR> Session("sesFieldStart") = 0

  2. #2
    Join Date
    Dec 1969

    Default not actually a problem

    Session("sesDBConn") = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:Inetpubwwwrootadminmydb.mdb;"<BR><BR>that is DSN-LESS<BR><BR>this is DSN<BR><BR>Session("sesDBConn") = "dsn=MyDSNName"<BR><BR><BR><BR>j

  3. #3
    sahib Guest

    Default thanks

    thanks a lot.

Posting Permissions

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