Horea Soanca's Q&A profile
SQL Server Using 2005 JDBC driver to access SQL Server 2000
Hi, I'm using JDBC driver for Server 2005 (version 1.1.1501) to access Server 2000. I have no problems reading my data, but every update returns "Cursor is READ ONLY". If I use driver for Server 2000 I have no problems. And I have no problems running the same program with 2005 driver against SQL Server Express. Where should I start debugging Thank you, Hello Peter, Note that the default cursor you obtain by calling conn.createStatement() is a CONCUR_READ_ONLY cursor. You have to explicitly request an updatable cursor such as conn.createStatement(TYPE_FORWARD_ONLY, CONCUR_UPDATABLE). For more details on using Cursors with the JDBC Driver, please refer to http://msdn2.microsoft.com/en-us/library/ms378405.aspx ( ...Show All
SQL Server Where to use SQLCLR ? Data access is not recommended?
Just wondering which scenarios is suitable to use SQLCLR. Any kind of data access is not recommended I guess. Only things that cannot be easily done in TSQL should be done in SQLCLR but why Can't those things be done in app layer itself Scenarios recommended for SQL CLR: - External data access like filesystem, registry etc - Complex calculation - Recursion without data access (this can be implemented with CTE for data access) If data access with SQL CLR is not recommended why should CLR should be even used and logic reside in database layer.. it makes no sense to me. Any thoughts Hi HiTech2k, When you use SQLCLR to do data access, do you do the manipulation in .NET DataTables If so, isn't it slower than ...Show All
Visual Studio Express Editions start application
How can i start another application for example Google Earth Hi there, You can start any external application by using a Process class. C# Code: System.Diagnostics. Process p = new System.Diagnostics. Process (); p.StartInfo.FileName = "abcd.exe" ; // set your executable file path p.Start(); VB Code: Dim p As New System.Diagnostics.Process p.StartInfo.FileName = "" 'set your executable file path p.Start() ____________________________________________ May the God blessing be. LotraSoft Ltd. ...Show All
Visual Studio 2008 (Pre-release) xbap security issue with images
I am working on an xbap deployed from the Internet accessing images on the client pc. I can get the image into the app using the OpenFileDialog partial trust technique but run across the following error: System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.MediaPermission, WindowsBase, Version=3.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' failed. at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet) at System.Security.CodeAccessPermission.Demand() at MS.Internal.PresentationCore.SecurityHelper.DemandMediaAccessPermission(String uri) at System.Windows.Media.Imaging.BitmapFrameEncode.set_InternalMetadata(BitmapMetad ...Show All
Microsoft ISV Community Center Forums how to connect two locations to better communication
How to connect two locations to better communication We have offices at two locations, and i m looking for VBA (outlook) to connect two locations for updates, (more than email). Pls let me know your ideas.. ...Show All
SQL Server Package Configurations not so portable?
I'm still struggling with finding a sound approach to creating configurations that are truly portable. For instance if you use XML files to store configuration information, the path to the XML file that stores the configuration is baked into the package. This would require the same file system structure on all machines that could host the package. Store in SQL server - one key thing that is valuable to configure is Data Sources - but how can you configure a data source at runtime by storing it as a config in SQLServer, when the data source itself is used to specify the server that stores the config information Environment variables or registry entries seem to be the most practicle because they truly are machine specific. ...Show All
SQL Server How to pass mult-valued parameters via webservices render method?
Hi there, Trying to update the value of a multi-valued parameter for use in programmatically genereating a report via the RS webservice's render method ... but ain't working. Any ideas on how this is done thanks - wg I tried this: ReportParams[4] = new RSWebReference.ParameterValue(); ReportParams[4].Name = "QuestionAnswerAnsLabel"; ReportParams[4].Value = "{[Question Answer].[Ans Label].&[Strongly Agree], [Question Answer].[Ans Label].&[Agree]}"; ... and got an exception of invalid parameter value. Yeah I am looking at the same issue right now. Its not possible to set a ParameterAndValue.Value to string[] It seems that the ReportParameter class will support string[] i ...Show All
SQL Server A way to control the # of Transport connections
Is there a configuration parameter that allows me to control the number of Transport connections used by service broker Right now it seems that it just uses one. Ok so what should I do if it feels like I am being constrained at around 100 - 150 messages per second through this transport piece I have done a couple of tests and at one point it seemed if I enqueued more than 100 messages/sec then they would back up into the sys.transmission_queue on the source side. I realize that is by design, but I have been led to believe that I should get something closer to 1,000 messages/sec of throughput between the 2 instances Any thoughts ...Show All
Internet Explorer Development IE 7 opening to Run Once page with error on it.
I downloaded updates last week. I have been using IE7 for a while with no problem. I dwnloaded the updates. Now when I open my browser the page tries to go to http://runonce.msn.com/runonce2.aspx . There is an error reported for this page and it will not open up I get a blue screen. How do I eliminate this I have my home page set in the tools section but when opening it won't go to my home page until I hit the home button on the tool bar. I tried running IE7 with out add-ons. The run once page did not come up to open at all. The browser did not go to anything except a page that said that the add-ons were disabled. ...Show All
.NET Development Table does not appear to update after UPDATE statement
I am trying to update a table (asps) in MS access with the code below. However even though it complies and appears to execute, the table is not updated. Both ID and recID are double. I am working in ASP .NET C#. Any ideas Thanks private void Button1_Click( object sender, System.EventArgs e) { OleDbConnection conn = null ; conn = new OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0; Data Source=C:\\Inetpub\\wwwroot\\WEB\\afterschoolprograms.mdb"); string strEditCommand = "UPDATE asps SET "; strEditCommand += " NAME = "; strEditCommand += " WHERE ID = "; using (OleDbCommand cmd = new OleDbCommand(strEditCommand, conn)) { cmd.Parameters.Add( ...Show All
Windows Live Developer Forums Dashboard control
Hi, How can I specify the dashboard position on the map In V2 there was an object parameter in MapControl() constructor. Using this object parameter I was able to specify where I want to place the dashboard. Is there something similar in V3 I tried playing with .Compass and .Zoombar styles but they move only compass and zoom bar respectively - the dashboard (light blue semitransparent box) remains in upper left corner of the map. Thank you, olley. <disclaimer> ...and a friendly reminder: if it's not in the SDK, it's not officially supported and could break at any time. </disclaimer> ...Show All
Visual Studio Team System test list?
i am now looking at "team build wizard" Option section, it mentions some "test list". How do i create one I've seen articles telling i need "Test Manager" to create a test list, but i do not have one in my test->windows menu. is it because i need a "for testers" edition my final goal is to set a build server so it will do all tests on every check-in You also have that capability if you have the Team Suite edition as well. http://www.ekobit.com/download_testmngr.aspx This is a free trial download of a tool that is supposed to give you test manager and list capabilities. CAVEAT: I have not looked at this yet, so I can't verify how good/bad it might be. http://www.ekobit ...Show All
Visual Studio 2008 (Pre-release) Path and different strokes
Hi, I am not sure, is it possible to set different strokes for the separate geometry objects in a path object Cheers, Franz Stroke is a property of the Path, not the geometry. If there is only one Path, then there can be only one stroke. What's your scenario Maybe there's another way to do what you want. ...Show All
Smart Device Development send mails using SMTP protocol
Hi, I have a requirement, where in I have to send E-Mail from the pocket pc using the Exchange server, without using the outlook, cradle or Active sync, so that when I send the mail it should be delivered immediately. Which protocol I should use, should it be SMTP Is there any way to connect directly to Microsoft exchange server and send the mail message Please let me know if this is achievable. Regards, Parag Dave Sorry, but this forum is for questions related to the DeviceEmulator. You might want to ask this question on a forum or newsgroup related to Exchange Server. Barry ...Show All
Visual Basic VS 2005 Commerciral Development Version?
I work for a commercial software development company and our primary product has been components (.DLLs) developed in VB6. When we started years ago, we had to buy the VB6 Enterprise Edition in order to develop .DLLs that could be distributed and registered on customer machines. Does the same concept exist in Visual Studio 2005 We want to add a line of .Net-based DLL products and currently have VS 2005 - Professional Edition. Is there any requirement to use VS 2005 Team System for developing commercial apps You can use any version of visual basic / visual studio to develop commercial applications (except student version I think) So you could develop applications using VB Express (which is free) if you ...Show All