Database Connection with OLEDB
Comparing between a SystemDNS connection & a non DNS connection to databases, the latter always seems to do better. This would be even more noticeable for sites which run a multitude of simultaneous connections to the database. However, experts seem to be recommending an OLEDB connection as against the above two. The fact that a faster speed in accessing data as well as establishing database connections is easily achieved using OLEDB contributes to this. If one sits to compare a DNS-less connection, a SystemDSN connection & an OLEDB connection, the last of the three scores above the other two.
The connection string for an OLEDB connection would be as follows.
“Host=HostName; Data Source=DatabaseSource; Initial Catalog=DatabaseName; User ID=UserID; Password=Password”
