Client Side Cursor Vs Sever Side Cursor?
I having a difficult time here trying to figure out what to do here.
I need a way to scroll through a recordset and display the results
with both forward and backward movement on a web page(PHP using
ADO/COM)..
I know that if I use a client side cursor all the records get shoved
to the client everytime that stored procedure is executed..if this
database grows big wont that be an issue?..
I know that I can set up a server side cursor that will only send the
record I need to the front end but..
Ive been reading around and a lot of people have been saying never to
use a server side cursor because of peformance issues.
So i guess im weighing network performance needs with the client side
cursor vs server performance with the server side cursor..I am really
confused..which one should I use?
-Jim
View Complete Forum Thread with Replies
Related Forum Messages:
Server Side Cursor
In Access 2002 (project) I have used the following code in order touse a server side cursor,Set cnnClientFrm = CurrentProject.ConnectioncnnClientFrm.CursorLocation = adUseServerDo you need to configure anything on the SQL server side to make thiswork or make it work more efficently?The reason I ask is that I just have tried switching this betweenadUseServer and adUseClients on a connection that then is used to loada particularly large recordset and it doesn't seem to make anyperformance difference that I can determine.Thanks,Bob.NB: I posted this originally in the Access group but got no replied soI am reposting here.
View Replies !
Server Side Cursor
How do you configure the server side query? What is the connection string lke? What are the advantages of using the serevr side query? When is it best to use it and why? Please explain so that l understand it.
View Replies !
Server Side Cursor
Hi all, I am running a SQL query which has joins on 2 tables, and performs SORT. The Server side cursor is enabled when this query is submitted through my java application. The number of records that I am handling here is around 60 million on the main table. This query works perfectly well, when i sort on a non-indexed column, but if I try to sort on an indexed column the query runs indefinitely, and never stops. This same query runs good if I disable the Server side cursor. And works good even when the data size is less with server side cursor enabled. I am unable to figure out where the problem could be. Can anyone help me with this. Following is my server config : DataBase : SQLServer 2000 Standard Edition. OS : Win 2000 Server Disk Space : C(boot) - 4GB , D(Data) - 200GB, F(tempdb) - 40GB, E(trxn) - 40GB. Database Size - 72GB on D, rest of the space is unused. RAM size - 4GB OS Swapping space - 8GB Processors - 4 x 702 Mhz. Looking forward to your response. Thanks, Vijay.
View Replies !
Enforcing Rule: Client Side Or Server Side?
Hi, In Analysis Services there is an option to enforce a role either on the client side or the server side. Can someone kindly guide what's the recommended approach and what's really the difference between the two options. Thanks.
View Replies !
SQL2005 And SQL2000 Client-Tools Side-by-Side?
We have some developers who manage SQL2000 servers from their WinXP workstations using Enterprise Manager. We have now rolled out our first SQL Server 2005. Can we install the SQL2005 Management Studio side-by-side with Enterprise Manager on these WinXP workstations? If not, what are most people doing in these cases? Thanks! Mike Hiland
View Replies !
Server Side Block Cursor
Forgive me if this is a stupid question. How do you use a Server Side block cursor? Lets say I have a db of 250,000 items and I want to retrieve the data 100 rows at a time. How would I do this (using a block cursor, not in general) thanks,
View Replies !
Mdac 2.8 And Sql 2005 Server Side Cursor Performace Issue
Hello I have a VB6 application using classic ado (MDAC 2.8) for connecting ms sql 2000 server. Application uses a lot of server side cursors. Now I want to switch to ms sql 2005 server but I have noticed very serious performance problem. Sql profiler results of execution of following commands: declare @p1 int set @p1=180150131 declare @p3 int set @p3=1 declare @p4 int set @p4=16388 declare @p5 int set @p5=22221 exec sp_cursoropen @p1 output,N' Select ... from ... where .... order by ...',@p3 output,@p4 output,@p5 output select @p1, @p3, @p4, @p5 on sql server 2000: CPU: 234 Reads: 82515 Writes: 136 Duration: 296 and on sql server 2005: CPU: 4703 Reads: 678751 Writes: 1 Duration: 4867 Both databases are identical, the servers runs on the same machine (Pentium 2,8 Ghz, 2 GB RAM) with only one client connected. On forums I've read that Microsoft doesn't recommend using server side cursors on sql 2005 but is there any way to increase performance to some acceptable level? thanks in advance szymon strus
View Replies !
HTTP Error 403 - SQL Server 2005 And ASP.NET Version 1.1 Apps Side-by-side
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 Replies !
Configuring Merge Replication For Side-by-side SQL Server 2000 And 2005
I am trying to migrate from my current system, where I do merge replication from Windows Mobile devices running SQL Server CE 2.0 to a central database running SQL Server 2000 sp3a. I want eventually to move to a system running SQL Server 2005 CE replicating to a SQL Server 2005 back-end. But the transition will need to be gradual, and I may have to support both systems for a while until I can convert all clients from the old system to the new. I also need to do thorough testing. So ... I'm trying to set up a test environment giving me the maximum possible flexibility to do my testing. Ideally, I'd like to set up SQL Server 2000 and SQL Server 2005 on a side-by-side basis, in a manner that would potentially allow mobile devices running both SQL Server CE 2.0 and SQL Server 2005 CE to sync with either back-end server. Can someone provide me with guidance as what is possible to set up here? I know that SQL Server 2000 and 2005 can be installed side-by-side on the same server. It also appears that you can set up SQL Server 2000 so that EITHER SQL Server CE 2.0 OR SQL Server 2005 CE can sync with SQL Server 2000 (see www.microsoft.com/sql/editions/sqlmobile/connectivity-tools.mspx), but I don't know if it's possible for BOTH SQL Server CE 2.0 AND SQL Server 2005 CE to sync to the same SQL Server 2000. As for SQL Server 2005 ... it appears to be possible to set up SQL Server 2005 so that BOTH SQL Server CE 2.0 devices AND SQL Server 2005 CE devices can sync to the same SQL Server 2005 (see web page cited above). However, I don't know if it's possible to set up a SQL Server 2005 server installation in this manner while at the same time having a side-by-side SQL Server 2000 installation supporting any level of mobile merge replication. HELP!!!!
View Replies !
SQL Sever Side Query To Filter For User ID
I currently have a query in an access database that filters the records in a Sql Linked table for their user ID. So basically i use Environ("UserName") to filter for a field that contains their user name. I want to secure this and put it on the SQL Server so there is no way anyone can see any records other then the ones that are filtered for them. Does anyone know how to do this? I think it will be some SQL query. I'm still learning sql server 2005. Thanks.
View Replies !
SQL 2000 Remotely Invisible With Side-by-side Installation With SQL 2005
On the same server, I have SQL 2000 installed as the default instance, and SQL 2005 as a named instance. Each are on a specific non-standard port. Using SQL Management Studio on the server, I can connect to both instances without problem (using the IP with the proper ports). Enterprise Manager connects correctly to the SQL 2000 instance. No problem there. A remote connection to the SQL 2005 instance with SQL Management Studio is also successful. Also to be noted: the SQL 2005 instance listens to only one IP address which is not the primary IP on the network card. But the SQL 2000 instance listens on all IP addresses (as shown in the Event Viewer). The problem: it seems that the SQL 2000 instance is completely invisible from the outside: it is not recognized by Enterprise Manager nor by SQL Management Studio on my development machine. I switched the SQL 2000 instance to the default port, but this did not resolve the issue. I tried enabling on TCP/IP as the SQL 2000 protocol, no success either. Two more things: 1) a .NET 2.0 application running on a separate web server (and on the same sub-network as the SQL Server box) can connect to the SQL 2000 instance on the SQL Server box using the IP address and custom port in the connection string. This proves that SQL 2000 configuration is done correctly, at least "locally". This application is using the native SQL client provider and goes through the primary IP of the SQL Server box. 2) a .NET 1.1 application on the same separate web server cannot see the SQL 2000 instance. It is using the OLEDB provider. The SQL 2000 instance is not visible, no matter which IP address I try to use in the connection string (primary one or secondary ones). Has anybody encountered a similar issue? How can I make the SQL 2000 instance visible outside of the local sub-network? Thanks for any help Gilles
View Replies !
Side By Side Installations Of SQL2005 Express And Developer Editions
I have downloaded and installed VS C# Express Orcas beta 1. It appears that Express editons ov VS can only connect to SQL2005 Express and not to a high end edition which I have on my computer. In one of the Orcas forums, it was suggested that I can install SQL2005 Express side by side my high end SQL 2005. To play it safe, I wanted to get a confirmation from this forum before I do that. Is a side-by-side installation ok? thanks.
View Replies !
Sql Server Reporting 2002 Side-by-side 2005
having installed 2005 first and installed 2000 with both types of reports going to one 2005 home. i would like to have separate homes with reports going their respective homes. Do i have to first unstall 2005 and do a new installation with a different report and server than 2000. I would like to avoid this and just fine tune 2000 with the rsconfig.exe. Help me out please.
View Replies !
Report - Tables Inside A List Side By Side
All, I was trying to do something like puting two tables side-by-side inside a list, and list itself is grouped by a field. But for some reason, two tables are not organzied pararally even there is no page break inserted. Please help. Tks in advance. Alex
View Replies !
Side-by-side Upgrade Ruined Enterprise Manager
Hi people Here is my case: I've a server running Windows server 2003 edition and SQL2000. I've installed SQL2005 using the side-by-side method as described by MSFT docs. I've then copied the mdf & ldf files to new locations and attached the db in SQL 2005 management studio. Every thing fine. Next, I've migrated the DTSs using the DTS migration wizard. After this step I have some bad warnings in windows: When I restart the server I get the following message: "mmc.exe Microsoft Management Console encountered a problem and needed to close". Furthermore: I can't start the old SQL enterprise manager. It shows another error "mmc.exe - Entry point Not Found" and closes it self. The MSFT support page on this error relates it to Windows XP but my system is running Windows server.... Any one has any idea why this is happening? Any suggested course of action? Many thanks ds9
View Replies !
Side By Side Upgrade And Login Passwords
I've recently done a side by side upgrade of a mssql 2000 to mssql 2005 instance. I'm having problems with 1 login that I've been told had a password that was only 3 characters in length. They don't seem to be able to log in with it. I get an error with a state of 8 meaning it's the password. Is there an issue with migrating the id and password as is into the 2005 instance? None of the other ids are having the problem, they all seem to work and have longer passwords. Any help is appreciated.
View Replies !
Migration To SQL 2005 With Replication (side By Side)
Migration to SQL 2005 with Replication question I need the ability to migrate 2 servers from SQL 2000 to SQL 2005. I am planning a side-by-side migration using 2 additional servers to help with this migration to minimize the downtime. Here are the list of servers as they stand now Server XACT2K (SQL2K) €“ Contains the Publishing Database XACT Server REPL2K (SQL2K) €“ Contains the Distribution and subscribes to XACT (transactional) Server XACT2K5 (SQL2K5) €“ Empty Server REPL2K5 (SQL2K5) €“ Empty What I want to happen is have XACT2K5 end up with the XACT database REPL2K5 have the distribution and subscribe to XACT (transactional) XACT2K and REPL2K be shut down Do this with little or no downtime (meaning doing a snapshot/restoring/in place upgrade/etc are not feasible) What I thought about doing, though I€™m not sure if this would work, is to setup a distributor on REPL2K5 have XACT2K5 subscribe to XACT use that same db to publish acticles from XACT subscribe to XACT from XACT2K5 on REPL2K5 somehow stop XACT on XACT2K let everybody catch up disable rep on XACT on XACT2K point everyone to XACT2K5 Am I talking crazy talk? Is this even feasible?
View Replies !
Limited Functionality On Side-by-Side Install
We are testing our SQL 2000 db on a test box in which we loaded SQL 2000 first and then installed SQL Server 2005 Enterprise Trial edition side by side. I am trying to execute new functions in SQL 2005 against the Northwind db to test and these functions are not recognized. What am I missing?
View Replies !
Side By Side SQL Server 2000 And 2005
I plan to upgrade my server to SQL 2005. It is a rather old machine, but still ok with the recommended hardware requirements. It runs Windows 2000 (SBS) server, which is also a PDC, DHCP, DNS, Exchange server (I stop here but the list is long), with SQL Server 2000 Standard Edition (one single named instance). Everything localized (Italian). I upgraded the database in a development machine and it works perfectly. I installed SQL 2005 Standard Edition (English locale) on the server (default instance, MSSQLSERVER), and I have run in a lot of troubles. The problem seems to reside in the TCPIP network protocols. If I enable TCPIP in the 2005 Server Configuration Manager, the new instance (MSSQLSERVER) does not start (this prevented me from upgrading to SP1 until I realized the cause, disabled TCPIP protocol and was finally able to update). If I understand correctly, the problem is that both instances, the old 2000 one and the new one, try to listen to 1433 port. I changed manually the port to 1434 in the Server Configuration Manager. The result is that both SQL servers work, but none is working ok. I have several applications accessing the server. The asp application works. The .NET aspx one doesn't. A tipical error I get is: Codice evento: 3005 Messaggio evento: Eccezione non gestita. (Unhandled exception) Ora evento: 04/05/2006 13.42.26 Ora evento (UTC): 04/05/2006 11.42.26 ID evento: 7c2749235b7d4c578591871217f74046 Sequenza evento: 175 Occorrenza evento: 24 Codice dettagli evento: 0 Informazioni applicazione: Dominio applicazione: /LM/W3SVC/1/Root/intranet-1-127912101551093750 Livello di attendibilità : Full Percorso virtuale applicazione: /intranet Percorso applicazione: F:Inetpubwwwrootintranet Nome computer: IQ Informazioni processo: ID processo: 684 Nome processo: aspnet_wp.exe Nome account: mycompanyIWAM_IQ Informazioni eccezione: Tipo di eccezione: SqlException Messaggio eccezione: Login failed for user 'mycompanystefania'. Informazioni richiesta: URL richiesta: http://intranet/intranet/articoli/venditeProd.aspx?Codice=SOL T1 Percorso richiesta: /intranet/articoli/venditeProd.aspx Indirizzo host utente: 10.0.0.127 Utente: mycompanystefania Autenticazione: True Tipo di autenticazione: NTLM Nome account thread: mycompanyIWAM_IQ Informazioni thread: ID thread: 1 Nome account thread: mycompanyIWAM_IQ Rappresentazione: True Analisi dello stack: in System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) in System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) in System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) in System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) in System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) in System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) in System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) in System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) in System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) in System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) in System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) in System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) in System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) in System.Data.SqlClient.SqlConnection.Open() in intranet.Global.Session_Start(Object sender, EventArgs e) in System.Web.SessionState.SessionStateModule.RaiseOnStart(EventArgs e) in System.Web.SessionState.SessionStateModule.CompleteAcquireState() in System.Web.SessionState.SessionStateModule.BeginAcquireState(Object source, EventArgs e, AsyncCallback cb, Object extraData) in System.Web.HttpApplication.AsyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() in System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) I also tried to use named pipes on the 2005, but I was unable to access the SQL 2005 server instance from a network computer running the Management Studio. I need to have the new SQL server working besides the old one, for a short period, to evaluate in the production environment if the legacy hardware is actually ok to support it. Any ideas?
View Replies !
Matrix Side-by-side Positioning Issue
My client has a problem with a report that contains two matrix controls side-by-side. Neither matrix expands width-wise upon rendering, only length-wise. The first is two physical pages long and the second is three physical pages long (when rendered). However, when the report is rendered, the second half of the first matrix always shows up on the third page. It skips the second, leaving white space next to the second matrix, which pages normally. We've sure that it's a positioning problem and have tried a number of fixes - including adding a page break at the end of the first matrix and one at the beginning of the second; placing one or both controls in a rectangle; shortening the width of both controls; checking the option to keep on one page if possible. None of that has made any difference. I've also suggested converting the controls into tables as tables will suit the report purpose in this case just as well, but I'm waiting to hear back on whether that works. In the meantime, has anyone else come across this issue and do you have any suggestions? Thanks in advance for any advice, and if this has come up before in a thread I didn't find while searching on this issue, I'd be grateful if you could provide a link to it. -RLG
View Replies !
Client Side
I have a DLL that I have written in VB to automate certain functions in Mapinfo. I can use the DLL from Access or a VB project fine but I have problems in SQL Server 6.5. I can create an instance of the DLL ok using sp_OACreate, but when I call the function to create a Mapinfo Object in the DLL I get a VB error back 'Permission Denied' and my object is not created. Even so, the instance of Mapinfo is started (I can view it in my task manager)which I subsequently cannot close because according to the DLL it was never created!! I think this must be a SQL Server related problem since it works fine in VB/Access. Any Ideas ?? Scott.
View Replies !
SQL Client Side
avaj writes "I was running SQL on my laptop (xp pro) when I load disk it tells me client side only I say okay and it loads using my local machine as server. This worked fine. Then it didn't. Everything was working; then I logged on and received the error message "sql server does not exist or access is denied" I have looked online for help and seen this error elsewhere but never in quite the same context as my problem; and the fixes I've read have not worked. I've uninstalled, deleted and then reloaded the disk; still did not work. I'm at my wits end - I've been trying to fix this for a week. Please, please help."
View Replies !
SQL 2000 And 2005 Side By Side
I was running sql 2000 for months before the release of sql 2005. I cannot upgrade any old databases on my test server but new applications are to be designed for sql 2005 database. I installed sql 2005 onto my server but for some reason I cannot get the enterpise manager to start (when I doubleclick C:Program FilesMicrosoft SQL Server90ToolsBinnVSShellCommon7IDESqlWb.exe the splash screen displays for a fraction of a second and disappears). Can I run 2000 and 2005 side by side? How can I get the enterprise manager to start? Ackim
View Replies !
In-place Or Side-by-side Upgrade
Hi, I work with very sensitive data and do not want to do any in-place upgrades. Does anyone know of the risks (or some documentation) involved with an in-place besides the rollback. I would prefer only to do only side by side upgrades.
View Replies !
Side-by-side Data Regions
I was using a single data table to contain my assortment of fields, but one of the text boxes often has to grow vertically, skewing the layout on the fields to the right of it. So, I moved those other fields to a data list right beside the table. It seemed to work perfectly, so I deployed it to our development server and tested it. When rendered from the server, the list gets bumped down to below the table. So, after doing some research, I stuck the list into a rectangle and tried different things, like making sure the top of the rectangle was above the top of the table, etc. However, one or the other data region always gets bumped down to below the other--I can't get them to stay side-by-side when run from the SSRS server. The final frustration is that when I print from the malformed 'preview' on the server, it comes out correctly on the printer! In other words, it looks different on the printer (correct) from how it looked when I hit print (incorrect) in the browser. Apologies if this is a newbie question, but I'm stuck. Browser is IE7, server is SQL 2005 SP1. Thanks, Joel
View Replies !
Display Image Side By Side
I am currently working on ssrs 2005 to build a report that display the images as like a photo folder. we would have 5 columns in which these images need to be split up and details of the images will be placed underneath the images. Even though ssrs 2005 supports the option of column split in it report viewer, but the images are not in a single row instead they lie one below the other after deployment and in report viewer. only at the time of rendering to PDF the images span across the columns. Is there any workaround to achieve this?
View Replies !
Can I Run SQL2000Dev And SQL2005Exp Side By Side?
Have an asp.net 2.0 application that I want to enable a "demo" version of with the required tables. The tables currently exist in SQL2000Dev on a server. I have installed SQLEXP on a clean box and restored the database to it no problem. Now I want to install SQLEXP on my dev pc side-by-side with the SQLDEV instance. I could not find any reference to this ability other than some warnings about the pre-release versions. Can it be done safely? Thanks, Paul
View Replies !
Client Side Triggers?
in merge replication using sql server 2005 and sql server compact, is it possible to have triggers (or business logic) for any changes on the client side? how does a client app know an insert/update/delete has been made? also, if the article is set to download-only, can the client app also be nofied of any changes? thanks, bryan
View Replies !
Side-by-Side Install With SQL Express 2005 W/ Advanced Services And SQL Server 2005 Standard
I have SQL Express 2005 with Advanced Services on a development box that I also want to have installed side-by-side with SQL Server 2005 Standard Edition so I can develop apps using either edition based on the features I need (or don't need). From what I understand from sifting through other posts is that side-by-side installs of these two editions is supported and I should setup a named instance for each edition (SQLEXPRESS for the express edition and MSSQLSERVER for the standard edition). Is this setup accurate or is there another/better way? Also, does anybody know if side-by-side installations of Reporting Services is also supported? If I install SQL Server 2005 Standard Edition with Reporting Services, will there be two different report servers running in IIS? Since there are different features in Reporting Services between the two editions, I'm not sure how side-by-side installations will effect one another. Thanks in advance for any help, Tony
View Replies !
Client Side Insert Update
hi friends;I have problem about sql server insert and update in client side.I am coding windows application with c#.When I run my code in databaseserver computer all is fine.I can see data, insert and update.But whenI run same code in client side I can see data but not insert notupdate what can I do about this problem .I use sql server 2000database.Client side connections ok. :( thanks for all
View Replies !
Client Side Backup Utility For MS SQL 7
Anyone know of any kind of little script or utility that can be placed on an end users PC to backup a specific database whenever they want? All I want it to do is to name it according to the date, place it in a predefined directory, and tell the user that it worked or failed. I am not very good at programing. Also, this is MS SQL 7. This tool needs to be fairly idiot proof. Any ideas? Thanks, Tim
View Replies !
How Can I Install SSIS On Client Side?
Hi, We just moved from SQL 2000 to SQL 2005 Ent. To use SSIS service, I need install this package on client side. But when I install the 2005 on my PC(Win XP Prof), I did not find any place I can include it. Anyone has similar experience or know how to do it? Thanks in advance, Jie
View Replies !
Save At Client Side Problem.
I dont know where to put my this problem, please excuse me Hi We are have a client-server setup for SQL Server 2005(EE). I am working on client(using connectivity tool sql server native, SSMS), with full Admin right(i mean sa user). I have a stored procedure which generates the backup of database, using XP_CMDSHELL & BCP commands. Every thing so fine. But the when BCP Generates the files it stores at server hard disk, not into at the local hard disk.( although i had given the c:abc path). Same problem is there, when i restore the Database(i had too written a SP for that),it always picks the paths from the Server not from the client. How could i force to save my files at client side, i mean when user at client end executes the Backup SP, it should get the file at his System Hard disk. (As there is no rights to user to access the files at the SQL Server). I know i can use the UNC path, but any other solution? Regards, Thanks. Gurpreet S. Gill
View Replies !
Client-Side Subreports && Parameters
I'm currently working on a client-side report that I need to add a subreport to. The main report runs off of a stored procedure called from the .aspx page (where the parameters are defined) and returns a dataset. From this dataset, I need to take the ID that is defined on every row of the dataset (it will be the same for every row) and pass this value to the subreport. The subreport similarly calls a stored procedure from the .aspx page though I'm running into trouble with how exactly to define the control parameter in this case. Additionally, I'm unable to link it back to the main report. Has anyone had any experience with this? I'm very new to SSRS and have not had any luck searching the internet on this topic. Most references are to server-side reporting and the few topics I could find related to mine never had any solutions.
View Replies !
Client-side Redirect Problem
Hi there. I have a database mirroring session running, and both principal and mirror are working fine. But when i unplug the network cable from principal server, creating a failover scenario, the client doesn´t get redirected to the mirror. I get an error saying: "A transport-level error has ocurred when received results from the server. The specified network name is no longer available." connection = "Data Source=SISAD;Failover Partner=Projecto-SWS1;Initial Catalog=SIERE;Persist Security Info=True;User ID=sa;Password=testing;Connection Timeout=100"; //this method is called many times by a thread, emulating some request to the server public static void Inserir(int codAutor) { SqlConnection sqlConnection = new SqlConnection(connection); SqlCommand command = new SqlCommand("insert into Autor values(@codAutor,'test')", sqlConnection); command.CommandType = CommandType.Text; command.Parameters.AddWithValue("@codAutor", codAutor.ToString()); command.CommandTimeout = 200; sqlConnection.Open(); command.ExecuteNonQuery(); sqlConnection.Close(); } I think the error is because the ExecuteNonQuery() method return info about the rows affected on the server. But in this case how can i create a failover scenario with client-side redirect ? Thanks in advance.
View Replies !
|
TRACKER
