zorann's Q&A profile

• SQL Server SQL Server 2005 CLR integration problems with unmanaged code

  Hi, With SQL Server 2005 I'm trying to define a CLR integration UDF that calls unmanaged C++ code contained in a .dll. I have the following two signed assemblies: 1) 'wrapper' - this assembly is basically a wrapper class writen in C++ managed extensions code that calls a legacy library written in unmanaged C++ 2) 'provider'- this assembly offers services some of which are contained in the 'wrapper' assembly. This class is written in C# and its assembly is marked as unsafe since it is calling unmanaged code The problem is that when I run the assembly creation statement: CREATE ASSEMBLY [Provider] FROM 'c:\D ...Show All

• Visual Studio Express Editions Can Visual Basic Express be used with MS access

  I own Ms access and I formerly dabbled with vb 5. I'd like to update my simple programs that have ms access databases to vb express can this be done Thanks, Glo yes that can be done but i would recoment to have a backup or another copy from your projects b4 conversion, because in some cases conversion doesn't work properly, actualy in most cases so you have to know vb.net to be able to fix the conversion problems or to write you projects from scratch simply you run your VBEE >> file menu >> Open project >> select your project >> click open , it will convert it to y ...Show All

• .NET Development Visual Studio 2005 + ASP.NET + Modules? =D

  I need some way that I can access a function across all of the pages within my site. The problem is that there seems to be no support for Modules. I'd use a class, but I don't want to create an object each time. I just need to call a function. Any ideas Again, improper design. True, it will work, but it's not proper OO design. Sorry. ...Show All

• .NET Development 1.1 to 2.0

  Hi, I am converting a 1.1 code to 2.0 The line that I would like to convert is System.Web.Mail.SmtpMail.SmtpServer = SMTPserverName; P.S. using outlook do you know what should this line be in 2.0 Thanks string server = "server"; System.Net.Mail.SmtpClient client = new System.Net.Mail.SmtpClient(server); client.Send(from, to, subject, body); Hope this helps. ...Show All

• .NET Development VB6 and CCW's

  Hi, I need to start writing a set of classes that will be used by our VB6 application. Because I have'nt done much in the past with COM interop, I was getting a bit confused as to what attributes I need to use on my managed classes. for example, do I need GuidAttribute and ClassInterface and ProgId, or just a few of these Remebering that these .NET classes will only be used by our VB6 code, nothing else. Thanks for your help Graham The attributes are optional, yes - as is defining a class interface - but these are important things to do or you will have development and deployment hastles. I've answered many, ...Show All

• .NET Development temporarily combine XmlDocuments

  Probably a very special problem... I got several XmlDocuments which I want to temporarlily combine for xpath operations and manipulation, e.g. XmlDocument1: <A>123</A> XmlDocument2: <B>456</B> XmlDocument3: <C></C> After combining: <Root> <A>123</A><B>456</B><C></C> </Root> A possible operation executed with an XPathNavigator/XPathExpressions XPathExpression expression = XPathExpression.Compile("number(/Root/A)+number(/Root/B)"); int val = (int)navigator.Evaluate(expression); navigator.SelectSingleNode("/Root/C").SetType ...Show All

• SQL Server In 2005, finding users who have context in a database?

  I know sysprocesses has the information, but I can't seem to find how this is done using the dmv's. sessions doesn have a db context, and requests is only active while activity is occurring. Thanks! Well, at least I am not going nuts. Sysprocesses is good enough for now, I would imagine. Is the bug on connect I couldn't find it there by searching for sysprocesses... ...Show All

• SQL Server Upgrade from June CTP to Sept CTP - BKM

  I am upgrading to Sept CTP from June CTO. Should I completely uninstall the June version before proceeding towards the new version Any experiences Pls share. Yes, you need to completely uninstall June CTP components. Read the READMEs carefully about uninstall order for your circumstances. Andrew Watt MVP - InfoPath wrote in message news:378426eb-8533-43f6-9f9f-a37719c91585@discussions.microsoft.com... > I am upgrading to Sept CTP from June CTO. Should I completely uninstall > the June version before proceeding towards the new version Any > experiences Pls share. > ...Show All

