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)

Code

'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

Categories

ASP/ HTML

Attachments

No attachments for this post


Loading Comments ...

Comments

No comments have been added for this post.

You must be logged in to make a comment.