<% session("oRpt").ReportComments = cCom session("oRpt").RecordSelectionFormula = cSel %> I will be eternally greatful to anyone that has the solution! Thanks, Derek [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => [ref] => [htmlstate] => on_nl2br [postusername] => Tha [ip] => thadrd@hotmail. [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 1 [islastshown] => [isfirstshown] => 1 [attachments] => [allattachments] => ) --> > ><% >session("oRpt").ReportComments = cCom >session("oRpt").RecordSelectionFormula = cSel >%> > > > > > >I will be eternally greatful to anyone that has the solution! >Thanks, >Derek[/ref] [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => [ref] => [htmlstate] => on_nl2br [postusername] => Turkbear [ip] => noone@nowhere.c [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 2 [islastshown] => [isfirstshown] => [attachments] => [allattachments] => ) --> > > <% > session("oRpt").ReportComments = cCom > session("oRpt").RecordSelectionFormula = cSel > %> > > > > > > I will be eternally greatful to anyone that has the solution! > Thanks, > Derek >[/ref] [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => [ref] => [htmlstate] => on_nl2br [postusername] => Mark [ip] => mschupp@ielearn [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 3 [islastshown] => 1 [isfirstshown] => [attachments] => [allattachments] => ) --> Oracle 8.1.7 connection and ASP - ASP Database

Oracle 8.1.7 connection and ASP - ASP Database

To all interested, I am trying to run Crystal Reports via ASP through an Oracle 8.1.7 connection. Every time I try to run the webpage, I get the following error displayed on the page: Error Occurred Reading Records: Logon failed. Details: 28000:[Oracle][ODBC][Ora]ORA-01005: null password given; logon denied I have entered our connection information numberous ways into our ASP code and gotten the same results. I have also tried the Microsoft driver that everyone claims to work (ver 2.0). I am wondering what I am doing wrong. Below is the ASP code. <%LANGUAGE="VBSCRIPT" CODEPAGE="1252"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> ...

  1. #1

    Default Oracle 8.1.7 connection and ASP

    To all interested,

    I am trying to run Crystal Reports via ASP through an Oracle 8.1.7
    connection. Every time I try to run the webpage, I get the following
    error displayed on the page:

    Error Occurred Reading Records: Logon failed. Details:
    28000:[Oracle][ODBC][Ora]ORA-01005: null password given; logon denied

    I have entered our connection information numberous ways into our ASP
    code and gotten the same results. I have also tried the Microsoft
    driver that everyone claims to work (ver 2.0). I am wondering what I am
    doing wrong. Below is the ASP code.

    <%LANGUAGE="VBSCRIPT" CODEPAGE="1252"%><!DOCTYPE HTML PUBLIC
    "-//W3C//DTD HTML 4.01 Transitional//EN"
    "http://www.w3.org/TR/html4/loose.dtd">

    <%
    Set OraDatabase = Server.CreateObject("ADODB.Connection")
    OraDatabase.Open "dsn=zfdprod;uid=pcinv;pwd=pcinv;"
    %>

    <% Response.Expires = 0 %>

    <html>

    <head>
    <title>Report Viewer</title>
    </head>

    <%
    ReportName = Request.QueryString("rpt")
    cCom = Request.QueryString("com")
    CSel = Request.QueryString("sel")

    Server.ScriptTimeout = 180
    %>

    <!-- #include file="AlwaysRequiredSteps.asp" -->

    <%
    session("oRpt").ReportComments = cCom
    session("oRpt").RecordSelectionFormula = cSel
    %>

    <!-- #include file="MoreRequiredSteps.asp" -->
    <!-- #include file="SmartViewerActiveX.asp" -->
    </html>

    I will be eternally greatful to anyone that has the solution!
    Thanks,
    Derek

    Tha Guest

  2. #2

    Default Re: Oracle 8.1.7 connection and ASP


    See my reply to your post in the comp.databases.oracle group about using a DSN-less connection..

    As a reminder:

    myconn= Server.CreateObject("ADODB.Connection");
    myconn.ConnectionTimeout = 15;
    myconn.CommandTimeout = 30;
    myConnString="Provider=MSDAORA;Password=pcinv;User ID=pcinv;Data Source=yourtnsnamesentry;"
    myconn.ConnectionString=myConnString
    myconn.Open;




    On 25 Aug 2004 10:52:18 -0700, "Tha DRD" <com> wrote:
     

    Turkbear Guest

  3. #3

    Default Re: Oracle 8.1.7 connection and ASP

    You may need to set the logininfo for each table in the report. This code
    snippet may help
    (it is based on Crystal Sample code for ASP):


    '================================================= =================
    '================================================= =================
    ' WORKING WITH SETLOGONINFO
    '
    ' The datasource here is called "Pubs Sample Database". It is a System
    ' Datasource (DSN), and points to the "pubs" database, which is installed
    ' with SQL Server. You will also need to change your user id and
    ' password.

    'Create a reference to the tables collection of the main report
    Set mainReportTableCollection = Session("oRpt").Database.Tables

    dim i

    For Each mnTable in mainReportTableCollection

    With mnTable.ConnectionProperties
    .item("UserId") = strUser
    .item("Password") = strPW
    .item("PreQEServerName") = strDSN
    .item("PreQEDatabaseName") = strDatabase
    End With

    Next

    If Err.Number <> 0 Then
    Response.Write "Error Occurred setting table login info: " &
    Err.Description
    Set Session("oRpt") = nothing
    Set Session("oApp") = nothing
    Session.Contents.Remove("oRpt")
    Session.Contents.Remove("oApp")
    Response.End
    End If


    --
    Mark Schupp
    Head of Development
    Integrity eLearning
    www.ielearning.com


    "Tha DRD" <com> wrote in message
    news:cgijki$prod.google.com... 


    Mark Guest

Similar Threads

  1. DSN connection and Oracle 9i
    By eerrty in forum Coldfusion Server Administration
    Replies: 0
    Last Post: March 25th, 02:12 PM
  2. connection Oracle database
    By Joe in forum ASP Database
    Replies: 2
    Last Post: March 3rd, 07:08 PM
  3. Oracle connection problem
    By John in forum ASP Database
    Replies: 4
    Last Post: September 19th, 08:48 AM
  4. Oracle DSN Less Connection String
    By udeman webforumsuser@macromedia.com in forum Macromedia Dreamweaver
    Replies: 1
    Last Post: July 29th, 02:33 PM
  5. Oracle ADO connection
    By Beaux in forum Oracle Server
    Replies: 1
    Last Post: December 6th, 07:45 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •