We help IT Professionals succeed at work.

Classic asp to sql 2008 connection

smitty62
smitty62 asked
on
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?

<%
dim supplyconn
set supplyconn = Server.CreateObject("ADODB.connection")
supplyconn.Open "Provider=sqlncli10;Integrated Security = SSPI;Persist Security Info=True;Initial Catalog=SupplyDOI;Data Source=doi084tsql1;Application name=SupplyDOI"
%>
Comment
Watch Question

Senior .Net Developer
Commented:
<%
dim supplyconn
set supplyconn = Server.CreateObject("ADODB.connection")
supplyconn.Open "Provider=sqlncli10;Data Source=doi084tsql1;Initial Catalog=SupplyDOI;User Id=myUsername;Password=myPassword;;Application name=SupplyDOI"
%>

did you tried the above ?

Explore More ContentExplore courses, solutions, and other research materials related to this topic.