Ed Abshire's Q&A profile

• SQL Server MSResultSetGenerator does not work any more

  I try to generate a typed result set. I first added a new data source to my project and then changed the custom tool property of the .xsd file from MSDataSetGenerator to MSResultSetGenerator. This was working a few days ago, but recently, it stopped working. I now get the following error when I right click on my .xsd and then "run custom tool": Error 102 Custom tool error: Failed to generate code. Illegal characters in path. C:\Users\Mathias\Documents\Visual Studio 2005\Projects\WindowsApplication9\WindowsApplication9\NorthwindDataSet1.xsd 1 1 WindowsApplication9 I tried this in several projects, for example I created a new WinForms project and then just added the norhwind.sdf sample database. I use Visual Studio 2005 + ...Show All

• Visual Studio Tools for Office ThisApplication_Startup not being called - ie. plugin not loading

    I have written an outlook plugin using VSTO. The plugin loads fine and works great if the user clicks on the outlook icon. On the other hand, if outlook is started via automation and then outlook is opened, the plugin does not load. These cases are described below. When the user signs on to windows xp with activesync set to run on startup. ActiveSync syncs with outlook by starting it through, AFAIK, automation. Now when the user opens Outlook by clicking on the outlook icon,  the plugin is not loaded. Another example is when the user has Outlook closed and they click on an oft file on their desktop, and then open Outlook, the plugin is not loaded. Please advise. Thanks. ...Show All

• SQL Server Full text search and CONTAINSTABLE - can I weight by column?

  I'm trying to use CONTAINSTABLE to do a product search on a number of columns. I want matches on some columns to be weighted higher than for other columns. It seems like there should be a way to do this with CONTAINSTABLE - I know I can search by multiple strings and weight those matches variably, but what I want is to vary the weight by which column a single term matched. What I have now is a series of UNION queries, which are quite slow: =================== SELECT m.TitleCode, m.ShortName, m.ShortDescription, a.Rank, 50 as theWeight FROM CONTAINSTABLE (Product, ShortName, @theSearchTerm) as a, Product m(NoLock) WHERE a.[KEY] = m.TitleCode UNION ALL SELECT m.TitleCode, m.ShortName, m.ShortDescription, a.Rank, 40 as theWeight FROM FREETEX ...Show All

• Visual Studio RSClientController is not defined

  I am using a webforms reportviewer in local mode with a dataset. I have confirmed that the filler method of the business object is being called and a filled dataset is being returned. However, when the page renders, the reportviewer is missing the button images, none of the report is displayed and I get a script error of RSCLientController is not defined. I have checked the IIS setting about checking that a file exists and it is not selected. If you look at the html source that is generated (select "view" menu, then "source" in IE), you will see a few links to javascript files. One of them contains "ReportViewer.js". If you copy that url directly into IE and try to view the ...Show All

• Visual Basic login probs

  Below are my codes for a login form. the part where its the correct ID and Password works perfectly fine. its the part where, the textbox1.text = "" and textbox2.text = "" and else part, where it doesn't work. the codes look good to me. but yeaup. please try your best to help! thank you! Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim str_driverId As String Dim str_passWord As String str_driverId = TextBox1.Text str_passWord = TextBox2.Text Dim sqlconnection As New SqlCeConnection("Data source = \My Documents\busInfoSys.sdf") Dim reader As SqlCeDataReader Dim cmd As New SqlCeCommand("SELECT passWord FROM driverR ...Show All

• Visual C# Passing Extra parameters to events

  Can anyone suggest me to pass more parameters other than two parameter for events like the following Event: OnMouseMove(object sender, MouseEventArgs e)" Event handler: this.MouseUp += new System.Windows.Forms.MouseEventHandler(OnMouseUp); Not sure what you're trying to achieve, but one solution is to have your own custom class that inherits from MouseEventArgs and has additional properties that represent the data you want to pass as additional parameters. Then pass an instance of the custom class when raising the event. This is more consistent with .NET Framework events than adding additional parameters. If you're raising a custom event in your own event class, you can define a delegate that takes your custom MouseEventA ...Show All

• SQL Server native vs. clr stored procedures

  Hello, my question is, what is "better" for relative simple querys. native stored procedures or the clr method The procedures are relative simple select's or insert's. What are the advantages of clr procedures perhaps you have some links to read about... thanks and greets from germany! Dirk You should also take a look at this whitepaper . Cheers, -Isaac ...Show All

