Problems using SQL: asp

Showing posts with label asp. Show all posts

Friday, March 30, 2012

problems with useing ms2000 sql

I am new at this and I am getting though a book that is teaching me asp.net
I have experance with vb but I am having truble with the connection to my sql server

<%@. Page Language="VB" debug="true" %>
<script runat="server"
Function MyQueryMethod() As System.Data.SqlClient.SqlDataReader
Dim connectionString As String = "server='68.250.171.129'; trusted_connection=true; Database='working'"
Dim sqlConnection As System.Data.SqlClient.SqlConnection = New System.Data.SqlClient.SqlConnection(connectionString)

Dim queryString As String = "SELECT [personaldata].* FROM [personaldata]"
Dim sqlCommand As System.Data.SqlClient.SqlCommand = New System.Data.SqlClient.SqlCommand(queryString, sqlConnection)

sqlConnection.Open
Dim dataReader As System.Data.SqlClient.SqlDataReader = sqlCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection)

Return dataReader
End Function' Insert page code here
Sub Page_load(sender as object, e as EventArgs)
dgCustomers.DataSource = MyQueryMethod()
dgCustomers.DataBind()
End Sub

</script>
<html>
<head>
</head>
<body>
<form runat="server">
<asp:DataGrid id="dgCustomers" runat="server"></asp:DataGrid>

</form>
</body>
</html
This page works fine when I use the web matrix project, web server. I cannot get it to work when I use my win2000 servers iis server.

this is the error I am getting

Server Error in '/aspnet_client' Application.
------------------------

Invalid object name 'personaldata'.
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.

Exception Details: System.Data.SqlClient.SqlException: Invalid object name 'personaldata'.

Source Error:

Line 10:
Line 11: sqlConnection.Open
Line 12: Dim dataReader As System.Data.SqlClient.SqlDataReader = sqlCommand.ExecuteReader(System.Data.CommandBehavior.CloseConnection)
Line 13:
Line 14: Return dataReader

Source File: D:\server\WEB\aspnet_client\SimpleDataGrid.aspx Line: 12

Stack Trace:

[SqlException: Invalid object name 'personaldata'.]
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) +723
System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) +45
ASP.SimpleDataGrid_aspx.MyQueryMethod() in D:\server\WEB\aspnet_client\SimpleDataGrid.aspx:12
ASP.SimpleDataGrid_aspx.Page_load(Object sender, EventArgs e) in D:\server\WEB\aspnet_client\SimpleDataGrid.aspx:17
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731

Please can anyone helpYou must make the MACHINENAME\ASPNET Windows user a user in SQL Server. When running in Web Matrix, you are running in your user context, whereas when running in IIS, you are running in the securoty contest of, by default, the ASPNET user.

Note that if SQL is on another box, it might be easier to actually use SQL Server security and send a username and password.|||Thank you I did have that user set up, but it was not connected the that data base

Problems with the Web ReportViewer Control

I'm using SQL Server 2005 Reporting Services Sept CTP and Visual Studio 2005 RC to develop an ASP.NET application. On one of my web forms I have placed the web ReportViewer control so that I can display reports from Reporting Services.

The .aspx code is:

<%@. Page Language="C#" AutoEventWireup="true" CodeFile="ReportViewer.aspx.cs" Inherits="ReportViewer" %>

<%@. Register Assembly="Microsoft.ReportViewer.WebForms, Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" Namespace="Microsoft.Reporting.WebForms" TagPrefix="rsweb" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">

<title>ReportViewer</title>

</head>

<body>

<div>

<asp:Panel ID="PanelDisplayReport" runat="server" Height="100%" Width="100%">

<rsweb:reportviewer id="ReportViewerDisplayReport" runat="server" bordercolor="Navy" borderstyle="Solid" borderwidth="1px" height="100%" tooltip="Display Report" width="100%" Font-Names="Verdana" Font-Size="8pt" ProcessingMode="Remote">

</rsweb:reportviewer>

</asp:Panel>

</div>

</form>

</body>

</html>

