i need to connect to my database RSS

• • Reply
  

  husclass

  Member

  455 Points

  91 Posts

  i need to connect to my database

  Aug 11, 2003 09:05 AM|LINK

  how could i connect to an access database using the DSN what should i do i need any code example thanx a lot
  “To be incredible you must produce great work”
  Visit My Blog
  http://www.dotnetjunkies.com/WebLog/hussein
• • Reply
  

  Atrax

  All-Star

  18705 Points

  3733 Posts

  Re: i need to connect to my database

  Aug 11, 2003 12:50 PM|LINK

  this might help : http://rtfm.atrax.co.uk/infinitemonkeys/articles/asp.net/990.asp but don't use DSNs
  RTFM - straight talk for web developers. Unmoderated, uncensored, occasionally unreadable
  
  Jason Brown - MVP, IIS
• • Reply
  

  j_gaylord

  Contributor

  3444 Points

  731 Posts

  ASPInsiders

  MVP

  Re: i need to connect to my database

  Aug 11, 2003 12:57 PM|LINK

  Or www.ConnectionStrings.com
  Jason N. Gaylord
  ASPInsider and Microsoft MVP
  http://jasongaylord.com
• • Reply
  

  husclass

  Member

  455 Points

  91 Posts

  Re: i need to connect to my database

  Aug 11, 2003 03:57 PM|LINK

  thank you guy's for your help i know how to use the connection string and i can access my database but what i need is to use the DSN to connect directly to an access database without using the path of the database and i have heard that the dsn is a secure solution am i right in that or am wrong also do i need to have the ODBC driver downloaded to the framework and thanx again guy's your posts was helpfull to me..
  “To be incredible you must produce great work”
  Visit My Blog
  http://www.dotnetjunkies.com/WebLog/hussein
• • Reply
  

  Atrax

  All-Star

  18705 Points

  3733 Posts

  Re: i need to connect to my database

  Aug 11, 2003 11:51 PM|LINK

  explain WHY it has to be a DSN for me (I refuse to recommend DSNs because by their very nature they're far less efficient than a connection string, requiring registry lookups and so on) > without using the path of the database you have to have the path somewhere. A DSN would just store it differently. > i have heard that the dsn is a secure solution am i right depends what you mean by secure. as far as I'm concerned connection strings are plenty secure enough, and I don't see what added advantage you get from using a DSN instead.
  RTFM - straight talk for web developers. Unmoderated, uncensored, occasionally unreadable
  
  Jason Brown - MVP, IIS
• • Reply
  

  husclass

  Member

  455 Points

  91 Posts

  Re: i need to connect to my database

  Aug 12, 2003 06:38 AM|LINK

  thank you for your explination and i will use the oledb provider with my database and the original connection string
  “To be incredible you must produce great work”
  Visit My Blog
  http://www.dotnetjunkies.com/WebLog/hussein
• • Reply
  

  Jimsteele131

  Member

  45 Points

  9 Posts

  Re: i need to connect to my database

  Oct 02, 2003 11:16 PM|LINK

  Okay, lets just say, for the sake of argument that a system DSN has to be used. And I have to switch all of my stuff from SQL to using a system DSN. How would i connect that in an ASP.NET scenario?