Search Tools Links Login

Convert your ODBC connections to OLE DB

Looking for faster performance? If you have an older database driven ASP app, it probably uses an ODBC DSN in its connection string to reach the database. It probably looks alot like this: "DSN=myDSNName;".
If you see this you should immediately upgrade the code to ADO/OLEDB--Microsoft's new standard. Not only will this help you keep the code current, but it will run faster and take up less memory.
Below are the connection strings for OLEDB/ADO for both Access and SQL Server--the two most common databases for IIS platforms. If you are using another database, you'll need to consult your db's ADO Provider's documentation for the proper connection string.

Original Author: Ian Ippolito (vWorker)


'Access Example
"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:MyDatabase.mdb;"
'SQL Server example
"Provider=SQLOLEDB; Data Source=MySQLServer; Initial Catalog=pubs; User Id=MyUserId; Password=MyPassword;"

About this post

Posted: 2002-06-01
By: ArchiveBot
Viewed: 120 times




No attachments for this post

Loading Comments ...


No comments have been added for this post.

You must be logged in to make a comment.