Luis/Prakash,
Thank you for the quick response. Following your suggestions, I
got passed the .Net version issue and able to get to the login screen.
Upon login (picked up an existing user from USERS table), I'm getting
the following error.
It looks to me there is a mismatch between the QUERY in
TrialDB.aspx.vb and the database view definition.In STUDY_USERS_VIEW,
the user privileges are compressed in one column "STUDYIDUSERID", but
the query is written with the assumption they're individual columns in
the view.
Any thoughts?
Thanks.
Regards,
Raj K
PS: I apologize for mistakenly posting the same question multiple time.
Error in Routine:GetRows: Syntax or semantic Error in SQL query:
select V.study_ID,
V.user_ID,
V.add_data,
V.delete_data,
V.update_data,
V.view_data,
V.site_id,
V.upload_priv,
V.adhoc_priv,
S.Study_Title
from STUDY_USERS_VIEW V,
STudies S
where S.Study_ID=V.Study_ID
AND USER_ID = 2541
ORDER BY STUDY_TITLE
Description: An unhandled exception occurred during the execution of
the current web request. Please review the stack trace for more
information about the error and where it originated in the code.
Source File: C:\Inetpub\wwwroot\trialDB\trialDB.aspx.vb Line: 52
--- In
trialdb@yahoogroups.com, Luis Marenco <luis.marenco@...> wrote:
>
> The latest version we are using is the Visual Studio 2005. It is bit
by bit the
> same as our production-Oracle one.
>
>
>
> To use this one you need to do the following:
>
>
>
> - SQL server 2005 (any version from Express through
Enterprise). We
> rely upon SQL server schemas and synonyms to share the same code as our
> production one on both the Web and Access.
>
> - The access client is exactly the same bit-by-bite to our
production
> one and will work without any modifications; but you will need Windows
> integrated security for every user.
>
> - You need IIS, with .NET 2.0 enabled
>
>
>
> To configure your system to work properly:
>
> - You need to change all ADMINVAR to your project settings
>
> - Verify IIS folder security for reports; extracts, etc.
>
>
>
> To the best of my knowledge, the data warehouse system used for
some reports
> have not yet been converted to run in SQL server
>
>
>
> Regards,
>
> ________________________
>
> Luis Marenco
> Yale Center for Medical Informatics
>
> From:
trialdb@yahoogroups.com [mailto:
trialdb@yahoogroups.com] On
Behalf Of Raj
> K Muthu
> Sent: Friday, August 24, 2007 2:39 PM
> To:
trialdb@yahoogroups.com
> Subject: [trialdb] Re: Installation issue
>
>
>
> Hi,
> I installed TrialDB on my workstation to connect against SQL Server
> database. But I'm getting parser error while invoking TrialDB.aspx.
> I also made the following changes suggested in this forum, but still
getting the
> same error.
>
> - Edited the Web.config with new ODBC names, DB user id and
password and
> made sure it is on root directory of the web directory tree.
> - Edited Global.asx and replaced "act_db" with "TrialDB"
> - Set the virtual directory permission for ASP.NET (built-in)
user and
> enabled windows authentication.
>
> What am I missing here? Do I need to rebuild the project
again? I don't
> have VSTUDIO 2003
> at hand to do so.. but I intend to get a copy soon. Any suggestion
to fix this
> issue is greatly appreciated.
>
> Thanks.
>
> Regards,
> Raj Kathamut! hu
>
>
>
> Parser Error
>
>
> Description: Anerror occurred during the parsing of a resource
required to
> servicethis request.
> Please review the following specific parse error detailsand modify
your source
> file appropriately.
>
> Parser Error Message: Could not load type 'TrialDB_dotnet.WinMain'.
> Source Error:
>
>
> Line 1: <%@ Import Namespace="WebEAV" %>
>
>
> Line 2: <%@ Register TagPrefix="tdb" Namespace="WebEAV"
Assembly="WebEAV" %>
>
>
> Line 3: <%@ Page Language="vb" AutoEventWireup="false"
> Inherits="TrialDB_dotnet.WinMain" CodeFile="trialDB.aspx.vb"
> CodeBehind="trialDB.aspx.vb" %>
>
>
> Line 4: <HTM!
> L>
>
>
> Line 5: <HEAD>
>
>
> Source File: C:\Inetpub\wwwroot\trialDB\TrialDB.aspx Line: 3
>
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
Offline 
Send Email