HTTP POST In SQL Server 2005

Sep 14, 2007

hello, i have this summarized stored proc. Problem is, when using
'Send', my aspx page reads (asp.net)Request.Form as empty

However, when I use a simple html file to post, it works. Does anyone
know what's wrong?

EXEC @iHr = sp_oaCreate 'Msxml2.ServerXMLHTTP.3.0',@iObject OUTPUT

declare @data as nvarchar(max)
set @data = 'boo=yeah'

EXEC @iHr = sp_OAMethod @iObject, 'Open', null,
'POST',@smtpWebService, 0

EXEC @iHr = sp_OAMethod @iObject, 'setRequestHeader', null, 'Content-
Type', 'application/x-www-form-urlencoded'

EXEC @iHr = sp_OAMethod @iObject, 'send',null,@data

while @State<>4
begin
exec sp_oagetproperty @iObject, 'readyState', @State output
end

EXEC @iHr = sp_OAGetProperty @iObject, 'responseText',@retVal OUT

print @retVal

EXEC sp_OADestroy @iObject

View 2 Replies


ADVERTISEMENT

HTTP Post

Jun 21, 2004

Hi,

Is it possible to write a stored procedure which can post an XML file to a server using HTTP?

Thanks!

View 6 Replies View Related

Post To HTTP With Paramerters Options

Jul 16, 2007

Hi,


Please could some of the experts out there advise on the best way to acheive the following please. . .



In a SQL table, I have a field that when it drops to below 5, i want to automatically run a Stored Procedure that then connects to a URL to run a ASP.NET script.



IE:
In table users, there is a field called Money.
When Money reaches < 5
Run Stored Procedure
The Stored Procedure then 'somehow' sends a trigger to a URL with
paramerters as per below
www.mydomainname.com?money=4&name=peter



Any help/guidence appriciated as i am really lost on where to start!

Thanks
H

View 5 Replies View Related

SQL Server 2005 And Post SP2

Jan 25, 2008

Hi there

We've just starting rolling out SQL Server 2005 SP2 (9.0.3042) on 1 single server and some clusters.

Generally we are never implemented post fix etc etc just service pack. I can see more post fixes comes out. For the single box, what is the best practise to apply this upgrade? Apply this fix and hoping no issue :) I guess testing it's the best but if you get the so many hot fixes thay means have to test one by one?

How do you for the cluster? Once you update one node, does it actually update the second node as well?

Waiting for the feedback.

Thanks

View 1 Replies View Related

Change Reporting Services Default URL (From Http://server/reports To Http://CompanyReports)

Jul 31, 2007

I looked online and couldn't find anything to help me make this change. I want to change the default URL for reporting services to another url. Is this possible? Any assistance would be greatly appreciated.

View 3 Replies View Related

Access SQL Server 2005 Via HTTP

Jun 18, 2007

Hi



Is it possible to access sql server 2005 via http and do some management and administration task?



Thanks in advance,

Larry

View 1 Replies View Related

What Happens To My SQL Express When I Post My Site To Full SQL 2005 Server

Jan 9, 2006

Lets say I use the 'enabling roles' for my ASP 2.0 site. This creates a ASPNETDB.DBF SQL Express file.
Later I go to post this to a real web server - which runs the 'full' MS SQL2005 server. What happens to the ASPNETDB.MDF file (or for that matter, any other MDF file I create with SQL Express) when it leaves the Express world and enters the Real world.

View 4 Replies View Related

2nd Post - Problem Installing SQL Server 2005 Express SP2

Feb 27, 2007

Hi,

I started applying "SQL server Express with advanced tools SP2" and had to stop on following items which I'm not too sure about what I must understand from step "Existing components". Those three items listed were:

- "SQL Server DataBase Services 9.1.2047.00"

=> which I can check

- "Reporting Services 9.1.2047.00"

=> which I can check

- Workstation components and development tools 9.1.2047.00

=> which is simply disabled???

If I then look at the details of that last item, I can see the following warning:

Name: Microsoft SQL Server 2005 Tools

Reason: Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

Edition check:

Your upgrade is blocked because of edition upgrade rules. For more information about edition upgrades, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

Now, following the suggestion of one person answering previous thread,

"If you're not sure if you have tools from another edition, you can check by going to Add/Remove Program, selecting the Microsoft SQL Server 2005 entry and clicking Change..."

I followed suggestion and got following result:

DEVELOPPEMENT

The following components are installed on this server

SQLEXPRESS



Database Engine

[Version: 9.1.2047.00 Edition: Express Edition Patch level: 9.1.2047 Language: Anglais (États-Unis)]

Reporting Services

[Version: 9.1.2047.00 Edition: Express Edition Patch level: 9.1.2047 Language: Anglais (États-Unis)]

Common components



Workstation Components

[Version: 9.1.2047.00 Edition: Express Edition Patch level: 9.1.2047 Language: Anglais (États-Unis)]

Looking at the results, everything seems to be normal. Only Express Edition, all same level which should be SP1. What step should I take to be able to upgrade to SP2 properly?

Thanks in advance,

Stéphane

P.S.

From "Add/Remove Programs" I have, all listed, the following SQL Server installed programs:

- Microsoft SQL Server 2005

- Microsoft SQL Server 2005 Backward compatibility

- Microsoft SQL Server 2005 Books Online (English) (July 2006)

- Microsoft SQL Server 2005 Compact Edition (ENU)

- Microsoft SQL Server 2005 Compact Edition Books Online (ENU)

- Microsoft SQL Server 2005 Compact Edition Developer Software Development Kit (ENU)

- Microsoft SQL Server 2005 Compact Edition Tools for Visual Studio 2005 (ENU)

- Microsoft SQL Server Management Studio Express

- Microsoft SQL Server Native Client

- Microsoft SQL Setup Support Files (English)

- Microsoft SQL Server VSS Writer

View 7 Replies View Related

SQL Server 2005, SQL Server Mobile, SQL Server Management Studio. Unsupported HTTP Function Call

Sep 5, 2005

Hi All,

View 14 Replies View Related

SQL Server 2005 Rendered Unable To Start Post SP2 Install. Help!

Jun 12, 2007

Hi can someone help me please? I browsed through the SP2 install feedback below, but it doesn't quite seem to fit what happened to my install. My .MDF and .LDF files for the system databases are in C:Program FilesMicrosoft SQL ServerMSQL.1MSQLData (I presume this is the correct location.)

I am the local administrator on this box.

I uploaded the .CAB file with all the logs onto www.sendspace.com if it gives you something to go on.

The only other thing of note is that it said there were two machines on the network and that I needed to change my machine name in the control panel when I installed. This doesn't seem right, as far as I understand the computer name is unique.

The SQL Server runs under the local system account, if that is of any use.

I attempted uninstalling and reinstalling the SQL native client MSI package in the hope it would be a simple fix similar to that chap further down the page, but that didn't help at all either.

.CAB file of installation logfiles is here: http://www.sendspace.com/file/7ihoet

kind regards
Jason




ERRORLOG starting SQL Server post failed SP2 install



2007-06-12 19:55:21.94 Server Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)
Feb 9 2007 22:47:07
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

