Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 Dsn Problem
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

rainman
Starting Member

2 Posts

Posted - 03 July 2001 :  00:56:44  Show Profile
hi,
i'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;

<%

'Database Connection (can be DSN or DSN-less connection)

Session("sesDBConn") = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\admin\mydb.mdb;"

'The name of the table which contains your user's information.
'If you're using the default database file, do not change this variable.

Session("sesUsersTable") = "customer"

'Field to order tables by when displaying contents. (usually ID or Date field)
'*NOTE* If some tables lack this field, the script will give you a "page cannot be displayed" error.

Session("sesOrderBy") = "ID"

'Field to start at when displaying fields. (normally field order is: ID=0, xDate=1, etc.)

Session("sesFieldStart") = 0

Doug G
Support Moderator

USA
6493 Posts

Posted - 03 July 2001 :  01:23:05  Show Profile
Replace Session("sesDBConn") = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Inetpub\wwwroot\admin\mydb.mdb;"

With Session("sesDBConn") = "DSN=dsnname" (you usually can leave out the DSN= and just put the DSN name).




======
Doug G
======
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.2 seconds. Powered By: Snitz Forums 2000 Version 3.4.07