DSN vs DSN less Database Connections - Powered By Kayako SupportSuite

05 Sep 2010

Support Center » Knowledgebase » DSN vs DSN less Database Connections

	DSN vs DSN less Database Connections

Solution When connecting a database, DSN-less connections are superior to System DSN connections in performance. However, there will be no noticeable improvement in performance for smaller sites which have few concurrent connections only.

Although a DSN-less connection is operationally identical to a DSN but it doesn't have to access registry during connecting process. For DSN-less connection, all required information will be specified in the connection string instead of storing in registry.

In practice, you're recommended to use OLEDB connections over these two type of connections. Why? It's because OLEDB can provide better performance in database connections and faster access to data.

The Connection String for OLEDB would be:

For Access database :-
With native OLE DB Provider ( preferred ):
Provider=Microsoft.Jet.OLEDB.4.0; Data Source=server_physical_path

For SQL Server :
With native OLE DB Provider ( preferred ):-
Provider=SQLOLEDB; Data Source=server_name; Initial Catalog=database_name; User Id=user_name; Password=user_password

Article Details

Article ID:

Created On:

05 Feb 2007 04:01 AM