• SQL Server users cannot accesss report builder without being local administrator

  I've seen similar posts on this problem but no answers. Does anyone know what 'local rights' the user needs without being admin to access report builder. I have already gave them the rights to install report builder they can see the icon on the web page but when they go to install it and are not local administrators on their desktop, they get this error. We have tried putting the users in the Power Users group but still does not let them install report builder. PLATFORM VERSION INFO Windows : 5.2.3790.65536 (Win32NT) Common Language Runtime : 2.0.50727.42 System.Deployment.dll : 2.0.50727.42 (RTM.050727-4200) mscorwks.dll : 2.0. ...Show All

• SQL Server Problem with ODBC access in a thread

  Hi guys, I'm using SQL 2005 Express with an ODBC connection. I've created a thread to fill a listctrl with the data of a table. At the end of the thread there is cicle to check for some lines value in another table. When I try to close RecordSet linked to the second table to ReOpen with another SQL Statement the thread ends. Using SQL Server 7 I've no problem. What's wrong ...or what I'm not doing Thank you in advance Do you get the same behavior with both SQL Server and SQL Native Client ODBC drivers Any chance you could supply sample code so we can get a clearer picture of what you'r ...Show All

• Visual Studio Tools for Office "Lock" table cells

  Hi, is it possible to lock some cells in a table in Word Meaning, I have a table where every second row consists of headers. It would be nice if the user tabs through the table without being necessary to tab through all the headers. And just skip from text cell to text cell. best regards Anders Hi Anders, You can prevent users from making edits to the document by using the Protect method of the Document, and then mark sections of your document as "exclusions" to this protection. For more information, see http://msdn2.microsoft.com/en-us/library/ms178793.aspx Kathleen McGrath h ...Show All

• Windows Forms MenuStrip control and Visual Inheritance

  Hi,  I have some questions about the MenuStrip control. Our company is switching from Visual Studio 2003 to Visual Studio 2005. The problem is Visual Inheritence - I found this post (http://forums.microsoft.com/msdn/showpost.aspx postid=20039&siteid=1) that says that Visual Inheritance is disabled for the MenuStrip and ToolStrip controls. Now, many people are sure to be discontented. Well, at least Visual Inheritance for the MenuStrip is considered for future versions.. Of course I understand that the Visual Studio team doensn't 'promise' this feature, but will ...Show All

• Visual Basic Accessing data from a datatable

  Hi, I've been really struggling with this concept for a while now so i really need help. Im trying to retrieve data from one of my datatables but i just dont understand all this datarow/datacolumn stuff. I would have thought it would have been a simple exercise but its not. Can someone do some sample code for me. Lets just say i have the following in my project. Dataset called Dataset1 Datatable called Datatable1 which looks like this: Topic Data1 Data2 Data3 A 100 200 300 B 400 500 600 C 700 800 900 If i want to retrieve the value fro ...Show All

• SQL Server December Vista CTS / VS2005 SQL Server Express Fails?

  Hey all, Using... Vista 5120 (December 2005 CTP) Visual Studio Professional Logged on as Administrator Windows Defender is turned off The installation fails to correctly install SQL Server Express claiming that there are known compatability issues, but I don't see any info on this online. Many folks are mentionign VS2005 compatability with the December CTP so presumably it's working for SOMEONE. Thoughts Help ...Show All

• SQL Server finding minimum value

  How to find the minimum value from time Timestamp column I want get the eralier timestamp vlaues from the avaliable list when iam using Aggregate transformation ..its again giving all the list of vlaues Thanks Niru no i have lot of set of duplicate values with in the same column....I have to get the Minimum ones in those sets ..like 5 5 3 3 Desired result: 5 5 ...Show All