2007-06-12 19:55:21.96 Server (c) 2005 Microsoft Corporation.
2007-06-12 19:55:21.96 Server All rights reserved.
2007-06-12 19:55:21.97 Server Server process ID is 5468.
2007-06-12 19:55:21.97 Server Authentication mode is MIXED.
2007-06-12 19:55:21.97 Server Logging SQL Server messages in file 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG'.
2007-06-12 19:55:21.97 Server This instance of SQL Server last reported using a process ID of 5756 at 12/06/2007 19:36:35 (local) 12/06/2007 18:36:35 (UTC). This is an informational message only; no user action is required.
2007-06-12 19:55:21.97 Server Registry startup parameters:
2007-06-12 19:55:21.99 Server -d C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmaster.mdf
2007-06-12 19:55:21.99 Server -e C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG
2007-06-12 19:55:21.99 Server -l C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmastlog.ldf
2007-06-12 19:55:22.00 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2007-06-12 19:55:22.00 Server Detected 4 CPUs. This is an informational message; no user action is required.
2007-06-12 19:55:22.17 Server Address Windowing Extensions is enabled. This is an informational message only; no user action is required.
2007-06-12 19:55:22.33 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2007-06-12 19:55:22.57 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2007-06-12 19:55:23.60 Server Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2007-06-12 19:55:23.63 Server Database mirroring has been enabled on this instance of SQL Server.
2007-06-12 19:55:23.72 spid5s Starting up database 'master'.
2007-06-12 19:55:24.07 spid5s SQL Trace ID 1 was started by login "sa".
2007-06-12 19:55:24.11 spid5s Starting up database 'mssqlsystemresource'.
2007-06-12 19:55:24.13 spid5s The resource database build version is 9.00.3042. This is an informational message only. No user action is required.
2007-06-12 19:55:24.29 spid5s Server name is 'GBLOND088SQ8MSQL_CREDS_DEV1'. This is an informational message only. No user action is required.
2007-06-12 19:55:24.29 spid9s Starting up database 'model'.
2007-06-12 19:55:24.30 Server Error: 17182, Severity: 16, State: 1.
2007-06-12 19:55:24.30 Server TDSSNIClient initialization failed with error 0x34, status code 0x1e.
2007-06-12 19:55:24.30 Server Error: 17182, Severity: 16, State: 1.
2007-06-12 19:55:24.30 Server TDSSNIClient initialization failed with error 0x34, status code 0x1.
2007-06-12 19:55:24.30 Server Error: 17826, Severity: 18, State: 3.
2007-06-12 19:55:24.30 Server Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
2007-06-12 19:55:24.30 Server Error: 17120, Severity: 16, State: 1.
2007-06-12 19:55:24.30 Server SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.

View 7 Replies View Related

SQL Server 2005 Integration Service (SSIS) Reading HTTP Data

Jan 16, 2008



I need to read in general web pages (not a web service) from a typical web site using SSIS and make it available for other SSIS transformations (Script Component). I tried using the XMLSource data source but this appears to require well formed XML, and will not accept HTML which is what I am likely to be getting from the web pages.
I tried a HTTP Connection Manager with a DataReader Source, but seems to only accomodate web services.

Can this be done? If someone has an example (tutorial) of how to accomplish this I would greatly appreciate a copy.
James

View 1 Replies View Related

Configuring Http Access To SQL Server 2005 Analysis Services On Vista

May 25, 2008

Does anyone have instructions on how to configure http access to SQL Server 2005 Analysis Services on Vista?

View 5 Replies View Related

Http Endpoints For SOAP In SQL Server 2005 - Can The Stored Proc Referenced Do More Than Select?

Feb 17, 2008

I am new to web services and as a DBA I only have limited .net experience. Our development team is creating a web services interface for our new IVR phone system, and we've decided on a solution that will send each of the phone call parameters from our database to the phone system in an XML based on line number and extension. I've found that Http Endpoints in sql server will be a perfect solution for exactly that and I won't need any .net to develop it. Thats the good news. There are, however, other requirements for our phone system to communicate back to our database. All of the examples I've seen for endpoints use a stored procedure performing a select statement.

Is it possible to create an endpoint that references a stored procedure performing an insert or update? To be more specific, can I create an endpoint that references a stored procedure that has parameters? If so, how do I pass those parameters through a web service request? Is it as simple as adding &variable="value" to the url?

If so I could develop this entire solution from the database side and not involve our .net programmer!

Another alternative: the phone system does have it own database in sql server. I'm not sure if our phone system provided can or will do this, but if they are willing to work with this, maybe a service broker can fit into this solution.

I look forward to any response. Thanks!

View 5 Replies View Related

Installation Of SQL Server 2005 Post-SP1 Hotfix 918222 (Build 2153) Fails At Copyengine.cpp Line: 689

Feb 5, 2007

I believe that I mistakenly attempted to apply the Analysis Services component of this update before applying the SQL Server component. The update now fails continuously with the following message:

