• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 204
  • Last Modified:

ASP and SQL connection 2005

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
0
rruth
Asked:
rruth
  • 2
  • 2
1 Solution
 
Anthony PerkinsCommented:
For SQL Server authentication use this connection string:
Provider=SQLNCLI;Server=YourServerNameGoesHere;Database=YourDatabaseGoesHere;UID=YourUserNameGoesHere;PWD=YourPasswordGoesHere;"
0
 
rruthAuthor Commented:
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")

%>
0
 
Anthony PerkinsCommented:
Change this:

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

To:
conn1.Open "Provider=SQLNCLI;Server=" & serverName & ";Database=" & MyDatabase & ";UID=" & MyUserId & ";PWD=" & MyPassword & ";"
0
 
Einstine98Commented:
a good help for everybody

http://www.connectionstrings.com/

Kept up-to-date
0
 
rruthAuthor Commented:
acperkins,

Thanks that worked great!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now