oranda's Q&A profile

• .NET Development SQL strings and distributed applications

  I am building a solution in VB 2005 which uses SQL strings to determin varoius totals etc. It works fine on my machine - but when I deploy the solution and install it on another machine, it fails to show the totals at all. I am in no way an expert so i assume that I have overlooked something simple. I would be most grateful if anyone could point me in the right direction. I don't get any error message, when you ...Show All

• Architecture designing an online & offline application... what methodology to use?

  Hello, I am at a stage where I want to develop and application that will work the same whether if you are online or offline. I can always write an application that hooks up to a server while online (connected to a network) and queries a db for the interactions bewteen the user and the app. Then when offline have another app that looks at the local database... but i don't want to write two apps... I want to build an app like outlook ...Show All

• Windows Forms SQL parameter query using INSTR

  Hello. I am using the dataset designer to create my SQL queries for a VB project, but cannot figure out how to create a query that will filter my records properly. I am using an Access database. In a nutshell, I cannot get my SQL query to distinguish between 0,1 and 10. Here is my query: SELECT ID, Word, Definition, Source, Unit, Chars, Cat, WordType, Context, Literal, Ant, Syn, ConfusedWith, OnList, Audio0, Audio1, Audio2, Audio3 FRO ...Show All

• .NET Development Streaming Data to Controls pn a Web Form

  Is it possible to stream data to a control on a web form For example, as and when a server side variable is updated, the server publishes the new value to all clients currently viewing that variable (e.g through a label control on a web form).  I have seen this done on betting web sites which show realtime updating prices.  Is it possible using C# and .NET Thanks for your help, Mark. Once the cli ...Show All

• SQL Server Need Steps to upgrade SQL Yukon 9.00.852 (Intel X86) to 9.00.1399.06

  Hi SQL DBA,s What are the step to upgrade Microsoft SQL Server Yukon - 9.00.852 (Intel X86) version To Sql 2005 Standard {9.00.1399.06}. When I tries to backup and restore from this 9.00.852 version to Sql 2005 Standard {9.00.1399.06}. It is giving me an error that this version is not compatible. What we need to do know Also let me know where I can download SQL Server Yukon - 9.00.852 (Intel X86) version so I can do the test on t ...Show All

• SQL Server AcquireConnection(txn) ???

  In a script task I'm calling AcquireConnection(txn as Object) on a connection manager. What is the txn parameter supposed to do or be used for I'm just passing an empty variable of type Object to this parameter and the method call is working fine...but I'm interested in knowing what its there for. Thanks Jamie Please, one post will suffice. I have replied, and maybe even answered, in your new thread - http://forums.microsoft.com/MSDN ...Show All

• SQL Server another simple question, please help, thx a lot!

  I have some issues for remotely connection a sqlexpress server 2005 with a c# desktop app, in my local network, after I set a port forwarding service for the computer which runs sqlexpress server, I want my c# app connect to the sqlexpress server in another machine under same local network, the connection string is: "server= 62.31.81.210.\SQLEXPRESS,1921; Database='EvoHealthSQLex'; Integrated Security=True" however, that one only work i ...Show All

• Smart Device Development How to Remove the Titlebar From the PropertySheet

  Hi, Please any one can tel me abt how to remove or hide the titlebar from the Propertysheet and Also tell me is there any way to Convert A simple dialog into CpropertySheet. any Help is appreciated. Thank you in advance. Regards, Saravanan Hi, In case you are talking about the property sheet specific title that appears at the top of propertysheet, try to lookout for the propertysheet callback and return z ...Show All

• SQL Server Long running Query

  Hi, I'm trying to optimize a long running (several hours) query. This query is a cross join on two tables. Table 1 has 3 fields - ROWID, LAt and Long. Table 2 has Name, Addr1,Addr2,City,State,Zip,Lat,Long. Both tables has LatRad - Lat in radians, LonRad- Lon in Radians. Sin and Cos values of Lat and Lon are calulated and stored to be used in the distance formula. What I'm trying to do here is find the nearest dealer (Table 2) for each ...Show All

• Windows Forms Maps

  I need to make an application with asp.net with map to recover info by click in a pam area it is somethin in framework 1.1 to make it Not that I know of, no. you shold direct this question to www.asp.net , you'll have more luck there. ...Show All

• Visual Basic Authenication and member of group

  Ok, I've seen alot of authenication with asp.net. I have a couple of things I want to try that will not, or may not have access to a web.net. 1). I want to authenicate with a windows desktop app a user with the AD in a domain enviorment. Then, once I've authenicated this user, check to see if they are a member of an OU. How do I do this Reason, I only want users that are part of a group to be able to modify data. 2). I want to ...Show All

• Visual C# Communication beetween WebService and Windows application

  Hi all. I'm writing a very simple instant messenger. I want to use WebServices as a proxy for users' messages. Windows application invokes a method in WebService, then WebService sends the message to each connected user. I don't know how to send the message from WebService and recive it on Windows application. How to do that I've got no experience with communication in the Internet. I've got also the second problem. How to get an IP address of t ...Show All

• Visual Studio 2008 (Pre-release) database support

  Hi! Will LINQ support database providers other than sql server Actually, I didn't ask -- someone else did. But I *was* wondering when a Mono-affiliated project was going to be doing something with this, aside from the XLinq classes that were whipped up during PDC. ...Show All

• Visual Basic Multiline strings in components

  Hello, how can I build a multiline string in a component as the Items-Property of a ListBox-Component See this article at codeproject. ...Show All

• Visual Basic Blair Allen Stark

  Here is the problem I am working on. It asks me to use the method CalculateCharges, but I don't fully understand how to do this or how it works. I would be grateful for any input. Lab Problem III A parking garage charges a $2.00 minimum fee to park for up to three hours. The garage charges an additional $0.50 per hour for each hour or part thereof in excess of three hours. The maximum charge for any given 24-hour period ...Show All