02/05/2007 17:58:24.990 ================================================================================
02/05/2007 17:58:25.021 Hotfix package launched
02/05/2007 17:58:27.615 Product discovery successfully completed during the install process for MSSQLSERVER
02/05/2007 17:58:27.630 SP Level check successfully completed during the install process for MSSQLSERVER
02/05/2007 17:58:27.646 Product language check successfully completed during the install process for MSSQLSERVER
02/05/2007 17:58:27.661 Product version check successfully completed during the install process for MSSQLSERVER
02/05/2007 17:58:27.677 Command-line instance name check completed during the install process
02/05/2007 17:58:27.693 Baseline build check completed during the install process
02/05/2007 17:58:34.864 Attempting to install instance: MSSQLSERVER
02/05/2007 17:58:34.974 Attempting to install target: CHARLIDEVSRV
02/05/2007 17:58:35.005 Attempting to check for locked files: sqlrun_sql.msp
02/05/2007 17:58:35.052 Attempting to check for locked files: \CHARLIDEVSRVf$44923e05996203228c1608bea1hotfixsqlFilessqlrun_sql.msp
02/05/2007 17:58:35.067 Creating MSP locked file check log at: C:WINDOWSHotfixSQL9LogsSQL9_Hotfix_KB918222_sqlrun_sql.msp.out
02/05/2007 18:01:52.978 MSP returned 1635: This patch package could not be opened. Verify that the patch package exists and is accessible, or contact the application vendor to verify that this is a valid Windows Installer patch package.
02/05/2007 18:01:53.009 Unable to check MSP file: \CHARLIDEVSRVf$44923e05996203228c1608bea1hotfixsqlFilessqlrun_sql.msp
02/05/2007 18:01:53.025 The following exception occurred: Unable to install Windows Installer MSP file Date: 02/05/2007 18:01:53.025 File: depotsqlvaultstablesetupmainl1setupsqlsesqlsedllcopyengine.cpp Line: 689
02/05/2007 18:01:53.212 Failed to install instance: MSSQLSERVER
02/05/2007 18:01:53.259
02/05/2007 18:01:53.259 Product Status Summary:
02/05/2007 18:01:53.290 Product: SQL Server Database Services 2005
02/05/2007 18:01:53.306 MSSQLSERVER - Failure
02/05/2007 18:01:53.321


The update fails although I have cleaned the registry of any reference to it. Another article indicated that the hotfix may delete registry keys required, for instance, to operated SSIS if applied in the wrong order. Here, it appears to be preventing the hotfix from being reapplied. I have ensured that all necessary permissions are available and the services are running in domain user accounts with the necessary rights. I'm the administrator on the machine.

Is there a way to get this hotfix applied without having to completely rip and rebuild my server instance?

View 4 Replies View Related

Refering To Distinct Values Post(My Other Post)

Oct 22, 2007

---------------------------------------------------------------
My Original Post
I have to query n table(NLRImports) using the Distinct keyword, to retrieve a set of ID numbers. ( "Select DISTINCT id_nbr from NLRImport" ).

Now i want to use those values i retrieved, to process the records in the table(NLRImports) 1 by 1. How do i use those ID no's i retrieved as Variables or parameters for my next query?? If this makes sense?
----------------------------------------------------------------

First, thanks for the response.... now here is what im trying to do.
I created a simple application in delphi to import information to a table in MSSql2005. This is some of the resulting columns...

date | id_nbr | account_nbr | sub_account_nbr | ... etc
-------------------------------------------------------------

Now there will be several entries with the same id no but on different dates, so i take it dates would rather be my pkey.

Then i need to take one person's entries(i work on id_nbr) and go thru all the entries taking the earliest date and comparing all the other entries for that person to the first date and select all the dates more than 19 days after the first date and less than 91 days from first date and place it in a new table.
I used cursor s and while loops to kind of get it going but i know that cursors are not really recommended use but the performance implications dont bother with this particular job.

What other ways should i be using to accomplish this?

thanks, i hope this is clear...

View 1 Replies View Related

HTTP Error 403 - SQL Server 2005 And ASP.NET Version 1.1 Apps Side-by-side

Aug 31, 2006

