DSN and DSN-less speed, etc...

[sail3005]

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.

[Kagey]

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.

[Jeh]

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?

[JoshT]

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