IE7 Script Error When Opening Infopath Forms
Jan 31, 2007
Hi,
I installed IE7 recently and it is giving me problems when I open Infopath forms to edit documents. I have a sharepoint website which contain links to these forms, when I click on the link it opens the infopath form. It was working absolutely fine when I used IE6. But now when I open the infopath form it gives me an error saying that
A Runtime error has occured
Line: 38
Error: Object Expected
When I open it in the debugger it shows me an error at <body onLoad="onLoad()">. Could someone please advice!
I appreciate a quick response.
Thanks
View 2 Replies
ADVERTISEMENT
Jun 26, 2007
Afternoon
I'm getting the below error message:
Autogrow of file 'FORMS' in database 'FORMS' cancelled or timed out after 30547 ms. Use ALTER DATABASE to set a smaller FILEGROWTH or to set a new size.
FORMS.LDF file is 7613952 KBand the growth is 512MB .
By how much should I set the filegrowth? The users are complaining that the application is freezing on them.
This is sqlserver 2000.
View 6 Replies
View Related
Apr 3, 2008
I have managed to get the Forms Authentication sample to work bu there is a hitch. I am running Report Server and Report Manager on the same(test) PC. I can logon to the Report Server without a problem but when I try logon from the UILogon.aspx page for Report Manager I receive the following error:
An error occurred while attempting to get the ReportServer Url. The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)
An error occurred while attempting to get the ReportServer Url. The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)An error occured while attempting to get the ReportServer Url. The RPC server is unavailable.(Exception from HRESULT: 0x800706BA).
I can register users which suggests that the page can connect to the database.
Any help???
View 3 Replies
View Related
May 9, 2008
I recently installed SQL Server 2005 Enterprise on a machine running Server 2003. I have successfully configured Reporting Services (see below for summary of settings)
- Used the defaults for the Repor tServer and Report Manager Virtual Directories
- Windows Service Identity set to domain user. The domain user is part of the administrator group on the machine and has sysadmin rights to the database
- Web Service Identity set to NT AuthorityNetworkService
When I open http://localhost/reports/, I get the following error:
I have check a bunch of forums, but have no success. Any advise would be greatly appreciated!!
Server Error in '/Reports' Application.
Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.
Compiler Error Message: CS0016: Could not write to output file 'c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628App_global.asax.th5hkjqv.dll' -- 'The directory name is invalid. '
Source Error:
[No relevant source lines]
Source File: Line: 0
Show Detailed Compiler Output:
c:windowssystem32inetsrv> "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727csc.exe" /t:library /utf8output /R:"C:WINDOWSassemblyGAC_32System.Web2.0.0.0__b03f5f7f11d50a3aSystem.Web.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl3a890e9c0 068591f_f54cc701ReportingServicesFileShareDeliveryProvider.DLL" /R:"C:WINDOWSassemblyGAC_MSILSystem.Web.Mobile2.0.0.0__b03f5f7f11d50a3aSystem.Web.Mobile.dll" /R:"C:WINDOWSassemblyGAC_32System.Data2.0.0.0__b77a5c561934e089System.Data.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem.Web.Services2.0.0.0__b03f5f7f11d50a3aSystem.Web.Services.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem.Configuration2.0.0.0__b03f5f7f11d50a3aSystem.Configuration.dll" /R:"C:WINDOWSassemblyGAC_32System.EnterpriseServices2.0.0.0__b03f5f7f11d50a3aSystem.EnterpriseServices.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem.IdentityModel3.0.0.0__b77a5c561934e089System.IdentityModel.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem.ServiceModel3.0.0.0__b77a5c561934e089System.ServiceModel.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem2.0.0.0__b77a5c561934e089System.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl34a099978 068591f_f54cc701ReportingServicesEmailDeliveryProvider.DLL" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727mscorlib.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl3de5a2332 0958a20_f54cc701ReportingServicesWebUserInterface.DLL" /R:"C:WINDOWSassemblyGAC_MSILSystem.Xml2.0.0.0__b77a5c561934e089System.Xml.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl3498aee86 042473c_93d0c501ReportingServicesCDOInterop.DLL" /R:"C:WINDOWSassemblyGAC_MSILSystem.Runtime.Serialization3.0.0.0__b77a5c561934e089System.Runtime.Serialization.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem.Drawing2.0.0.0__b03f5f7f11d50a3aSystem.Drawing.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl3cd47089b 0f2a80e_f54cc701Microsoft.ReportingServices.Interfaces.DLL" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl3f180608d 0083daf_b16dc701Microsoft.ReportingServices.Diagnostics.DLL" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl323449648 068591f_f54cc701ReportingServicesNativeClient.DLL" /out:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628App_global.asax.th5hkjqv.dll" /debug- /optimize+ /w:4 /nowarn:1659;1699;1701 "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628App_global.asax.th5hkjqv.0.cs" "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628App_global.asax.th5hkjqv.1.cs"
Microsoft (R) Visual C# 2005 Compiler version 8.00.50727.1433
for Microsoft (R) Windows (R) 2005 Framework version 2.0.50727
Copyright (C) Microsoft Corporation 2001-2005. All rights reserved.
error CS0016: Could not write to output file 'c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628App_global.asax.th5hkjqv.dll' -- 'The directory name is invalid. '
Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433
View 5 Replies
View Related
Aug 9, 2007
Hi All:
Need quick help guyz. I am implementing Forms Authentication on my website below is the code for the same... However I am getting the following error ....
Line 1: Incorrect syntax near 'SQLSTR'. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteReader() at GreyHounds.Login.btnLogin_Click(Object sender, EventArgs e) in c:inetpubwwwrootGreyHoundsLogin.aspx.vb:line 49 Private Sub btnLogin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLogin.Click
Dim con As New SqlConnection("server=localhost; initial catalog=Grey Hounds; integrated security=SSPI")Dim SQLSTR As String = "Select * from Emp_Login"
Dim cmd As New SqlCommand("SQLSTR", con)Dim p1 As New SqlParameter("@EmpId", SqlDbType.VarChar)Dim p2 As New SqlParameter("@Password", SqlDbType.VarChar)
p1.SqlDbType = SqlDbType.VarChar
p1.Value = txtEmpID.Text
p2.SqlDbType = SqlDbType.VarChar
p2.Value = txtPass.Text
cmd.CommandType = CommandType.Text
cmd.Parameters.Add(p1)
cmd.Parameters.Add(p2)
Try
con.Open()Dim dr As SqlDataReader = cmd.ExecuteReader()
If Not txtEmpID.Text.Equals("") Or txtPass.Text.Equals("") Then
If dr.Item("Emp_Login") = p1.Value And dr.Item("Password") = p2.Value ThenFormsAuthentication.RedirectFromLoginPage(txtEmpID.Text, True)
Response.Redirect("http://localhost/greyhounds/Default.aspx")
Session("Emp_ID") = p1.Value
End If
Else
lblMessage.Text = "Invalid Credentials!Please try again"
End If
lblMessage.Text = "Cannot leave the boxes empty! Please enter the values"Catch ex As SqlException
Response.Write("<b>" & ex.Message & ex.HelpLink & "</b>")
Response.Write(ex.StackTrace)Catch ex1 As Exception
Response.Write(ex1.Message & ex1.Source & ex1.HelpLink)
Finally
con.Close()End Try
End Sub
Your quick help is highly appreciated...
Thanks!
Brandy
View 2 Replies
View Related
Feb 20, 2007
Hello
I'm trying to get the forms authentication sample working - I have followed the instructions given in the ReadMe that came with the samples. When I try to browse to localhost/reportserver (on the server), instead of seeing the logon page as expected, I get the following error message:
An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
Request for the permission of type 'System.Web.AspNetHostingPermission, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
I built the sample in VS 2005, and am using v2 of .net. Reporting services is installed on a windows server 2003 machine.
This has been driving me crazy for a while now. Any help would be greatly appreciated!
Thanks in advance
Dominic
View 4 Replies
View Related
Jun 26, 2007
I have created my query to do what it needs to do but i'm getting error when i click the button, it says there is an error opening my connectiong....
I.E.
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
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: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.Source Error:
Line 28:
Line 29: //open the connection
Line 30: myConnection.Open();
Line 31:
Line 32: //create a commandSource File: c:Documents and SettingsplanPlanDatabaseBZAvuAdd.aspx.cs Line: 30 Stack Trace:
[SqlException (0x80131904): Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +171
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +199
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2305
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +34
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +606
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +193
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +502
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +429
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +70
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +512
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +85
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +89
System.Data.SqlClient.SqlConnection.Open() +160
_Default.insertIntoVU() in c:Documents and SettingsplanPlanDatabaseBZAvuAdd.aspx.cs:30
_Default.addAppButton_Click(Object sender, EventArgs e) in c:Documents and SettingsplanPlanDatabaseBZAvuAdd.aspx.cs:127
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +75
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +98
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4919
therefor is this saying that I have to login before even testing this thing or what??
View 27 Replies
View Related
Jan 17, 2008
Hello,
I put my stored procedure in my class and try to execute it but get this error
1st here is my class
1 public signup_data_entry()
2 {
3 SqlConnection con = new SqlConnection("cellulant_ConnectionString");
4
5
6 SqlCommand command = new SqlCommand("Cellulant_Users_registration", con);
7 command.CommandType = CommandType.StoredProcedure;
8
9 con.open();
10
11 command.Parameters.Add(new SqlParameter("@RegionID", SqlDbType.Int, 0, "RegionID"));
12 command.Parameters.Add(new SqlParameter("@RegionDescription", SqlDbType.NChar, 50, "RegionDescription"));
13
14 command.Parameters[0].Value = 4;
15 command.Parameters[1].Value = "SouthEast";
16
17 int i = command.ExecuteNonQuery();
18
19
20 }
and here is the error message on the testing server. Error line is line 27 below
Source Error:
Line 25: command.CommandType = CommandType.StoredProcedure;
Line 26:
Error >>> Line 27: con.open();
Line 28:
Line 29: command.Parameters.Add(new SqlParameter("@RegionID", SqlDbType.Int, 0, "RegionID"));
Source File: c:inetpubwwwrootcellulant1App_Codesignup_data-entry.cs Line: 27
View 1 Replies
View Related
Jul 11, 2005
Hi,I am getting this error when i am connecting sql database.Error = "SQL Server does not exist or access denied."Can you please suggest me where i am going wrong.RegardsNaveen
View 2 Replies
View Related
Apr 30, 2001
When using Enterprise Manager, Right Clicking on any table in the db, selecting OPEN TABLE, and choosing either Return all rows or Return Top... I recieve this error "The query cannot be executed because some files are missing or not registered. Run setup again to make sure the required files are registered."
I am running: SQL Server 7.0 Client with Windows 2000.
I have run setup again and the same thing still happenes. I even uninstalled and reinstalled SQL Server, still the same thing occures.
I first installed SQL Server7.0 on my machine about a month and a half ago and all was fine until two weeks ago, then this started happening. SQL Server was the last thing I have installed on this machine so it cannot be a new install conflict. I can't think of any reason for this to be happening out of the blue like it did.
Does anyone have any insight???
View 2 Replies
View Related
May 15, 2007
Hi all,
I am having one problem about the processing cube in SQL 2005 AS.
when cube runs i get this error in log file:
File system error: Error opening file; Program Files (x86)Microsoft SQL Server90SharedASConfigmsmdredir.ini is not a disk file or file is not accessible.
View 1 Replies
View Related
May 8, 2006
Hello, I get this error:
Could not allocate ancillary table for view or function resolution
When I try to open a view that has never had a problem before today. I called Microsoft support and got a hot fix sent to me but unfortunatly it didnt install at all. I get an error:
You do not have any instance of SQL installed on this computer that qualifies for this hotfix.
Please check version and service pack requirements for this hotfix
And according to KB articles this problem should have been fixed by SP4 (which I have). So I dont know what to do. Could someone please help me??
Thanks
Mark
View 3 Replies
View Related
Jan 13, 2006
When I try to open the designer (with exiting, e.g. tutorial or new project/package) I get the following error message:
Microsoft Visual Studio is unable to load this document:
Index (zero based) must be greater than or equal to zero and less than the size of the argument list.
After closing the project I have the following application event log error:
Faulting application devenv.exe, version 8.0.50727.42, stamp 4333e699, faulting module unknown, version 0.0.0.0, stamp 00000000, debug? 0, fault address 0x014fb87c.
View 3 Replies
View Related
Aug 28, 2000
I am getting an error stating the parameter is incorrect when I open a package on my laptap. If I do it on the server it works fine. I even tried recreating my ODBC connection on my laptop thinking that might be it. Any suggestions would be appreciated.
View 2 Replies
View Related
Jan 12, 2006
I am trying to open the solution and it is giving me error
"The application for the project \.... est.dtproj is not installed
Make sure application for the project type(.dtproj) is installed."
I tried to open any SSIS solution and it is giving me same error.
Anybody has any ideas how to resolve this problem?
View 7 Replies
View Related
May 7, 2008
I am getting the following error when I try to double click on an Execute Sql Task to open it using VS2005:
===================================
Cannot show the editor for this task. (Microsoft Visual Studio)
===================================
Method 'get_ParameterSize' in type 'GridRow' from assembly 'Microsoft.SqlServer.SQLTaskUI, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' does not have an implementation. (Microsoft.SqlServer.SQLTaskUI)
Please help!!
View 4 Replies
View Related
Jan 18, 2007
Hi All
i am very new to using sql reporting services. After installation of reporting services and configuration i get this error on the browser.
Can anyone highlight the problem in the configuration?
my system is configured as
Windows 2003 SP1 server
MSSQL 2005 sp1
Server Error in '/Reports' Application.
--------------------------------------------------------------------------------
The current identity (NT AUTHORITYNETWORK SERVICE) does not have write access to 'C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files'.
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.Web.HttpException: The current identity (NT AUTHORITYNETWORK SERVICE) does not have write access to 'C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files'.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[HttpException (0x80004005): The current identity (NT AUTHORITYNETWORK SERVICE) does not have write access to 'C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files'.]
System.Web.HttpRuntime.SetUpCodegenDirectory(CompilationSection compilationSection) +3474107
System.Web.HttpRuntime.HostingInit(HostingEnvironmentFlags hostingFlags) +226
[HttpException (0x80004005): The current identity (NT AUTHORITYNETWORK SERVICE) does not have write access to 'C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files'.]
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +3426839
System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +88
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +149
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
thanks
ga
View 4 Replies
View Related
May 24, 2007
I am getting the following error when I try to open my SSIS package
Error 1 Error loading CCTAdvocateList.dtsx: The connection "DestinationConnectionOLEDB" is not found. This error is thrown by Connections collection when the specific connection element is not found. j:cct db migrationcodecct db migrationCCTAdvocateList.dtsx 1 1
Error 4 Error loading CCTAdvocateList.dtsx: The connection "SourceConnectionOLEDB" is not found. This error is thrown by Connections collection when the specific connection element is not found. j:cct db migrationcodecct db migrationCCTAdvocateList.dtsx 1 1
The connections which BIDS is complaining about are not even there in the package. I had created these two connections some time ago but then I had removed them from the package and it was working ever since.
Suddenly I have started to get these error messages.
regards,
Abhishek.
View 2 Replies
View Related
Jan 29, 2008
I built a form in infopath 2003 ...now I want that the information
will be send to the SQL server....
Is there a place here (in this site) I can Study this....
I know that I need to drag the Fileds from the form to the Sql tables....
my form has 100 fields...lots of check boxes.....
Where can I study this in this site.... ? from the begining !!!
Thank you again.....Hope you will help me
View 1 Replies
View Related
Jan 29, 2008
I built a form in infopath 2003 ...now I want that the information will be send to the SQL server....
Is there a place here (in this site) I can Study this....
I know that I need to drag the Fileds from the form to the Sql tables....
my form has 100 fields...lots of check boxes.....
Where can I study this in this site.... ? from the begining !!!
Thank you again.....Hope you will help me
View 1 Replies
View Related
Jun 6, 2001
everytime i go to open tables in enterprise manager, i right click the table and then select open all of it. however, i was gone from work for a week, and when i came back i got an error message when i did this. it is as follows:
An unexpected error happened during this operation.
[Query]-Query Designer encountered a Query error:
Unspecified error.
I dont know what to do. all i can think of is rebooting the computer, but it is the LIVE databases for webpages. please help me!
View 4 Replies
View Related
Feb 26, 2008
Hi
I am getting an error when i try to open MSEM. I have also tried to open this via mmc and get the same.
I have an attached a screen shot of the error. I tried re-installing SP4, but this did not fix it. Please help. We need to move our SQL to a new server and since I can't see any of it, I can't really manage it before the move.
I would appreciate any help.
Thanks
Jimmy
View 10 Replies
View Related
Jun 1, 2007
Hi all,
the SQL Management Studio keeps crashing out on me everytime i try to open a Lookup in one of my DTS packages i am using in the Legacy section.
I am copying the DTS package across and need to change the server connections (which i do), but then i was getting a permissions based error when the package ran when it tries to access the Lookup.
I tried to open the Lookup and the SQL Management Studio hanged when it tried to display the details for the lookup. It's done this many times and i have tried different files incase one was corrupted to no avail.
Anyone have any ideas of what i can try?
Thanks
Jordan
View 2 Replies
View Related
Oct 9, 2007
We've been opening pdf reports using SOAP for some time now and all of the sudden we're getting errors when the user is on IE6. IE7 is fine.
The error we're getting is from the Acrobat reader is:
"There was an error opening the document. The file cannot be found"
Here's the code that opens the report:
Dim report As Byte() = Nothing
Dim rs As report_engine2.ReportExecutionService = New report_engine2.ReportExecutionService
'credentials
rs.Credentials = New System.Net.NetworkCredential(rs_login, rs_password)
rs.PreAuthenticate = True
Dim reportpath As String = rs_folder & report_name
Dim zoom As String = "False"
Dim deviceInfo As String = Nothing
Select Case format
Case "HTML4.0", "HTML3.2"
deviceInfo = "<DeviceInfo>"
deviceInfo &= "<Toolbar>False</Toolbar>"
deviceInfo &= "<Parameters>False</Parameters>"
deviceInfo &= "<HTMLFragment>True</HTMLFragment>"
deviceInfo &= "<StyleStream>False</StyleStream>"
deviceInfo &= "<Section>0</Section>"
deviceInfo &= "<Zoom>" & zoom & "</Zoom>"
deviceInfo &= "</DeviceInfo>"
Case Else
deviceInfo = "<DeviceInfo></DeviceInfo>"
End Select
'array of parameters
Dim parameters(0) As report_engine2.ParameterValue '0 means one parameter in the report
Dim paramValue As report_engine2.ParameterValue = New report_engine2.ParameterValue
paramValue.Name = param1_name
paramValue.Value = param1_value
parameters(0) = paramValue
'variables for the remaining paramters
Dim historyID As String = Nothing
Dim credentials As report_engine2.DataSourceCredentials = Nothing
Dim showHideToggle As String = Nothing
Dim extension As String = GetExtension(mimeType)
Dim warnings() As report_engine2.Warning = Nothing
Dim reportHistoryParameters() As report_engine2.ParameterValue = Nothing
Dim streamIDS() As String = Nothing
Dim execInfo As New report_engine2.ExecutionInfo
Dim execHeader As New report_engine2.ExecutionHeader
rs.ExecutionHeaderValue = execHeader
execInfo = rs.LoadReport(reportpath, historyID)
rs.SetExecutionParameters(parameters, "en-us")
Try
'execute the report
report = rs.Render(format, deviceInfo, "", mimeType, "", warnings, streamIDS)
'set the filename
Dim fileName As String = savefilename & "." & extension
'write the report back to the response object
response.Clear()
response.ContentType = mimeType
'add the file name to the response if it is not a web browser format.
If mimeType <> "text/html" Then
response.AddHeader("Content-Disposition", "attachment; filename=" & fileName)
End If
'send the byte array containing the report
HttpContext.Current.Response.BinaryWrite(report)
HttpContext.Current.Response.End()
Catch ex As Exception
End Try
This used to work just fine until about a week ago. We're not sure if there was a MS update that caused this behavior. If the user saves the report to a local disk instead of opening it, they can save it successfully and open it later.
Any thoughts on where to go with this one?
Regards
View 1 Replies
View Related
Apr 17, 2008
Hi all,
I am using forms authetication to log in to reporting services. I am using logonuser method of reporting services web service. I am getting the following error when i try to log in
System.Web.Services.Protocols.SoapException: Server was unable to process request. --->
System.Exception: An error occurred while attempting to verify the user.Login failed for user 'SON-1499IUSR_SON-1499'.
at Microsoft.Samples.ReportingServices.CustomSecurity.AuthenticationUtilities.VerifyPassword(String suppliedUserName, String suppliedPassword)
at Microsoft.Samples.ReportingServices.CustomSecurity.AuthenticationExtension.LogonUser(String userName, String password, String authority)
at Microsoft.ReportingServices.WebServer.RSCustomAuthentication.LogonUser(String userName, String password, String authority)
at Microsoft.ReportingServices.WebServer.ReportingService2005Impl.LogonUser(String userName, String password, String authority)
at Microsoft.ReportingServices.WebServer.ReportingService2005.LogonUser(String userName, String password, String authority) --- End of inner exception stack trace ---
I have LocalMachine/ASPNET web service identity set in Reporting Services Configuration on Windows XP .
Thanks in advance.
Anupama
View 6 Replies
View Related
Jun 10, 2007
Hi guys. Im having alot of trouble with this. I have created a simple access database, uploaded to a doc library on a sharepoint site. Then I made a infopath form based on this by using the url: //207.245.47.37/sites/Safety_and_Training/ai/db2.mdb
I succeeded in creating the form. I then published it onto the sharepoint site. Now, when I try to fill out the form so the database can be filled in, I hit submit and it opens up a ADO warning telling me that the website is using my identity to connect to the datasource, I hit ok and then I get another window saying "Please enter MS JET OLE DB Initialization." In the fields it has 1) Datasource is \207.245.47.37sitesSafety_and_Trainingaidb2.mdb, the 2)username is Admin, 3)password is blank, 4)provider string is blank and the 5)open mode is on DB_Mode_Readwrite.
1. One thing I tried is in the username and password I give my administrator login as CorpdynatecRGill, and then the password I always use to login onto the site. It then gives me:
InfoPath cannot connect to the data source.
Not a valid account name or password.
2. Next thing I try is just leaving the username as admin and password blank but then I get the message:
InfoPath cannot connect to the data source.
The Microsoft Jet database engine cannot open the file '\207.245.47.37sitesSafety_and_Trainingaidb2.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
I think it might have something to do with the permissions, but nothing has been working yet. Please help me.
View 2 Replies
View Related
Dec 6, 2003
Hi,
I am trying to call a stored procedure to insert into my database. After I called Open(), it crashed on ExecuteNonQuery(). I get the following message.
Object must implement IConvertible.
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.InvalidCastException: Object must implement IConvertible.
Source Error:
Line 160:Try
Line 161:myConnection.Open()
Line 162:myCommand.ExecuteNonQuery()
Line 163:myConnection.Close()
What does this mean? If anyone encountered this error before, please let me know how to trace the error and fix it.
Thanks Gurus,
John
View 4 Replies
View Related
Sep 21, 2000
Greetings:
We have a database with approximately 15-20 tables. Last week, using Enterprise Manager, we were able to open any of these tables and return all rows. Yesterday, when we tried to do this, we got the following message:
An Unexpected Error happened during this operation.
[Query] - Query Designer encountered a Query Error: Unspecified Error
Can anyone tell me what might be causing this and how to fix it? Barring that, can anyone suggest some general steps I might take to possibly eliminate this problem without knowing the cause? Last, can you point me to a good resource for investigating problems of this kind, such as a knowledge base (other than Microsoft's TechNet)?
Many, many thanks.
View 1 Replies
View Related
Nov 26, 2006
I am trying to deploy my mobile app to treo 700wx, but when i test the app, the application gives me an error message:
sql mobile encountered problems when opening the database
It happens when I sync data.
However, when I sync data users and customer info, it doesn't give this message, But when I sync (third time) order info, this message comes out.
--when i run on my PPC (HP ra1950), there is no this error message.
I think it is a bug?
BTW, which cabs file should I install on the Treo phone? (.Net ce, sql ce mobile30 ???)
Please help me out. Thanks
James
View 3 Replies
View Related
Nov 7, 2007
Hi,
I am getting following error message while opening DTS package,
"No provider exist fro this connection on this computer", Invalid class string.
When I use the SQL Enterprise Manager (SEM) Return All Rows option to open a table, or you attempt to create or design a view, the following error occurs:
An unexpected error happened during this operation.
[Query] - Query Designer encountered a query error : unspecified error
This is working fine from remote enterprise manager.
Recently I have migrated all the databases including system databases from old server to new server.
I reinstalled latest MDAC to correct this problem, but I did not get any solution for this.
I have installed SQL Server service pack 4, do I need a SP4 re-install and how I can do this.
View 1 Replies
View Related
Nov 28, 2007
I posted this in the Sharepoint Designer forum, but did'nt get an answer...so trying here...Below is my soap endpoint in sql2005...works fine for InfoPath to consume the service...but when SharePoint Designer attempts to retieve data I get
"The server returned a non-specific error when trying to get data from the data source."
In SPD I can connect to the service and see the methods and parameters...but never get any data returned...wondering if it's in my endpoint setup. BTW-using Windows security by default in SQL2005...I've tried different types of logins without success...
/****** Object: Endpoint [getSCMADataEndpoint] Script Date: 11/28/2007 10:38:43 ******/
CREATE ENDPOINT [getSCMADataEndpoint]
AUTHORIZATION [SCMAadministrator]
STATE=STARTED
AS HTTP (PATH=N'/getscmadatawebservice', PORTS = (CLEAR), AUTHENTICATION = (), SITE=N'scmasvr01', CLEAR_PORT = 80, COMPRESSION=DISABLED)
FOR SOAP (
WEBMETHOD 'GetCourseInfo'( NAME=N'[SCMA].[dbo].[prGetCourseInfo]'
, SCHEMA=DEFAULT
, FORMAT=ROWSETS_ONLY),
WEBMETHOD 'GetCourseLectures'( NAME=N'[SCMA].[dbo].[prGetCourseLectures]'
, SCHEMA=DEFAULT
, FORMAT=ROWSETS_ONLY),
WEBMETHOD 'GetCourseLecturesInstr'( NAME=N'[SCMA].[dbo].[prGetCourseLecturesInstr]'
, SCHEMA=DEFAULT
, FORMAT=ROWSETS_ONLY),
WEBMETHOD 'GetCourseObjectives'( NAME=N'[SCMA].[dbo].[prGetCourseObjectives]'
, SCHEMA=DEFAULT
, FORMAT=ROWSETS_ONLY),
WEBMETHOD 'GetCourseRosterInfo'( NAME=N'[SCMA].[dbo].[prGetCourseRosterInfo]'
, SCHEMA=DEFAULT
, FORMAT=ROWSETS_ONLY),
WEBMETHOD 'GetSCMAAccounts'( NAME=N'[SCMA].[dbo].[prLookupSCMA_accounts]'
, SCHEMA=DEFAULT
, FORMAT=ROWSETS_ONLY),
WEBMETHOD 'GetSCMAAccounts_FieldNames'( NAME=N'[SCMA].[dbo].[prLookupSCMA_Accounts_FieldNames]'
, SCHEMA=DEFAULT
, FORMAT=ROWSETS_ONLY), BATCHES=DISABLED, WSDL=N'[master].[sys].[sp_http_generate_wsdl_defaultcomplexorsimple]', SESSIONS=DISABLED, SESSION_TIMEOUT=60, DATABASE=N'SCMA', NAMESPACE=N'http://tempuri.org', SCHEMA=STANDARD, CHARACTER_SET=XML)
View 4 Replies
View Related
Jan 16, 2005
Hello everyone. I'm very new to asp.net. I've been coding in vb.net for a while now (getting my associates degree in desktop application programming) and my boss wants all of my new applications to be web based now. Well, i decided to take some initiative on this and begin a new project for my department. This is a very small project. So far, everything is coming along alright (i found an eBook that's helped me quite a bit). Everything was cool until yesterday when i tried to connect to our sql server database. I get an error message stating:
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Because i'm testing this on my system as well as the remote system which hosts the application, i can see the error message on the remote system. Here is the error it's giving me:
Server Error in '/' Application.
--------------------------------------------------------------------------------
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
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: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Source Error:
Line 57: sConnString = "Server=F11602A2120564OPS;Initial Catalog=OpsMonitor;User ID='public';Password=;Integrated Security=SSPI;"'Connection String
Line 58: sConn = New SqlConnection(sConnString)'Initialize New Connection
Line 59: sConn.Open'Open the connection
Line 60: End Sub
Line 61: </script>
Source File: c:inetpubwwwrootatm_reporting.aspx Line: 59
Stack Trace:
[SqlException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +474
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372
System.Data.SqlClient.SqlConnection.Open() +383
ASP.atm_reporting_aspx.OpenConn() in c:inetpubwwwrootatm_reporting.aspx:59
ASP.atm_reporting_aspx.Page_Load(Object Src, EventArgs E) in c:inetpubwwwrootatm_reporting.aspx:23
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
You can see my SQL Connection string in there as well. Can someone please help me with this? I can post the code to the entire page as well if that would help. I'm developing this with Dreamweaver MX 2004 (i like dreamweaver MUCH better than visual studio, especially for web design/development). Thanks,
Eric
View 1 Replies
View Related
Aug 12, 2007
To anyone that can help me
we have a application written in straight ASP, we recently upgraded our SQL database connecting to the application from SQL 2000 to 2005 here is the issue
currently SQL 2005 is located in our test and UAT environments, SQL 2005 is not clustered in either location. Now let me make it clear THIS PROBLEM IS NOT HAPPENING IN OUR TEST ENVIRONMENT, I REPEAT THIS PROBLEM IS NOT HAPPENING IN OUR TEST ENVIROMENT, THIS PROBLEM IS ONLY HAPPENING IN OUR UAT ENVIROMENT
Each enviroment is outfitted with the following SQL 2005 environment, Enterprise Edition SP1 with Cumlative hotfix package 2153 just the SISS fix ONLY
now the problem is this, we have a vb program located directly on the server that has SQL 2005 on it that VB program inserts a timestamp into a table inside the database, now how this happens is the program connects to the database and opens a recordset with a forwardonly cursor and inserts the timestamp
NOW THE EXACT PROBLEM IS THAT THE VB PROGRAM CANNOT OPEN MULTIPLE RECORDSETS, THE ERROR RECEIVED IS LABLED LIKE THIS
ODBC DRIVER ERROR 8000405 SHARED MEMORY SQL DOESNT EXIST OR ACCESSED DENIED,
NOW here is the interesting part, AGAIN THIS IS NOT HAPPENING IN OUR TEST ENVIRONMENT, THE VB PROGRAM AGAIN IS ON THE TEST SQL SERVER AND HAS A FORWARD ONLY CURSOR AND INSERTS JUST FINE
NOW IF I MOVE THE VB PROGRAM OUT OF OUR UAT ENVIRONMENT ONTO ANOTHER SERVER IT INSERTS THE RECORD ONTO SQL SERVER JUST FINE, IT OPENS THE RECORDSET AND OPERATES NORMALLY, BOTH SERVERS HAVE EXACT SAME PERMISSIONS
Can anyone help me understand whats happening here
One note, when we changed the cursortype from forward-only to keyset it worked fine but that doesnt explain things
why does it work in test so clearly what we did with changing the cursortype isnt the answer
Thanks please consider this a urgent request
View 5 Replies
View Related