I have a Windows 2003 Server running IIS 6.0 and SQL Server 2005. I have just (Today) deployed the first ASP.NET application (developed in Visual Studio 2003 and, as such, dependent on .NET Framework 1.1) on this server and am getting HTTP Error 403 (You are not authorized to view this page). This ASP.NET application runs fine on another server that is configured with the OS=Windows Server 2003, IIS=6.0 but without SQL Server 2005 and without the .NET Framework version 2.0. I found in the IIS Application configuration (on the troublesome site) that my app (in the Default Web Site folder) was pointing to the version 2.0 aspnet_isapi.dll. All efforts to use aspnet_regiis to "re-align" my app with version 1.1 have been fruitless to eliminate the HTTP Error 403. I granted the NETWORK SERVICE account privledges to the wwwroot folder. At this point, I don't know if I have a Framework error or a privileges problem.

Please help.

Thanks,

Rob

View 1 Replies View Related

Where Do I Post Reporting Services 2005 Questions

Aug 28, 2007

Where do I post Reporting Services 2005 Questions

Thank you,

View 1 Replies View Related

Support For SQL DTS Packages Post Upgrade To SQL 2005

Feb 15, 2007

Hi,

I am unclear on Microsofts policy regarding support for DTS and packages that have been imported (but not migrated) to SQL 2005.

The upgrade advisor states
SQL Server 2000 Data Transformation Services   
Advisory   
SQL Server 2000 Data Transformation Services is deprecated  You must completely migrate existing SQL Server 2000 Data Transformation Services (DTS) packages to SQL Server 2005 Integration Services packages before support is withdrawn. 
 
Source Type: MSDB Package
 
What does this really mean?  What will happen to the importing of legacy packages and this whole area within Management Studio? Will these 2005 features no longer be supported? What will happen to the Execute 2000 task?  If I upgrade a SQL 2000 instance post 08/04/08 does this mean that I won't receive support from Microsoft even though the package post installation is in SQL 2005.  Will the new dts designer in the feature pack be taken away/withdrawn?
 
To say DTS packages will no longer be supported is a very dramatic statement with far reaching consequences.  How is this going to be effectively implemented?  Is there really going to be no backward compatibility support in Katmai?
 
Cheers, James

View 2 Replies View Related

Post 2005 SP2 Install, No Script Component Can Be Edited.

Feb 26, 2007

Anyone starting to see "Cannot show Visual Studio for Applications editor. (Microsoft Visual Studio)" after installing SQL Server 2005 SP2 on x86 machines?  Second, how can it be fixed?

After installing SP2, the script component editor will not edit script components created in pre SP2 releases. (I also have Visual Studio 2005 SP1 installed). The script TASK editor will start, but when attempting to open a script COMPONENT in the VSA editor, a script component created for pre-SP2 packages, the following error dialog occurs.

Cannot show Visual Studio for Applications editor. (Microsoft Visual Studio)

This same error dialog has occurred on multiple computers, none of them are running Vista (rather Windows XP SP2). All of the pre-existent pre-SP2 script components have Precompile set to true as well, since they are intended for 64 bit machines.

Now, certain posts say, register DLLs in the following directories via:
for %i in (*.dll) do RegSvr32 -s %i.

C:Program FilesCommon FilesMicrosoft SharedVSA8.0common
C:Program FilesCommon FilesMicrosoft SharedVSA8.0vsa

One problem with these instruction is that the second directory doesn't even exist, however, a directory called "C:Program FilesCommon FilesMicrosoft SharedVSA8.0VsaEnv" does exist, which is perhaps what was meant. Even after registering the DLLs there, the script component editor will not open (erroring out after clicking the "Design Script..." button).

View 28 Replies View Related

How To Do Post-build Events In Reporting Services 2005

Oct 16, 2007



Does anyone know if it is possible to do Post-Build Events in Reporting Services? I am using Visual Studio 2005 Team Edition and creating Reports under the Business Intelligence Projects.

When creating C# projects, when you right click on the solution and go to properties there is a tab for Build Events at which point you can create Pre-build and Post-build events; however I am not finding this option available within a Reports project. Does anyone know if this is possible to do in Reporting Services?

Basically what I am trying to accomplish is, I am having to create multiple template files and there are multiple developers going to be working on this project and I would like to create a batch file of some sort that copies the template files that are created into the IDEPrivateAssembliesProjectItemsReportProject directory each time the project is built.

Thanks for any advice,
Flea

View 2 Replies View Related

How To Make HTTP Request From SQL 2005

Oct 28, 2007

Hi All,


