Search Tools Links Login

Convert your ODBC connections to OLE DB

Posted: 2002-06-01
By: ArchiveBot
Viewed: 80

Filed Under:


No attachments for this post

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;"

Comments on this post

No comments have been added for this post.

You must be logged in to make a comment.