manukahn's Q&A profile

• SQL Server SQL Server Management Studio Reports "Column Prefix" errors on fields such as [First.Name] and [Last.Name]

  Hello, I have an existing SQL 2000 database that I am now accessing from SQL Server Management Studio. In the past, I've created specific tables using dot notation within the field names. I've used Enterprise Manager to edit and update these specific tables without problems. As far as I am aware, the dot notation is legal for SQL Server 2000, 2005, XML, etc. The following example table illustrates the problem I am having. CREATE TABLE [dbo] . [TestTable] ( [First.Name] [varchar] ( 50 ) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, [Last.Name] [varchar] ( 50 ) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL, CONSTRAINT [PK_TestTable] PRIMARY KEY CLUSTERED ( [First.Name] ASC , [Last.N ...Show All

• SQL Server Reporting Services for SQL 2005 Standard

  How do you enable reporting services in SQL 2005 When i initially installed SQL 2005 i allowed everything to be installed, but now i do not see how to get into reporting services to get it started. I also look in the Surface Area Configuration Tool to see how to enable it but did not find anything. Can someone please help me Can you launch the RS Config tool from, %programfiles%\Microsoft SQL Server\90\Tools\Binn\RSConfigTool.exe Thanks, Sharmila ...Show All

• Visual C# Delegate a function from a native code to C#

  Hi, One of my DLL ( which is native code) I am using in my project contains a function which calls a function in its parameter. [ DllImport ( "C:\\PCI-Dask.dll" )] private static extern AI_EventCallBack( int CardNumber, int mode, int EvewntType, int callbackAddr) How should I declare the DLL function and use it Thanks a lots for your answers... Crazy68aseric wrote: But I am quite lost in deleagtes types. You declare them with the delegate keyword, something like this delegate void Foo( int param1, string param2 ); Crazy68aseric wrote: Should I simply put IntPtr Callbackaddr as the parameter of the function Where do I say that it is a delegate t ...Show All

• Visual Studio Tools for Office Accessing Action Pane in Word Automation

  I've been reading on Word automation and user controls such as Action Pane. However, I could not find any examples on how to access controls thru Microsoft.Office.Interop.Word.Document interface (or maybe I missed them). I am able to open the template using Microsoft.Office.Interop.Word.Application and see that functionality of all the controls persists. Now I just need to do it programmatically. Thanks, Olga Hi Olga Host or Windows Forms controls you add to a Word document, using the VSTO interface, are only exposed in the VSTO interface. A Word or Office interface can't work directly with a managed control. Behind the scenes, the control is actually embedded into a COM ActiveX control, and this ...Show All

• Visual Basic wininet API

  Using functions available in the wininet API, I get the files in a directory from a remote unix server with their timestamps. I use FileTimetoLocalTime first to convert the UTC time to local time and then use FileTimeToSystemTime to get the system time - as suggested by the article in MSDN. But the lastwritetime obtained thus is always 8 hours off of the real time and the creationtime and lastaccesstime are always 12:00:00. Also for very old files, the date also is off by 1 day. Why is this Am I missing something or is the code to get the system time is wrong Please let me know. Thanks! Here is the code snippet Private Function ConvertToDate(dtGivenDate As FILETIME) As Date Dim dtDateinSYSTIME As SYSTEMTIME Dim dtDateLocal As FILE ...Show All

• Visual Studio User Interface Editor

  I am trying to bring up visual basic 2005 express' "User Interface Editor" so that I can specify how I want the user's installation options to be set up. I've looked in the help files, as well as googled this. I've found two ways to get to the editor. Either by going to "View", "Editor" while having the solution explorer window selected, or by clickin on an icon on the solution explorer window for the User Interface Editor. However, looking at the program, I have neither. There is no button for this on the solution explorer window, and no option in the view menu. Can anyone help me Thanks, James With more research, it looks like you have to create a deploymen ...Show All

• Visual Studio Tools for Office Save MailItem as MSG file

  Hi, How can I save the an Outlook.MailItem as .MSG file on Hard Disk Andy Ho Hi, This is my function to save the msg. I'm trying to get the .eml files and save them as .msg files to re-open/view in Outlook. I'm sorry Sue, that was not saved as an appointment item, but discussion item . This code works very fine in two machines, and saved correctly as .msg formatted mail. But not with 3rd machine. I don't know where the problem is in Did I miss something here Thanks in advance, Kannan. Public Function SaveAsMSG(ByVal emlPath As String) As String On Error GoTo Err_SaveAsMSG Dim sMsgName As String Dim objPost As Outlook.PostItem Dim objSafePost As Redemption.SafePostIte ...Show All

• .NET Development Creating a "Proxy" for Client-Web connection

  Hi, I have created an application that uses internet connection (think of it as a web browser), but this application is going to run on another computer, by another user, and instead of accessing directly the web, I need that application to access the web, through my computer. So basically I need to create a sort of proxy server for that application, so it accesses the web and receives the data, all done through my computer, that will be using a small application to serve as a 'proxy' for the connection between the client application and the web. ? I need help in creating this kind of server, and I will also need to know what will the client application need to communicate with the 'proxy server', that will be my computer. Here ...Show All

• SQL Server Configuration file for Connection Info (how do i set password)

  Hi All, I'm new to SSIS. I'm trying to build a simple package, run it on dev and migrate it to our stg and tst environments. It works on my dev environment great! It simply loads data from a flat file into a table. The trouble i'm having is exporting the connection string info to an xml file and runnign it on other environments. I am not storing the package on the db. I am saving to a file and running through SQL Server BI Development Studio. I go to "Configuration File" and export InitialCatalog, ServerName, User, Password to the file. I can manually change the xml to the new environment but don't know how to set the password. It's not in the xml and i am constantly getting "Login failed for 'sa'" errors. Anyone know h ...Show All

• Smart Device Development Displaying images using IImage - SRC rectangle ?

  Like many people who have been using the imgdecmp method to load jpg and gif images in previous OS versions, I'm now migrating to use IImage. I have my code working calling CreateImageFromFile() and then Draw() using NULL as the source parameter. I then get the entire image displayed in the destination rectangle that I specify. What I havent been able to do is to specify a source rectangle so that I can display only part of the image. Basically I want to be able to pass in : srcX srcY srcWX srcWY dstX dstY dstWX dstWY The API description of Draw() says that the source rectangle is expressed in 0.01mm units. So I have tried to do: pImage->GetImageInfo(&imgInfo); SetRect(&src, (int)(srcX / imgInfo.Xdpi * 254.0), (int) ...Show All

• Smart Device Development Updating listview frequently

  Hi, I have a list view to support presence, it has a buddy and his status using (Session Initiation Protocol). I want to update it whenever someone changes his status. What is the best way to update it If you override cell painting and draw that icon, sure. NETCF V2 SP1 needed for that. ...Show All

• Visual C++ Trouble using C# class in both managed C++ and C#...help!

  I have a managed C++ wrapper class that I am using to access native code. One of the methods in this class returns a type of object that is defined in a C# library. I am able to compile and see all the class. I am having trouble with the crossover between C++ and C# though. When I use this class in the C++ managed class it seems that I have to creat a pointer to this object type. In C# however, I can't have a pointer to this type. I need to be able to get across this barrier. Any suggestion on how I need to declare things in order for this to work Thanks One thing that you should remember, in C#, the fact that you are using pointers is hidden from you. But when you create a class you are actuall ...Show All

• .NET Development Error when saving a "Computed" table column.

  I have a very simple "order" database table. This table have one column that is computed. When i create an application in VS2005, using "drag and drop" i get an error when i try to save:  The column "mycoloumn" cannot be modified because it is either a computed column or is the result of a UNION operator. Of course, i don't want this column to be saved - i only want my application to read it. Does anyone know how i can prevent this from being saved when i click the save button that was added in the bindingnavigator automaticly you have to modify the "update" and "insert" statement in your adapters propeties so that when you update or insert the comput ...Show All

• SQL Server Problems Accessing SQL after going from SQL 2000 to Mgmt Studio SQL 2005

  I installed Mgmt Studio and SQL 2005 on a new server - I imported my complete old SQL 2000 databases - then shut down my Original SQL 2000 server and used that Idenitical IP as the Mgmt Studio SQL 2005's IP I am using Linux Jakarta Tomcat v5.0.27 and all SQL references are referring only to the IP number of ther server and not using DNS - Originally I was getting an error when my system tried to access the SQL stating that it was an untrusted connection - I then realized that the IP number referred to was not the primary IP and I changed that so the it was. Both the Linux and SQL 2005 are now using network IPs and then I got a message that the password that I was using was not strong enough so I changed that as well - then all my ...Show All

• Visual C# NullReferenceException was unhandled.

  I was sending a pictureframe to a client in synchronous mode which meant, the program gets blocked until the client is found or transfer is complete. Consequently, I shifted to asynchronous mode. Now as far as i can see, there's nothing wrong with the client/server bit of the code but the part, where I am copying the picture frame from a clipboard throws this exception. It's utterly preposterous ! Apparently NOTHING gets copied from the clipboard and the IDataObject ends up having a null status. This never happened in the synchronous communication mode, hell, i didnt even touch the frame grabbing portion of the code. Anybody know whats wrong See the problem is that the data which i'm copying from the ...Show All