The .aspx code-behind (in C#) is:

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

public partial class ReportViewer : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

this.ReportViewerDisplayReport.ProcessingMode = Microsoft.Reporting.WebForms.ProcessingMode.Remote;

this.ReportViewerDisplayReport.ToolTip = "/AdventureWorks Sample Reports/Company Sales";

this.ReportViewerDisplayReport.ZoomPercent = 90;

this.ReportViewerDisplayReport.ServerReport.DisplayName = "/AdventureWorks Sample Reports/Company Sales";

this.ReportViewerDisplayReport.ServerReport.ReportPath = @."/AdventureWorks Sample Reports/Company Sales";

this.ReportViewerDisplayReport.ServerReport.ReportServerUrl = new Uri(@."http://localhost/ReportServer");

}

As you can see, this is a very simply web form that is simply trying to display one of the reports from the AdventureWorks sample database and reports.

The problem is that the report will not display in the ReportViewer control. When I request the page, I see the ReportViewer's toolbar but not the actual report. I initially see the "Report is being generated" message in the control, where the report would normally be displayed. But, after the report is generated, no report, just the toolbar.

Anyway, does any one have any suggestions as to what's wrong?

Is there a bug in the ReportViewer control (for web forms) in Visual Studio 2005 RC?

Anything else???

Thanks in advance.

The problem is that height is set to 100% and doctype is set to XHTML. Either set the height to a fixed size (not a percent) or remove the line that sets doctype to XHTML.|||Thanks for this. I spent a couple of hours on this, I could have spent many more.|||You can also fix this problem by rendering the report synchronously. The control displays the report differently based on the method of rendering and calculates the actual height on the fly. When rendered synchronously, the calculated height is 0px, so nothing shows.

Wednesday, March 28, 2012

problems with sqlreader

Hi everyone,

I am writing a simple login application in asp 2.0. I have spent quite a little bit of time of this error so any help would be greatly appreciated.

Here is the code i am using.

Dim cnAs SqlConnection

Dim cmdAs SqlCommand

Dim sqlAsString ="select password from attendant where " & _

" ((username = @.username) and (password = @.password)"

cn =

New SqlConnection("Data Source=z-davis\sqlexpress;Initial Catalog=Trainingdb;Integrated Security=True")' cn = New SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings("TrainingdbConnectionString").ToString)

'I have tried both connection strings and get the same error.

cmd =New SqlCommand(sql, cn)

cmd.Parameters.Add(

"@.username", SqlDbType.VarChar, 50)

cmd.Parameters(

"@.username").Value = txtuser.Text

cmd.Parameters.Add(

"@.password", SqlDbType.VarChar, 50)

cmd.Parameters(

"@.password").Value = txtpass.Text

cn.Open()

Dim myreaderAs SqlDataReader

myreader = cmd.ExecuteReader(CommandBehavior.CloseConnection)

'The line above is where i get the error.

If myreader.Read()Then

FormsAuthentication.RedirectFromLoginPage(txtuser.Text,

False)Else

Response.Write(

"Try again")

After stepping through the code the error stops on this line:

myreader = cmd.executereader(commandbehavior.closeconnection)

The error that is generated is: Incorrect syntax near ')'

Any help would be greatly appreciated or any other code snippets

Thanks,

notrosh

In this line you have 3 open parentheses and only 2 close parentheses.

Dim sqlAsString ="select password from attendant where " & _

" ((username = @.username) and (password = @.password)"

Remove the first open parenthesis and you will have better luck.

|||

Thanks,

Sometimes you need an outside eye to see an error that simple.

zach davis

|||Or you need to have made that same sort of error a few dozen times Wink [;)]

I've learrned to count my parentheses using my fingers. Working left to right in my SQL statement, I put up a finger each time I open one, and put down a finger each time I close one. When I get to the last character, if I have any fingers sticking up, I know I have a problem. Pretty silly approach, but it works for me.

Monday, March 26, 2012

Problems with SQL 2005 Export Wizard

I am trying to transfer data from SQL Express to SQL Server 2005. The data is from Paypal Commerce Starter Kit from ASP.NET site.

