ASP problem with SQL DB

Hi

I have a problem with some ASP script. The code works a treat on my testing server with an access database but fails to work with the SQL database i have on a live server - keeps saying incorrect username

do i need to amend any code in this?

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!--#include file="../Connections/fr_record_webtest.asp" -->
<%   
' variables
dim cnStr
dim rcSet
dim frmUsername
dim frmPassword
dim sqlStr

'store form input into variables
frmUsername = Request.Form("form_username")
frmPassword = Request.Form("form_password")

'create connection and recordset objects
Set cnStr = Server.CreateObject("ADODB.Connection")
Set rcSet = Server.CreateObject("ADODB.Recordset")

' defining database connection (connectionstring.asp)
Set cnStr = Server.CreateObject("ADODB.Connection")
cnStr.open strConnectionString

' execute sql and open as recordset
sqlStr = "Select * From adminprofiles where user = '" _
            & frmUsername & "' and password = '" & frmPassword & "'"

' Opens the returned values from the SQL as a recordset, ready for iteration by ASP
set rcSet = cnStr.Execute(sqlStr)

' validate variables against database
If (not rcSet.BOF) and (not rcSet.EOF) then
session("validated_user") = frmUsername
response.write "<h1>Login successful!</h1>"
response.write "<p>Welcome " & rcSet.fields(1) & "</p>"
Session("Authenticated") = 1
response.Redirect ("frr_admin_default.asp")
else
response.write "incorrect username and/or password"
end if
%>
<%
rcSet.Close()
Set rcSet = Nothing
%>

Have you been able to connect to the SQL Server using just teh conection string without the rest of the code ??