Aleniko29139's Q&A profile

• SQL Server ODBC support

  Can CE be called from an app. that makes ODBC calls Thanks. Two: 1) The existing (calling) application uses ODBC calls; 2) ODBC is the only industry standard for database access. It is an indication of MS's market power that they can introduce a new database product and ignore it. - A ...Show All

• SQL Server Need HELP Determining version

  First off...I have NO experience with SQL. I need to determine the version we are running. I am not even sure if we are running MSDE or full blown SQL Server. It was installed as part of our accounting software. When I go into services, there are several MSSQL services running. They are... MSSQL$JURIS MSSQL$SOPHOS MSSQLServerAdHelper Can someone please help me figure out WHAT we have installed and the VERSION Thanks in advance! Dave G. hi dave, you can connect to them using sql server enterprise manager or querry analyzer  using windows or ISQL or OSQL at  the command prompt for 2005 you can use management studio  or SQLCMD at the command p ...Show All

• Visual Studio Tools for Office Access Developer Extension

  We are mainly Access developers and VBA programmers for 12 years, we develop several rich and sophisticated applications using Access and SQL server, we bought Visual Studio Tools 2003 for Office two years ago, we use custom startup wizard and package wizard to deploy Access applications to our customers, now our license is expired, the package no longer run, we try to renew the license for VSTO 2003 but our Microsoft product reseller told us the license can not be renewed due to some (software assurance)!!! bla bla bla, and we must purchase VSTO 2005 to maintain the same jobs. After exploring Microsoft site about VSTO 2005, we find that the new VSTO contain the same functionality (Access Developer Extension), But some Access develope ...Show All

• .NET Development Cannot find configuration tool for .netframework 2.0

  Hi, I just install .netframework 2.0 redistribution package on a Windows 2000 server. The installation went successfully but I could not find any configuration tool. It is not under control panel--administration tools and I could not find any SDK Command Prompt. Did I miss another step..Please help as we need to configure its security. Thanks. It is no longer included as part of the .NET Framework 2.0 installation. You need to install the SDK. See this similar thread: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1052492&SiteID=1 ...Show All

• Windows Forms ListBox text alignment w/decimals

  Hello out there. Populating listBox easily with Tostring. However, my decimals do not align neatly. For example: Item name Item Number 100.22 item name2 Item Number2 100.0 Item name3 Item Number3 100 How can I align numbers with two decimal places in a listbox thanks cPrince Why not format them all to have 2 decimal places double x = 2.1; string str = x.ToString( "#.00" ); If you want them to align perfectly, you might want to use a font such as Courier New where all chars have the same width ...Show All

• SQL Server Using SQL Server CE in a NON .NET Delphi Application

  Hi, I'm looking at using SQL Server CE as a replacement for MS Access in a WIN32 Delphi Application. This limits my database options to Providers that is usable from ADO. I see that the OLE DB Interfaces are implemented, but I can't connect to a SQL Server CE database from Delphi. I've cut and paste a sample connection string (replacing the data source bit) but no go I've installed the Runtime Environment, VS2005 bit, Connectivity Tools and the SDK :) Any help Anything that I might have missed Thanks, Dawid Hi, The dll seems to be registered. I can also connect to a Sql Server CE database using VS 2005. I'm using "Microsoft.SQLSERVER.MOBILE.OLEDB.3.0" as the provider. ...Show All

• .NET Development What is .NET?

  Hello, You probably think I'm the weirdest person here, but I found this place, and I didn't know what .NET is. But I have a question, and I just wondered whether this was the place to ask. Thank you, Furby check this: http://www.akaas.net/articles/what-is-dot-net.htm Regards, ...Show All

• SQL Server Data Caching in reports?

  I wrote an invoice report that gets its data from an Oracle database.  This is working fine except when users change something on the server (like adding a new charge to the invoice) then when they re-run the SSRS report the new line doesn't show up.  They wait 15 minutes and re-run the SSRS report and then it appears. It is like the SSRS report is caching the old data of the report. Points to note though... To execute the report I am using the SSRS 2005 webservice.  I understand that there is 2 cachings, 1 server and 1 IIS side.  I have not cached the server and don't know how to clear the IIS side.  I see there is a rs:ClearSession=true parameter that you can pass in but by using the SSRS 2005 webservice ...Show All

