SQL connection logon & password

[redsand23]

Is there a property that will allow me pass the logon & password to connect to the SQL database in the below asp code. I am having to login to get the page to load when connecting to an sql database. When I use access and use a trusted connection I do not have the problem.

I have tried the ole db(ado) and odbc (rdo) with trusted connections with no luck. Any help would be greatly appreciated.


<%@ Language=VBScript %>

<%
'=================================================================================
'INSTANTIATE THE VIEWER AND DISPLAY THE REPORT THROUGH THE CRYSTAL REPORTS VIEWER
'=================================================================================

Response.ExpiresAbsolute = Now() - 1

' Create the Crystal Reports Viewer
Dim viewer
Set viewer = CreateObject("CrystalReports.CrystalReportViewer")
viewer.Name = "Crystal Reports Viewer"
viewer.IsOwnForm = true
viewer.IsOwnPage = true
viewer.IsDisplayGroupTree = False
viewer.HasToggleGroupTreeButton = False

' IMPORTANT NOTE:
' For a complete list of properties of the Page Viewer look in the RAS "COM Viewer SDK"
' help file found through Start | Programs | Crystal Enterprise 9 | Documentation

' Set the source for the viewer to the ReportClientDocuments report source


viewer.ReportSource = "C:\Program Files\Crystal Decisions\Report Application Server 9\Reports\2.rpt"
'Session("oClientDoc").ReportSource

' Process the http request to view the report
viewer.ProcessHttpRequest Request, Response, Null

%>