I'm having a difficult time finding examples on the web that deal with classic asp to sql 2008. Most are for .net, or don't work. I even went to www.connectionstrings.com
and didn't find anything that helped. Please look at the following string, and let me know if you see anything incorrect. What are my options for "Integrated Security=SSPI". I don't want to use integrated widows security in this instance because I want to use a service account in the identity of the app pool. How can I write the connection string without "Integrated Security=SSPI" in the string?
set supplyconn = Server.CreateObject("ADODB
ated Security = SSPI;Persist Security Info=True;Initial Catalog=SupplyDOI;Data Source=doi084tsql1;Applica