I see a couple things here. First, you are trying to use ADODB for your connection and yet you are using an OLEDB connection string. The difference is important. If I recall correctly, you should use OLEDB for Frontpage/Classic ASP connections. I'm not sure if it is because it doesn't support ADO or if it was something else. In any event, here is a site that will give you an example of how to connect to a SQL database:
http://www.4guysfromrolla.com/webtech/063099-1.shtml[
^]
If you are wondering about different SQL connection strings, you can always go to
http://www.connectionstrings.com/[
^]. Just make sure you pick the right one for your situation.