I have tried several options (Optimize for many tables, Run in Transaction). However the data is not exported. This is the error I am getting:

TITLE: Operation stopped...

The package failed to load due to error 0xC0011008 "Error loading from XML. No further detailed error information can be specified for this problem because no Events object was passed where detailed error information can be stored.". This occurs when CPackage::LoadFromXML fails.

ADDITIONAL INFORMATION:

BUTTONS:

Here is some more info:

===================================

Program Location:

at Microsoft.SqlServer.Dts.Runtime.PersistImpl.LoadFromXML(XmlNode node, IDTSEvents events)
at Microsoft.SqlServer.Dts.Runtime.DtsContainer.LoadFromXML(XmlNode node, IDTSEvents events)
at Microsoft.SqlServer.Management.Dts.DtsTransferProvider.Configure(ITransferMetadataProvider metadataProvider)
at Microsoft.SqlServer.Dts.DtsWizard.Execute.DoTransferConfigureProvider(Exception& ex)

===================================

Program Location:

at Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageClass.LoadFromXML(Object pNode, IDTSEvents90 pEvents)
at Microsoft.SqlServer.Dts.Runtime.PersistImpl.LoadFromXML(XmlNode node, IDTSEvents events)

|||I've moved this to the SSIS forum. The error you're hitting looks to be in the SSIS/DTS subsystem. Some one in this forum should be able to help.|||

If LoadFromXML() fails it suggests that your package might be corrupt. Can you take that .dtsx file and open it in BIDS? (just right-click and Edit)

-Jamie

|||Thanks, but there is no package created. I just use Export Data wizard...|||

The Export Data wizard fails at "Create Temporrary XML file for table metadeta". here is mor edetails:

Operation stopped...

- Create a TransferProvider. (Success)
- Create a temporary file for destructive SQL. (Success)
- Create a temporary file for constructive SQL. (Success)
- Create a temporary XML file for table metadata. (Success)
- Configure the TransferProvider with files and Source/Destination connection info. (Error)

Messages

ADDITIONAL INFORMATION:

- Execute the transfer with the TransferProvider. (Stopped)

- Execute the destructive SQL. (drop tables) (Stopped)

- Execute the constructive SQL. (create tables) (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_Applications] (Stopped)

- Execute transfer package for [dbo].[aspnet_Applications] (Stopped)

- Copying to [dbo].[aspnet_Applications] (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_Membership] (Stopped)

- Execute transfer package for [dbo].[aspnet_Membership] (Stopped)

- Copying to [dbo].[aspnet_Membership] (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_Paths] (Stopped)

- Execute transfer package for [dbo].[aspnet_Paths] (Stopped)

- Copying to [dbo].[aspnet_Paths] (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_PersonalizationAllUsers] (Stopped)

- Execute transfer package for [dbo].[aspnet_PersonalizationAllUsers] (Stopped)

- Copying to [dbo].[aspnet_PersonalizationAllUsers] (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_PersonalizationPerUser] (Stopped)

- Execute transfer package for [dbo].[aspnet_PersonalizationPerUser] (Stopped)

- Copying to [dbo].[aspnet_PersonalizationPerUser] (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_Profile] (Stopped)

- Execute transfer package for [dbo].[aspnet_Profile] (Stopped)

- Copying to [dbo].[aspnet_Profile] (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_Roles] (Stopped)

- Execute transfer package for [dbo].[aspnet_Roles] (Stopped)

- Copying to [dbo].[aspnet_Roles] (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_SchemaVersions] (Stopped)

- Execute transfer package for [dbo].[aspnet_SchemaVersions] (Stopped)

- Copying to [dbo].[aspnet_SchemaVersions] (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_Users] (Stopped)

- Execute transfer package for [dbo].[aspnet_Users] (Stopped)

- Copying to [dbo].[aspnet_Users] (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_UsersInRoles] (Stopped)

- Execute transfer package for [dbo].[aspnet_UsersInRoles] (Stopped)

- Copying to [dbo].[aspnet_UsersInRoles] (Stopped)

- Create a temporary table transfer package for [dbo].[aspnet_WebEvent_Events] (Stopped)

- Execute transfer package for [dbo].[aspnet_WebEvent_Events] (Stopped)

- Copying to [dbo].[aspnet_WebEvent_Events] (Stopped)

- Create a temporary table transfer package for [dbo].[CMRC_Categories] (Stopped)

- Execute transfer package for [dbo].[CMRC_Categories] (Stopped)

- Copying to [dbo].[CMRC_Categories] (Stopped)

- Create a temporary table transfer package for [dbo].[CMRC_Content] (Stopped)

- Execute transfer package for [dbo].[CMRC_Content] (Stopped)

- Copying to [dbo].[CMRC_Content] (Stopped)

- Create a temporary table transfer package for [dbo].[CMRC_Content_Versions] (Stopped)

- Execute transfer package for [dbo].[CMRC_Content_Versions] (Stopped)

- Copying to [dbo].[CMRC_Content_Versions] (Stopped)

- Create a temporary table transfer package for [dbo].[CMRC_InventoryHistory] (Stopped)

- Execute transfer package for [dbo].[CMRC_InventoryHistory] (Stopped)

- Copying to [dbo].[CMRC_InventoryHistory] (Stopped)

- Create a temporary table transfer package for [dbo].[CMRC_Logs] (Stopped)

- Execute transfer package for [dbo].[CMRC_Logs] (Stopped)

- Copying to [dbo].[CMRC_Logs] (Stopped)

- Create a temporary table transfer package for [dbo].[CMRC_OrderItems] (Stopped)

- Execute transfer package for [dbo].[CMRC_OrderItems] (Stopped)

- Copying to [dbo].[CMRC_OrderItems] (Stopped)

- Create a temporary table transfer package for [dbo].[CMRC_Orders] (Stopped)

- Execute transfer package for [dbo].[CMRC_Orders] (Stopped)

- Copying to [dbo].[CMRC_Orders] (Stopped)

- Create a temporary table transfer package for [dbo].[CMRC_OrderStatus] (Stopped)

- Execute transfer package for [dbo].[CMRC_OrderStatus] (Stopped)

- Copying to [dbo].[CMRC_OrderStatus] (Stopped)

- Create a temporary table transfer package for [dbo].[CMRC_Products] (Stopped)

- Execute transfer package for [dbo].[CMRC_Products] (Stopped)

- Copying to [dbo].[CMRC_Products] (Stopped)

- Create a temporary table transfer package for [dbo].[CMRC_ShippingRates] (Stopped)

- Execute transfer package for [dbo].[CMRC_ShippingRates] (Stopped)

- Copying to [dbo].[CMRC_ShippingRates] (Stopped)

- Create a temporary table transfer package for [dbo].[CMRC_ShoppingCart] (Stopped)

- Execute transfer package for [dbo].[CMRC_ShoppingCart] (Stopped)

- Copying to [dbo].[CMRC_ShoppingCart] (Stopped)

- Create a temporary table transfer package for [dbo].[CMRC_ShoppingCartItems] (Stopped)

- Execute transfer package for [dbo].[CMRC_ShoppingCartItems] (Stopped)

- Copying to [dbo].[CMRC_ShoppingCartItems] (Stopped)

- Create a temporary table transfer package for [dbo].[CMRC_TaxRates] (Stopped)

- Execute transfer package for [dbo].[CMRC_TaxRates] (Stopped)

- Copying to [dbo].[CMRC_TaxRates] (Stopped)

- Create a temporary table transfer package for [dbo].[vw_aspnet_Applications] (Stopped)

- Execute transfer package for [dbo].[vw_aspnet_Applications] (Stopped)

- Copying to [dbo].[vw_aspnet_Applications] (Stopped)

- Create a temporary table transfer package for [dbo].[vw_aspnet_MembershipUsers] (Stopped)

- Execute transfer package for [dbo].[vw_aspnet_MembershipUsers] (Stopped)

- Copying to [dbo].[vw_aspnet_MembershipUsers] (Stopped)