I want to make a simple http request from SQL to a web server, something like this:
HTTP_REQUEST('http://www.domain.com/page.asp?var=value')
I don't want to get any response back, just a request.
Is there something like this in SQL 2005? or if anyone had wrote something like this.. I'll be greatfull if you can help me.

Thanks in advance

View 1 Replies View Related

Send HTTP Request Using SQL Sever 2005

Apr 16, 2007

I have Lotus Notes Database which stores employee database. If I request following http URL on browser, which fetch data from Lotus Notes Database and response me following XML text. I need to pass some id as a parameter in HTTP request to retrieve particular data.

HTTP Request:
http://kernel.com/global/corp/ecd.nsf/xmlemployeesactivebyguid?readviewentries&StartKey=sesa249&count=1

HTTP Response:
<?xml version="1.0" encoding="UTF-8" ?>
<viewentries toplevelentries="53656">
<viewentry position="14310" unid="FC86BCB9224169F4C12570AD005A775C" noteid="D9FA2" siblings="53656">
<entrydata columnnumber="0" name="GUID">
<text>SESA24941</text>
</entrydata>
</viewentry>
</viewentries>

I need to send this http request programmatically. To do that,

1) Is thr any functionality in SQL Server 2005, which can send http request to any other server like LOTUS NOTES
2) If not,thn do you know how to do it programmatically using c# ?

When U have some time, let me know. Thanks in advance man.

Satyam

View 4 Replies View Related

Dropdownlist Resetting On Post Back, ??SQL 2005 Express Database Problem

Apr 21, 2008

