<div>
For SQL Server authentication use this connection string:<br />
Provider=SQLNCLI;Server=Yo<wbr />urServerNa<wbr />meGoesHere<wbr />;Database=<wbr />YourDataba<wbr />seGoesHere<wbr />;UID=YourU<wbr />serNameGoe<wbr />sHere;PWD=<wbr />YourPasswo<wbr />rdGoesHere<wbr />;&quot; <br />

</div>


For SQL Server authentication use this connection string:
Provider=SQLNCLI;Server=YourServerNameGoesHere;Database=YourDatabaseGoesHere;UID=YourUserNameGoesHere;PWD=YourPasswordGoesHere;"


<div>
I've tried to set this up like the examples I have for the Access db. Where am I going wrong? - Thank you for your help!<br />
<br />
&lt;%<br />
serverName = &quot;BABYRUTH4\SQLEXPRESS&quot;<br />
MyDatabase = &quot;empsolutions&quot;<br />
MyUserId = &quot;sa&quot;<br />
MyPassword = &quot;password&quot;<br />
<br />
Set conn1 = Server.CreateObject(&quot;ADODB<wbr />.Connectio<wbr />n&quot;)<br />
<br />
conn1.Open &quot;Provider=&quot; &amp;&nbsp;SQLNCLI;Server=serverName;<wbr />Database=M<wbr />yDatabase;<wbr />UID=MyUser<wbr />Id;PWD=MyP<wbr />assword;<br />
<br />
Set RS1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;= Server.CreateObject(&quot;ADODB<wbr />.Recordset<wbr />&quot;)<br />
<br />
%&gt;<br />

</div>


I've tried to set this up like the examples I have for the Access db. Where am I going wrong? - Thank you for your help!

<%
serverName = "BABYRUTH4\SQLEXPRESS"
MyDatabase = "empsolutions"
MyUserId = "sa"
MyPassword = "password"

Set conn1 = Server.CreateObject("ADODB.Connection")

conn1.Open "Provider=" & SQLNCLI;Server=serverName;Database=MyDatabase;UID=MyUserId;PWD=MyPassword;

Set RS1      = Server.CreateObject("ADODB.Recordset")

%>


<div>
a good help for everybody <br />
<br />
<a href="http://www.connectionstrings.com/" rel="ugc">http://www.connectionstrings.com/</a><br />
<br />
Kept up-to-date
</div>


a good help for everybody

http://www.connectionstrings.com/ [http://www.connectionstrings.com/]

Kept up-to-date

<div>
acperkins,<br />
<br />
Thanks that worked great!
</div>


<div>
<div class="content wysiwyg-content">
Experts,<br />
<br />
I need help setting up a SQL Server 2005 db connection using ASP. I have no problem connecting using Access but because SQL doesn't have a physical address to link to, I'm not sure how to set it up. I'm using XP and SQL Server is working fine when I connect using Coldfusion.<br />
<br />
Thanks for your help
</div>
</div>


Experts,

I need help setting up a SQL Server 2005 db connection using ASP. I have no problem connecting using Access but because SQL doesn't have a physical address to link to, I'm not sure how to set it up. I'm using XP and SQL Server is working fine when I connect using Coldfusion.

Thanks for your help

ASP and SQL connection 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.