Karen G.'s Q&A profile

• SQL Server Database permission, ownership generated by script?

  Hello! My problem: I install my application and a database as sysadmin but a regular user cannot use the database, he don’t have permission! Explanation: I have a c++-application wich is using a database. The database i created with a script. The ODBC (dsn) is made with script. I have a VB-script wich include a sql-script call, se below. The VB-script is started with a custom action in my setup project. The user dont have admin rights. The databse only using stored procedures, tabled valued functions and a extended stored procedure and the master database. Nothing else. No tables... Question: To use my c++-application the user need a database-connection through a odbc. Is it possible to let my database be avalible for everyone ...Show All

• .NET Development Audit/Log the change in DataSet

  We want to Audit/Log the changed data in DataSet and found DataSet.GetChanges will return whole changed rows even this row only have one field changed. We understand we can write our own script to compare original datarow and changed datarow finding out which column change. Does there have another way to Audit/Log the changed datacolumn Thanks, Hi, GetChanges is only valid until the dataset's AcceptChanges method is called (called automatically by the table adapter's Update function). The most flexible and non intrusive way to create a log of the dataset's changes is to attach event handlers to the tables RowChanged, RowDeleted and TableNewRow events for every table your interested in: ...Show All

• .NET Development Data connection failed to open

  Hello, I'm attempting to install a Worker Service responsible for performing regular operations and communicating back and forth to a SQL Server 2005 database on a remote machine. I have a thin client that allows the user to make configurations, and although the first connection can take 20 seconds or so, the client succeeds at communicating with the database. The worker service, however, fails to do so every time. On startup, I attempt to communicate with the server three times: 1) send the current time as the service's boot time, 2) send the current time as the service's "heartbeat", and 3) get outstanding items to process. The first two return the following error in the Application service log: Data connection failed ...Show All

• Visual Studio Express Editions SQL 7.0 Connectivity With VB 2005

  Hi, I want to connect to a SQL 7.0 Server running on the network. However, I cannot find the NET Framework Data Provider for OLE DB. How can I add/install this. Please help. Thanks & Regards - Rajesh Pathak Hi, Normally they are installed by default. Have you looked in the System.Data.OleDb namespace Do you have a OLEDB client on your machine Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog ...Show All

• Visual C++ Resource Editor changes manually entered values.

  I am working with both Visual Studio 2005 C++ and Embedded Visual C++ and am having the same problem on both platforms. I have to manually enter the value WS_MINIMIZEBOX to the STYLE line of the dialog definitions in the RC file. We are doing this so that we can force the application not to put the default X or OK in the upper right hand corner of the Pocket PC application. (We are trying to reduce screen damage to the PDA devices). Anyway, as long as I don't go back into the resource editor and change anything, the code compiles fine and the application performs as desired. However, if I go into the resource editor and move just one control, in all of the dialog box definitions, the WS_MINIMIZEBOX is changed to WS_MAXIMIZEBOX and then upo ...Show All

• Microsoft ISV Community Center Forums Autofilter criteria's

  Hello everyone, This might be really simple but I couldn't find the answer for it.What I'm trying to achieve is that I need to find all the possible autofilter criteria's of a single Excel list field (Column) from VBA. I know I could just iterate over the column's cells and distnictly find the values and store them into an array, but I'd really be intrested to know if there is a property which already gives me that. thanks, Mohamed Hi Chas, Thanks for your response. Sorry if my question is not clear i'll try to re-word it. What I need to do is that I have a sheet with a list, I need to split this sheet in seperate sheets based on filters of one of the column, assume the column name is "Application&qu ...Show All

• Visual Basic Call a vb.net form from a vb6 mdi Container

  Am i overlooking something I followed the instructions and created a . net interopForm project. Referenced everything in VB6 A vb.net form expects the property MdiParent to be set ... This property is not available to set , will i get there by adjusting the interface of iiForm Any suggestions are appreciated. Thanks Can you be more specific about what you did I assume you are talking about the VB6 interopform toolkit. Can you explain in more detail the steps you did (and are you getting a compile error, etc... ) Thanks! ...Show All

• .NET Development How to develop Webservice client without WSDL file?

  Hello : I could successfully communicate with Java Web Service by way of VS 2005 tools to generate a webservice proxy through general way to call Java webservice Url like:http://localhost/Sample/Sample WSDL The problem is that There is an urgent project for me to connect to another java WebService. The Java webservice is developed by thirdy party and they did not provide WSDL file yet but they provide the webmethod on some documents. The WebServer did not support GET but only allow POST method. Now I am trying to develop a win form client to connect to the WebService. I want to send SOAP message directly to that Java WebService but I did not have any idea to begin. There are many examples in VS 2005 by way of adding web ...Show All

• Visual Studio 2008 (Pre-release) BitmapEffects.... What the???

  Howdy.. I am trying to create a BitmapEffect to turn an image into grayscale... I am almost there accept I get a COM failure... (I shall not go into the managed rant...) The specific return error is: System.Runtime.InteropServices.COMException was unhandled Message="Error HRESULT E_FAIL has been returned from a call to a COM component." Source="mscorlib" ErrorCode=-2147467259 StackTrace: at System.Runtime.InteropServices.Marshal.ThrowExceptionForHRInternal(Int32 errorCode, IntPtr errorInfo) at System.Runtime.InteropServices.Marshal.ThrowExceptionForHR(Int32 errorCode) at MS.Internal.HRESULT.Check(Int32 hr) at System.Windows.Media.Effects.BitmapEffect.SetValue(SafeHandle effect, String propertyName, Objec ...Show All

• Visual Studio Express Editions String resources

  I have about 100 string stored in string resources. I need to go through them all and select various ones based on other criteria. In vb5 I could sequence the resource identifier and use a for next loop. Example: For i = 1000 To 1100 If S omeValue > SomeOtherValue Then msg = msg & LoadResString(i) End If Next I'd like to know how to do something similar in VB Express. I appreciate your response. Unfortunately, I don't know how to do what you suggested. Ten hours of research and I'm more confused that when I started. I found lots of sample code but none that explained how to make the code work. More help would be appreciated. ...Show All

• Visual Studio Express Editions Visual Studio 2005 can't build after upgrading...

  VS.NET 2005 worked fine before I upgrade probably VS.NET 2005 SP1. But, after I upgrade VS.NET 2005 SP1, I can only compile single file, but can't build the whole project. Every time when I tried to build the whole project, the IDE just stuck there and showed "Build Started..." without any improvement. My god... I can't figure out. Can anybody help Thanks JIA Pei Hi I have the same issue where the build sometimes gets stuck. I have to end task and restart the IDE to resume working in the VS.NET 2005 Alain! ...Show All

• .NET Development WSE Proxy, dynamic generation.

  I write an application that generate dynamically a WebServiceProxy for asmx. I use DiscoveryClientProtocol for retrieve web reference using the WSDL collection. I use ServiceDescriptionImporter and CodeDomProvider for compile a proxy and generate a class that inherit of SoapHttpClientProtocol type . I Want generate a proxy for WSE. I want that my proxy class inherit of Microsoft.Web.Services3.WebServicesClientProtocol instead of SoapHttpClientProtocol . I found a solution: replace SoapHttpClientProtocol with WebServicesClientProtocol before generate a class, but i want find a better solution. How run a Add Reference for WSE It's run a same manner of Add Reference for ASMX How I can generate a proxy class tha ...Show All

• Visual Studio Express Editions Upgrading VB 6.0 project to VB 2005 version in VB 2005 Express Edition

  Hello All, I am currently upgrading myself from vb 6.0 to vb 2005 and I am using vb 2005 express edition. I have made a project in vb 6.0, in which I have used windows common controls, but the coding is quite complicated. I want to upgrade this project to vb 2005 version. Can anybody tell me is it possible to upgrade the project in express edition. I tried to open the project in vb 2005, but instead of showing Upgrade Wizard, it has shown a file containing only the details of the contents of the project for eg, the name of classes, modules and forms which are there in the application. If it is possible to upgrade, then please tell me where I am going wrong and how can I do the needfull. Thanks and Warm Regards, Adarshdeep S ...Show All

• .NET Development Best/fastest way to save a large DataTable a database?

  Hey, Whats the best way to save a rather large DataTable to a database It consists of roughly 60 columns and 15 thousand records (6MB of raw text). I was thinking of using a stored procedure but would that give any performance increases on an operation like this Thanks! Regards, Weiran. I have another problem :(. Every time I insert into the table, it deletes all the previous records! How can I avoid this Thanks! ...Show All

• Community Chat Hottest Technology for webdesign

  Hi guys, I am looking to make my first website. I know about dreamweaver and frontpage, but what other web-building software is there that's really popular and can get the job done well Anything free Thanks, Cyan I use Dreamweaver just because its structured really well. I have used Frontpage and MSVWD and MSVWD is not structured very well, and it isnt the best tool out there for web developing unless your coding in ASP. Dreamweaver supports everything and sometimes has good templates instead of having to type like <a href="http://microsoft.com/">Microsoft</a>, you can just go to the toolbar and make one from that, very good for beginners. Tyrael ...Show All