Hi all,
I am trying to write a web page connected to an sql database of my MP3 files.  I have a dropdown list box that populates with the artist,  this hopefully being used to filter results into a datagrid.  However,  i am having a problem with the ddlb box repopulating on post back,  i trawled the news groups and coded the population of the ddlb within an "if not page.postback" statement but to no avail.  If i connect the ddlb to another sql database i have,  the page reloads with the selctedvalue retained.  So the theory is now that it is the SQL database,  (is this a limitation of SQL express?) and i am having troubleshooting this.  Here is the SQL of the databse:
USE [mp3]GO/****** Object:  Table [dbo].[Table_1]    Script Date: 04/21/2008 20:40:21 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE TABLE [dbo].[Table_1]([Title] [nvarchar](50) NOT NULL,[Artist] [nvarchar](50) NULL,[Album] [nvarchar](50) NULL,[Year] [nvarchar](25) NULL,[Comment] [nvarchar](500) NULL,[TrackNumber] [nvarchar](10) NULL,[path] [nvarchar](300) NOT NULL,[genre] [nvarchar](25) NULL,[id] [int] IDENTITY(1,1) NOT NULL,CONSTRAINT [PK_Table_1_1] PRIMARY KEY CLUSTERED ([id] ASC)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]) ON [PRIMARY]
Any help much appreciated.
 
Cheers
 
Billy

View 17 Replies View Related

Report Builder - Filter Dropdown Order Post 2005 SP2 Incorrect

Mar 7, 2007

Hi All,

Hope someone can help here. Since installing Service Pack 2 onto our SQL 2005 instances our report models are not working correctly. When selecting fields within the models as filters, and getting them to prompt when the report is run, the ordering of the data within the filters does not match the selected ordering in the model definition. The ordering is random each time the report is run.

This issue does not happen when setting the filter up, the data appears in the correct order, but when running the report the filter data is incorrect.

I have spent the last 4 hours building a new system and testing this with each stage of service packing. The RTM version of SQL 2005 is ok, SP1 is also OK, but when SP2 is applied the ordering fails.



Any ideas?



Many thanks in advance.



Regards



Nick

View 4 Replies View Related

Access My SQL 2005 Express Database Using Http/https

Nov 22, 2006

Hi!

I'm new using MSSql 2005 Express. How can i access my DB using http/https for reporting and DB changes/administration?



Regards,

JP

View 1 Replies View Related

Http://localhost/reportserver Works Http://&&<servername&&>/reportserver Doesn't

Aug 1, 2007

Hi All,

I have setup SSRS 2000 and gotten it to work but I am having trouble with SSRS 2005. I can't access to reportserver anywhere on the network. The only way to get to reportserver is termserv into the server and hit it with http://localhost/reportserver The server is Windows 2003 server Standard Ed. running SQL 2005 SP2 and Sharepoint Portal Server 2007. Can somebody please help? Thank you.

View 11 Replies View Related

POST BACK TO SERVER

Aug 31, 2007

hi all,

View 2 Replies View Related

Cannot Post In Some Forums -can't Find Server HELP

Aug 10, 2007

Moderators help

I cannot post in some forums. For example I am trying to reply to this forum

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=87688

But it won't post and I get cannot find server and there are some other posts as well. What could be the problem

Here is my reply just in case somebody else can post it there.


CREATE TABLE #Table1 (C1 money)

INSERT INTO #Table1 VALUES(4.13)
INSERT INTO #Table1 VALUES(4.24)
INSERT INTO #Table1 VALUES(6.76)
INSERT INTO #Table1 VALUES(5.17)
INSERT INTO #Table1 VALUES(5.29)

select convert(varchar(20),C1) from #table1

Ashley Rhodes

View 5 Replies View Related

3rd Post - Problems Installing SQL Server SP2

Mar 5, 2007



Hi again,

I'm still stuck with my problem. Going back to first post, the original problem was that, when applying "SQL server Express with advanced tools SP2", I had to stop because of following item which was disabled:

- Workstation components and development tools 9.1.2047.00

=> which is simply disabled???

Then from 2nd post, I could verify from Add/Remove Programs that all components installed for SQL Server 2005 were Express edition.

SQLEXPRESS



Database Engine

[Version: 9.1.2047.00 Edition: Express Edition Patch level: 9.1.2047 Language: Anglais (États-Unis)]

Reporting Services

[Version: 9.1.2047.00 Edition: Express Edition Patch level: 9.1.2047 Language: Anglais (États-Unis)]

Common components



Workstation Components

[Version: 9.1.2047.00 Edition: Express Edition Patch level: 9.1.2047 Language: Anglais (États-Unis)]

Also, following explanations from Mike, I could check that the toolkit that was installed was also from Express Edition looking at following registry key:

"You can do so in the registry at HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server90ToolsSetup. Look at the Edition Type..."

Finally, a question still remain. Starting from the fact that I originally applied SQL Server 2005 SP1 with success using following sequence:

SQL Server 2005 Express Edition with advanced services SP1

SQL Server 2005 Express Edition Toolkit SP1

and that I could verify, following Mike's suggestion, that all SQL Server Software found in registry (HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL Server90...) are all listed (vs Edition type) as Express editions:

==> Should I apply the "Express Edition Toolkit SP2" before applying the "SQL Server 2005 Express with advanced Services SP2"???

Many thanks for your support and hope to hear from someone!

Stéphane

View 10 Replies View Related

SQL Server Install On A Post SP2 Machine

Mar 19, 2007

Today I attempted to install SQL Reporting Services on a box that only has the OLE DB driver for Analysis Services and the MSXML components; both of which are SP2.

When running the SQL Server 2005 install to install SSRS, I get an error:

"SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme."

This box has barely anything on it aside from ProClarity Analytics Server and the components I mentioned above. My only guess is that the SQL 2005 installer sees some newer components that are SP2 and it thinks they are beta? I know for sure I do not have any beta software on this machine.

Any ideas?

View 2 Replies View Related

SQL Server Connection Thru HTTP

Mar 30, 2006

Hello SQL gurus.

I just wanted to kmow if we can connect a SQL server DB , located at some remote geographical location, via HTTP protocol.



Thanks in advance.
Ankit

View 3 Replies View Related

Accessing Sql Server 2000 With Http

Apr 12, 2006

Hi there,
I want to access to sql server 2000 on localhost with http
.Following instructions on "Sql Server books online", If I perform on Window Server 2003 R2 operating System, the result was not unsuccessful. However, on Window XP, the result was successful.

View 2 Replies View Related

Make Http Request From Sql Server Database

Dec 10, 2007

I would like to make an http request from sql server database and store the data in xml type. What are the steps involved?

In Oracle it can be done pretty easily using utl_http procedure. Any suggestions would be appreciated.

Thanks,
Ramki

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved