This is a multi-part message in MIME format.

------=_NextPart_000_000C_01C20769.3A505960
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 8bit

Why use the full path and not a DSN? Just curious. =)
--
MVH, Martin Johansson
CEO & Project Supervisor
SD-Studios, Squaremedia HB
+46 (0)70-3003320
http://www.sd-studios.com
http://www.swehost.com
  -----Ursprungligt meddelande-----
  Från: Johnson, Israel [mailto:IJohnson@R...]
  Skickat: den 29 maj 2002 18:18
  Till: ASP Databases
  Ämne: [asp_databases] RE: Question from a newbie?


  That book is great!  DSN (Data Source Names)  is just an option of
database connectivity.  I would recommend using the full path for your
connection string by setting the connection to a variable in a separate
file, then using an include for all pages that uses that connection.  You
may find that information is Chapter 6: "ADO Connections" (I think) in that
book.

  HTH...
    -----Original Message-----
    From: Daniel Schmidt [mailto:thedarknightofthesoul@h...]
    Sent: Wednesday, May 29, 2002 12:03 PM
    To: ASP Databases
    Subject: [asp_databases] Question from a newbie?




    Hello folks,

    Thank you for taking the time to help me get my feet wet.

    I'm reading "Beginning ASP databases" from Wrox and I'm learning alot
about DSN connections. Is this still a current technology and do you
recommend using it? If not, please recommend a book or resource that can
point me in the right direction.

    Advice Welcomed!

    Your Truly,

    Daniel Schmidt
    --- Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to 

----------------------------------------------------------------------------
    Get more from the Web. FREE MSN Explorer download :
http://explorer.msn.com


  --- Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to 

It's more easy for the maintenance: you put all the connections to the DB's 
in one same file (eg: init.asp) and if u change the directories: only one 
file to change... and if u had a dsn (file dsn or system dsn), you'd have to 
configure it for every DB.

Thus I prefer to encode the full path but some people prefer dsn, so the 
don't have to change the application if they change the place of the DB, 
they have just to change the DNS files or the entries of the system DSN.

But the connection time is rather similar with or without DSN (a little 
slower with DSN becouse one more file to access): dns files are like 
shortcuts: a dsn file is a little text file containing the path and method 
to access the DB.



----Original Message Follows----
From: "SD-Studios" <info@s...>
Reply-To: "ASP Databases" <asp_databases@p...>
To: "ASP Databases" <asp_databases@p...>
Subject: [asp_databases] SV: RE: Question from a newbie?
Date: Wed, 29 May 2002 23:33:25 +0200

Why use the full path and not a DSN? Just curious. =)
--
MVH, Martin Johansson
CEO & Project Supervisor
SD-Studios, Squaremedia HB
+46 (0)70-3003320
http://www.sd-studios.com
http://www.swehost.com
   -----Ursprungligt meddelande-----
   Från: Johnson, Israel [mailto:IJohnson@R...]
   Skickat: den 29 maj 2002 18:18
   Till: ASP Databases
   Ämne: [asp_databases] RE: Question from a newbie?


   That book is great!  DSN (Data Source Names)  is just an option of
database connectivity.  I would recommend using the full path for your
connection string by setting the connection to a variable in a separate
file, then using an include for all pages that uses that connection.  You
may find that information is Chapter 6: "ADO Connections" (I think) in that
book.

   HTH...
     -----Original Message-----
     From: Daniel Schmidt [mailto:thedarknightofthesoul@h...]
     Sent: Wednesday, May 29, 2002 12:03 PM
     To: ASP Databases
     Subject: [asp_databases] Question from a newbie?




     Hello folks,

     Thank you for taking the time to help me get my feet wet.

     I'm reading "Beginning ASP databases" from Wrox and I'm learning alot
about DSN connections. Is this still a current technology and do you
recommend using it? If not, please recommend a book or resource that can
point me in the right direction.

     Advice Welcomed!

     Your Truly,

     Daniel Schmidt
     --- Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to 

----------------------------------------------------------------------------
     Get more from the Web. FREE MSN Explorer download :
http://explorer.msn.com


   --- Change your mail options at http://p2p.wrox.com/manager.asp or to
unsubscribe send a blank email to 






_________________________________________________________________
Envoyez et recevez des messages Hotmail sur votre périphérique mobile : 
http://mobile.msn.com