- Create a temporary table transfer package for [dbo].[vw_aspnet_Profiles] (Stopped)

- Execute transfer package for [dbo].[vw_aspnet_Profiles] (Stopped)

- Copying to [dbo].[vw_aspnet_Profiles] (Stopped)

- Create a temporary table transfer package for [dbo].[vw_aspnet_Roles] (Stopped)

- Execute transfer package for [dbo].[vw_aspnet_Roles] (Stopped)

- Copying to [dbo].[vw_aspnet_Roles] (Stopped)

- Create a temporary table transfer package for [dbo].[vw_aspnet_Users] (Stopped)

- Execute transfer package for [dbo].[vw_aspnet_Users] (Stopped)

- Copying to [dbo].[vw_aspnet_Users] (Stopped)

- Create a temporary table transfer package for [dbo].[vw_aspnet_UsersInRoles] (Stopped)

- Execute transfer package for [dbo].[vw_aspnet_UsersInRoles] (Stopped)

- Copying to [dbo].[vw_aspnet_UsersInRoles] (Stopped)

- Create a temporary table transfer package for [dbo].[vw_aspnet_WebPartState_Paths] (Stopped)

- Execute transfer package for [dbo].[vw_aspnet_WebPartState_Paths] (Stopped)

- Copying to [dbo].[vw_aspnet_WebPartState_Paths] (Stopped)

- Create a temporary table transfer package for [dbo].[vw_aspnet_WebPartState_Shared] (Stopped)

- Execute transfer package for [dbo].[vw_aspnet_WebPartState_Shared] (Stopped)

- Copying to [dbo].[vw_aspnet_WebPartState_Shared] (Stopped)

- Create a temporary table transfer package for [dbo].[vw_aspnet_WebPartState_User] (Stopped)

- Execute transfer package for [dbo].[vw_aspnet_WebPartState_User] (Stopped)

- Copying to [dbo].[vw_aspnet_WebPartState_User] (Stopped)

|||

Hi all,

I'm having the same problem. Did anybody found a solution for this?

Thanks

|||

Could you guys try to register the xml dlls:

regsvr32.exe msxml3.dll

regsvr32.exe msxml6.dll

HTH.

|||I am having the same problem with my SQL 2005 server (Developer Edition), however, I needed to transform the database to SQL 2000 server. I went to the SQL 2000 box and ran the transform from there and it works fine. I have put all of the latest patches in my 2005 box, updated the MDAC with all versions from 2.6 forward, reinstalled the DTC tools, reinstalled all of the XML patches and updates; still no luck. I did not have this problem until I reformated my HD about 2 weeks ago. Prior to that it all worked fine.|||

After re-instaling, did you also try to register the XML DLLs that Bob suggested? I know they should have been registeded by setup when reinstalling, but just in case ...

Donald Farmer

|||I'm having the same issues and have not done a reinstall. I did try to reregister the referenced .dlls, but it did not help.|||

Has anyone found a solution to this problem yet?

I am trying to run a 'copy database objects' task programatically from vb.net. The SSIS package runs fine from BIDS but fails to load from the file system in the 'loadpackage' call with this 0xc0011008 message.

fyi here is the code...

Private Sub backgroundWorker2_DoWork(ByVal sender As Object, ByVal e As DoWorkEventArgs) Handles BackgroundWorker2.DoWork

Dim pkgLocation As String

Dim pkg As New Package

Dim app As New Application

Dim pkgResults As DTSExecResult

Dim autoEvent As New AutoResetEvent(False)

pkgLocation = e.Argument.ToString()

pkg = app.LoadPackage(pkgLocation, Nothing) ' this is the error line

pkgResults = pkg.Execute()

If pkgResults = DTSExecResult.Success Then

e.Result = "Success"

Else

e.Result = "Failed"

End If

end sub

As you can see this is running on a worker thread.

Does anyone have any ideas?

Thanks and Regards

Ray

|||

Bob Bojanic wrote:
Could you guys try to register the xml dlls:
regsvr32.exe msxml3.dll
regsvr32.exe msxml6.dll
HTH.

This solves this problem.