• Visual Basic Databases

  Hi there, I have my connect to my database alright and sucessfully filtered it. I know there will be only one row left so how do I get the contents out of one of the columns to put in a textbox Thanks, AliQ Hi, In case of using SqlCommand and SqlConnection, you should use OleDbCommand and OleDbConnection. Also change the connectionstring. The rest remains the same. Greetz, Geert Geert Verhoeven Consultant @ Ausy Belgium My Personal Blog ...Show All

• .NET Development HOT FIX K921883

  Hi All,   After implementing the HOT FIX K921883 released by microsoft , My application start giving error while executing DML statement on SQL server 2000. The underlying framework used is .NET 1.0. The hot fixed target .NET 2.0 framework.   Please help me to sort resolved this problem.   Thanks, There has been at least one issue discovered with 921883, so you may need to get another update. But posting the call stack may prove useful as well. http://support.microsoft.com/search/default.aspx query=921883&x=0&y=0&catalog=LCID%3D1033&spid=&qryWt=&mode=r&cus=False ...Show All

• .NET Development Invoking managed code from unmanged code failed

  I got into a trouble of invoking managed code from unmanaged code. I have a managed assembly A including some COM object and registered for COM interop. and another COM Module B in natived code. Module B import the tlb file generated by Module A and invoke that through that interface. The problem is: afte invoked a couple of times. the application threw an AV and crashed. I runned that in Windbg and it stops at 0:000> k ChildEBP RetAddr 0012e44c 79f1ed6a mscorwks!COMToCLRWorkerBody+0x129 0012e4a8 79f1ec81 mscorwks!COMToCLRWorkerDebuggerWrapper+0x37 0012e67c 00a7aab9 mscorwks!COMToCLRWorker+0x164 ... 0:000> .lastevent Last event: 168c.f50: Access violation - code c0000005 (first chance) 0:000> u mscorwks!COMToCLRWorker ...Show All

• Visual Basic the refresh code for making an internet explorer

  i need the refresh code for making an internet explorer on visual basic so far my internet program has a go button and also i would like a code so i can make it so i can use a combobox instead of a text box to type in the web page eg. http://forums.microsoft.com/MSDN/AddPost.aspx ForumID=64&SiteID=1 Thanks kharg0, 1. According to your question, I recommand you to use the WebBrowser control and use the WebBrowser.Refresh method: ' Reloads the current page. Private Sub refreshButton_Click( _     ByVal sender As Object , ByVal e As EventArgs) _     Handles refreshButton.Click       ' Skip refresh if about:blank is loaded to avoid removing  &n ...Show All

• SQL Server DSV Refresh

  Hi, I have an odd problem with the creation of objects in the data source view using AMO. I added some tables and relations with AMO and everything seems to work well. Then, using Analysis Services I selected the data source view and refreshed it. The form that notifies the changes in the data source view showed a lot of changes that I didn’t understand, costraints created and removed, fields changed and other operations that I didn’t made... I try to do the refresh with AMO using all the update and refresh options I found but with no results. Every insight on the question will be of great help. Thanks This is an extract of the data source view refre ...Show All

• Visual Studio Express Editions Connecting Oracle Database 9i with VB2005 Express (ODP.NET)

  I installed Visual Basic 2005.NET Express Edition and for a new project added reference to Oracle Connection (the one that is available as "system.data.oracle.client" version 10...". But when I put the "Oracle Connection" object on the form to define connection properties, it displays error:"Data provider identified by guid '00000000........' could not be loaded.Please let me know on how to connect to Oracle database 9i R2 with VB.NET 2005 Express. ...Show All

• Visual Studio Blog post

  Hi, for those interested: http://ajdotnet.wordpress.com/2006/12/02/got-gat/ Regards, Hi, nice to get feedback from (presumably) one of the authors :-) Regarding the last point: The point is not that you don't have access to the code model, I agree that you do. What you lack is the context information, i.e. the cursor position. With an addin you could do something like right-click on a class, select the "implement interface" menu entry, and be done with it. With GAT you could only right-click on the solution item of the respective file, then you would need a wizard to select the class to work on... not exactly the natural way to do this. That's why I used the words "not exactly suited". Please correct m ...Show All

• SQL Server Impersonation Mode Issue: multiple analysts requiring separate AS DBs for security model

  Hello-- We have a current situation where analysts will be modeling a variety of problems, all stemming from the same source data (stored in a SQL-Server 2005 relational database). Analysts that work on the same problem will only have access to: - A sandbox relational database (which contains views into the same source database). The analyst is db_owner of the sandbox database, so she/he can create data transformations required, etc. The sandbox database contains views to the source database, but the analyst only has read-access to the specific data elements needed from the source DB. So, they are very restricted w.r.t. the source database, but are db_owners of their sandbox relational databases. Note that the analyst will connec ...Show All