Irenej's Q&A profile

• SQL Server Differences between metacube (informix) and SQL server analysis services

  I would like to know differences between metacube (informix) and SQL server analysis services in terms of 1. What issues need to be considered when migrating from metacube to analysis services. 2. Features 3. Other improtant differences.   Thanks in advance C10 ...Show All

• SQL Server JDBC Driver for J#

  Will there be a SQL Server 2005 JDBC Driver that can be used from J# I have code that must compile in both J# and Java so ADO.NET and System.Data are not an option. The normal JDBC driver is just a JAR file so not accessible from J# only Java. Thanks! Ted Ted: J# ships with an ODBC-JDBC bridge and it should be as easy as selecting SQL Native Client as your driver option when you add a System DSN - ...Show All

• .NET Development Writing dates to XML documents

  How do you write a date value to an XMLElement in .NET 2.0 XMLDocument object. I am using the following: Dim deliveryDate As Date = CDate (txtDeliveryDate.Text) elem.InnerXml = XmlConvert.ToDateTime(deliveryDate.ToString( "yyyy-MM-dd" ), System.Xml.XmlDateTimeSerializationMode.Utc). But when I validate against a schema where this element is defined as date data type I get the following validation error: The 'http://w ...Show All

• Smart Device Development Using VS2005 for WinCE 5.0 development

  I have a native C++ Windows XP app that I need to migrate to a WinCE 5.0 ARM platform.  My project is currently in VS2003. I hear that VS2005 can be used to develop native WinCE 5,0 apps.  That is great for me, because I could easily move my existing code from 2003 to 2005, and then it should be easy to keep my WinXP and my WinCE code in sync since they will use the same IDE and compiler front-end. Do I need a particularr edition of ...Show All

• SQL Server EXEC Strangeness

  Hi all, I would be very grateful if anyone can detect the problem with the following code. I have indicated the offending line. Basically if I hardcode in @BelegId, it runs with no problems. Declare @SQL VarChar(1000) Declare @TableName VarChar(1000) Declare @Result Varchar(50) Declare @BelegId int Set @BelegId=447 Set @ObjName='s_jps.ap_gr' if (object_id (N'tempdb..#tempt') is not null) drop table #tempt; create table #TempT (result varchar(100 ...Show All

• SQL Server Several questions regarding database mirroring.

  Our company is looking to move to a more robust database platform/setup, and it looks like sql 2005 + database mirroring is what we are looking for. First I have some questions about it. Can a server that is functioning as a mirror for one database be the primary server for a seperate database Basically think of a triangle of three sql servers, each serving as a primary server for a specific database, and using the next server in the triangle as ...Show All

• SQL Server Different row delimiters in same connection manager

  I have a situation where two CSV dmited types are read in. One file row type could be CRLF while another could be CR. Seeing how the only difference between these file types is the row delimiter, I would like to use one conn manager. Is it possible  Ideas It will certainly have some performance impact. You should probably do some tests to verify how acceptable the cost is for the added manageability of your p ...Show All

• .NET Development Service and COM don't work with Windows XP Service Pack 2

  I have a service application created with VB.NET that creates a COM object. The service works fine in Windows 2000, but in Windows XP with service pack 2 it doesn't  because it receives the "Access denied" error. If I create a windows form application instead of a service, it works fine even in Windows XP with service pack 2.  Can someone help me   Run dcomcfg.msc and check the security settings (L ...Show All

• Windows Forms control character to Hex

  Hi, Does anyone know in vb.net how to convert string "control character" to their hex number Example: character             Hex       ESC               1B       GS  ...Show All

• .NET Development List of OleDb Providers

  Hi, I'm developing a generic database interface tool. Some vendors have their Dot Net drivers, while in other cases I need to go through an OleDb provider.  I'd like to show the users a list of available OleDb drivers installed on their machine.  I've seen other tools (e.g. DTS) doing this. How would I get a list of available OleDb providers in Dot Net code   I realise this is a low-level feature, and, if it gets too complex, then ...Show All

• Visual Basic Dim wmpvideo As WMPLib.IWMPVideoCtrl - Interfaces?

  Hi, I am trying to change the ‘maintainaspectratio’ and several other properties but a solution to this should solve all other of my questions. Dim wmpvideo As WMPLib.IWMPVideoCtrl wmpvideo. maintainAspectRatio = False   This builds ok but then breaks with a ‘NullRefrenceException’: ‘Object reference not set to an instance of an object.’ I have also tried changing Dim wmpvideo As WMPLib.IWMPVi ...Show All

• Windows Forms VS.Net IDE - All Object Data Sources Gone

  This is going to be hard to figure out, but I thought I'd post in case someone else has experienced it or the MS folks have any ideas. I was testing out Winforms today and had created several Object Data Sources. Everything was working very well and all of the data sources I added appeared in the data sources window. I then attempted to add another Object datasource using the Data Source Configuration Wizard. I selected the assembly for the new ...Show All

• Smart Device Development Name Resolution

  I'm really newbye on Device Emulator. That's my problem: I have to use ActiveSync with a server for what i cannot have a certificate. I would like to us local PC host file to map "server.domain.com" to another IP address so that the certificate I have for "server.domain.com" could be used for that Sync. I don't know if the certificate will function well, but my first problem is: how does the Device Emulatro resolve netw ...Show All

• Windows Forms How to get IIS's local path by c#?

  Hi all: I want to get localmachine or remote machine's local path of IIS, such as "C:\Inetpub\wwwroot". How to implement it by c# Thanks alot! Use the Microsoft.Win32.Registry class to read the PathWWWRoot value at HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\InetStp. This will only work for the local machine. I doubt there is a way to get this programmatically for a remote machine. ...Show All

• Visual Studio Internet Connection in VS 2005

  Hi,       I just installed VS 2005 on my machine, but my online help cannot be accessed. I keep getting the message: "The request failed with Http Status 407. Proxy authentication required". IE on my machine does have proxy authentication. Is there a fix for this   Thanks, Arshad Arshad, Where does this message appear   Is it in a WebBrowser upon trying to view a help page, or is it in the Sea ...Show All