• Connected Services Framework User Aware Service

  I have an SDP Platform setup which has some services available. I am creating a new service (Service1) which has to maintain its own set of users and has a custom Token Manager which validates the request with this user set. The users can be mapped easily from the platform with the Identity manager. Now Service1 has some methods which extract information for a particular user using the userId present in Service1. There are two ways of getting the userId from the SDP Platform 1. In my service method I extract the information from the SOAP header (WS: Security) and use it. 2. Instead of having the service to extract info header, I introduce an interceptor for the service which can extract information from header and provide it as a ...Show All

• Visual Basic Visual Studio IDE and Windows Installer

  I have an issue in Visual Studio IDE. When I run the Visual Basic IDE, it automatically runs the Windows Installer and it gets hanged for atleast 2 to 3 hours, in that hours of gap, i can not even do anything with the IDE, if I try to cancel the Windows Installer process, it closes my Visual Basic IDE and every time it happens the same, either i have to wait for longer, or else keep the IDE open, once it's opened after a 3-4 hours of struggle. Kindly help in this, how could i get rid of this problem. I have already tried some solutions, nothing seems to be working. Regards Deepak This would be hard to diagnose with the information you've provided, but you might have had some registry keys get trashed. The ...Show All

• Visual C# escaping characters

  i need to write some query in code i want to know if csharp has anything like heredoc in php i hate having to write my queries like this: "select group_name = group_name, " + "group_key = group.group_key " + "from dbo.sponsor " + "INNER JOIN dbo.client s_name " + "on s_name.client_key = sponsor.client_key " + "INNER JOIN dbo.[group] " + "on [group].sponsor_key = sponsor.sponsor_key " + "where plan_key = " + planKey+; it gets really annoying just to clarify. It is much clearer if you declare query as const in the beginig of file as: private con ...Show All

• SQL Server AS 2005 and OWC10 pivot table fieldlist problems

  Hello, I have an AS 2005 cube set up which I can connect to via OWC10. I would like to try to reorganize the fieldlist and group the dimensions. The problem is I don't seem to have much control of the field list. For example; in the code below, the first alert box displays 23, yet the second alert box within the loop is never executed. Why am I unable to loop through the fields in the fieldset Also, I think the best thing for me would be the ability to replace the fieldlist with my own fieldlist, but how do I do this so the user can still drag things from my fieldlist to the pivot control Thanks. (jscript) pTable = Form1.pivot alert(pTable.ActiveView.FieldSets.Count) for (var fSet in pTable.ActiveView.FieldSets) { alert(f ...Show All

• Visual Studio Howto programatically add references to active project?

  Hi All, I'm relatively a newbie in dot.net development. But I've working experiences with VC/VB programming as well as Java. So, not finding too hard to adopt myself with the flexibility offered by dot.net framework. Recently I've been creating a web application development framework which will include a custom control library to be used in the web projects associated with the framework. To maximize the usability of the framework I've planned to create an Custom Web Project Item Template Wizard that will create a web form based on the framework when selected from the Add Item. As additional features in the wizard, I want the wizard to check active project references for my framework dll and add references to ...Show All

• SQL Server Security Update for Microsoft Data Access Components (KB832483)

  I recently reformatted my computer and am using Windows 2000 Professional. I enabled Automatic Update. This morning I noticed that the "Security Update for MS Data Access Components (KB832483)" kept showing up. My records indicate that it successfully installed (several times), but the same update keeps showing up to be installed. I finally disabled the Automatic Update function in order to keep it from constantly reappearing. Any ideas I wonder if you are running this on an old win 95 machine updated to 2000 with Ram increased from the original 32MB to 128, 8G hard drive added to the original 3G one and the old STB card replaced by Voodoo3 If not count yourself lucky! though it is fun. ...Show All

• Smart Device Development Displaying 2 lines on a button

  Hi, I'm trying to display 2 lines on a button. I do it the following way: Button1.Text = "This is line 1" + vbCrLf + "This is line 2" What happens is that the text is displayed in a single line. If I'm doing the same with a Label: Label1.Text = "This is line 1" + vbCrLf + "This is line 2" The text is indeed displayed in 2 seperate lines. So how can I display two lines on a button General details: I'm using Visual Studio 2005, developing an application for Pocket PC 2003 SE using the Emulator. Thanks Amir We needed the same thing, so I went to chuckk@amerbar.com , who wrote us a custom control that allows you to display one, two, or thre ...Show All