Results 1 to 4 of 4

Thread: DSN and DSN-less speed, etc...

  1. Mar 11th, 2001, 04:43 PM #1
    sail3005
    sail3005 is offline

    Thread Starter
    PowerPoster sail3005's Avatar
    Join Date
    Oct 2000
    Location
    Chicago, IL, USA
    Posts
    2,340
    Which is faster, DSN or DSN-less for connecting to a database? I have been using DSN, are there any specific advantages of using DSN-less? It seems no matter where I look, every one seems to favor one or the other.

    USAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSA
    USAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSA
    USAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSA
    USAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSA
    USAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSA
    USAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSA
    USAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSA
    USAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSA
    USAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSA
    USAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSA
    USAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSA
    USAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSA
    USAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSAUSA
    Reply With Quote Reply With Quote
  2. Mar 11th, 2001, 05:48 PM #2
    Kagey
    Kagey is offline
    Hyperactive Member Kagey's Avatar
    Join Date
    Sep 2000
    Location
    The Wilderness of New Brunswick
    Posts
    294
    DSN is faster, but dsn-less is good if your db's are on a separate server and you don't know the full path or you can access it to install a dsn. thats what i've heard anyway.
    Reply With Quote Reply With Quote
  3. Mar 12th, 2001, 09:25 AM #3
    Jeh
    Jeh is offline
    New Member
    Join Date
    Feb 2001
    Posts
    12
    I've always read that DSN-Less connections are faster, as a DSN connection requires a trip to the registry on each connection meaning when large numbers are being performed you suffer more of a performance hit?
    Reply With Quote Reply With Quote
  4. Mar 12th, 2001, 12:07 PM #4
    JoshT
    JoshT is offline
    Black Cat JoshT's Avatar
    Join Date
    Nov 2000
    Location
    WNY, USA
    Posts
    4,032
    DSN-less connections seem to me to be easier to maintain. I can upload the database without needing physical access to add/change the DSN.

    Josh
    Josh
    Get these: Mozilla Opera OpenBSD
    I have books for sale: "MCSD in a Nutshell" and "VB Distributed Exam Cram" - PM me for details. Will also trade for a decent ATX Pentium 2 MB/CPU/RAM combo.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width