Daniel Dosen: XML Commerce's Q&A profile

• SQL Server Puzzled by concurrent update

  I have a puzzle in my mind here. I will thank anyone who can solve my puzzle. I am not familiar with SQL and its theories behind, so please bear with me if I am asking a stupid newbie question. My puzzle is generally a problem of generating sequence numbers. The following SQL is only a stripped down version - it fetches the max number, add 1 to it and updates the table with the new number. DECLARE @max int SELECT @max = MAX(next_number) + 1 from sequence_numbers UPDATE sequence_numbers SET next_number = @max WHERE next_number = @max Now if user1 gets 100 and user2 also gets 100 and they both try to update the tabl ...Show All

• Visual C++ error C2664: 'ATL::_CopyInterface<T>::copy' : cannot convert parameter 2 from 'IFileInfo *const *' to 'IFileInfo **'

  Got a piece of code which was happy enough under VS2003 but fails to compile under VS2005. Its using the ATL IEnumXXX template classes to provide a concrete collection implementation. The dual interface (looks like this) [ object , uuid (552E001E-DE6A-4ED4-A35B-F58211EF485B), dual , helpstring ( "IFileInfo Interface" ), pointer_default ( unique ) ] interface IFileInfo : IDispatch { [ propget , id (1), helpstring ( "property FileName" )] HRESULT FileName([ out , retval ] BSTR *pVal); [ propget , id (2), helpstring ( "property PathName" )] HRESULT PathName([ out , ...Show All

• .NET Development ADO/SQLExpress Connection String Question

  I'm working on a customer project and deployment project. SQLExpress is part of the installation and there is a pre-existing database. As installed, the database is detached. This application uses ADO.NET to establish SQL connections and it also uses Excel VBA to connect to the database via ADO. The following SQL Connection string works for SQL (as far as I can tell) Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\XYZ_Data.MDF;Integrated Security=True;Connect Timeout=30;User Instance=True What is the appropriate ADO (not ado.net) connection string The one that has worked when the database is attached looks like ...Show All

• Visual Studio Express Editions HTTP Error 403 - Forbidden

  I've been playing around with VWD 2005 Express and when I "View in Browser" with IE, everything works fine.  But when I try to "View in Browser" with FireFox, I get a HTTP authentication prompt and then I get the following message: Server Error in '/TestParts' Application. HTTP Error 403 - Forbidden. Version Information: ASP.NET Development Server 8.0.0.0 I've tried entering USER and MACHINE\USER local accounts and still get 403 Forbidden -- any ideas Solution Explorer is one of the windows inside of Visual Web Developer. Normaly it is located in the upper right corner. You can also jump to it by pres ...Show All

• SQL Server Is this possible???

  Hello, Is it possible to have a lable and text boxes right on the top of a parameter Just like this. Last: week month 90 days year So that when a user clicks one of the link, the value in the parameter will be changed accordingly. Sincerely, Amde hey Bob, I am clear that I have to add textboxes with drillthrough actions. But here is the thing: I have given a requirement to design the report layout and create the report. the report should look like this when previewed: Last: week month 90 days year From: 4/25/2006 To: 5/2/2006 So for last wee ...Show All

• Windows Forms Program only works on my computer...Why?

  I am just a newbie with vb7, but I just finished a program that acts as a front end to an Access database on the server. Used OleDbConnection, OleDbDataAdapters, Dataset bound to a Datagrid control as the output.  The program works, I can even run the .exe from a floppy, but only on my own computer. If I carry the floppy to another compu ...Show All

• Visual FoxPro empty field

  is there a better way of checking for empty fields than select *; from myTable; where field1 = " "; into cursor data1 i need to run a complete check on the database for empty records in every field. How would i check for a 'date' data field Mike Where EMPTY(field1) This will work for all data Types. If you want to check every filled you will need: Where EMPTY(field1) or EMPTY(field2) or EMPTY(field3)... if you want something more dynamic look at the Afields() Function  Dave M. ...Show All

• Visual Studio 2008 (Pre-release) Can't get IIS to host WCF service

  When viewing in a browser, I get: Server Application Unavailable In the Event Log (application), it says, "Failed to execute the request because the ASP.NET process identity does not have read permissions to the global assembly cache. Error: 0x80070005 Access is denied. " Here is some vitals for this service: Assembly Name: CompanyWorkerService Workspace: LR.Services.WorkerService Interface: IWorkerService Type: WorkerServiceType Here is my web.config entry: < xml version = " 1.0 " encoding = " utf-8 " > < configuration > < system.serviceModel > ...Show All

• SQL Server Load assembly from Stored Procedure

  Hi, Is it possible to load an assembly either from a byte array or from the disk at runtime from a CLR stored procedure. I have created a stored procedure that needs to load different assemblies depending on a query and then invokes a method (called execute() passing a string query as a parameter). From debugging the CLR stored procedure in .NET I have found that it is this line that creates an error:     Assembly myAssembly= Assembly .Load()   It doesnt matter if I attempt to load the assembly from it's byte array or from a ...Show All

• Visual Studio Express Editions How to publish ?

  I want my program to be install in a particular directory, for example c:\program files\abc, I cant see where can I force the publish wizard to do so. Beside that how do I include an external file into the project Like a readme.txt, or a mdb database which has almost nothing to do with my application Please forgive this one but i am a newbie to VB2005 Express: i am having trouble including a compiled Help File (.chm) with the app so i can deploy it via ClickOnce. The help section basically says go to Solution Explorer, right click, then select Publish from the tabs and select Application files. But there ap ...Show All

• Visual Studio Could not Connect Oracle from dot Net

  Hi When I am trying to connect to Oracle and while opening the connection from c# of .Net  I am having an error as "Oracle error occurred, but error message could not be retrieved from Oracle". I am using OledbAdapter. ConnectionString is "Provider=MSDAORA.1;UserID=spa;password=spa;server=oradb"  Please help me.                                                  Siddhartha Hi Siddh, try usin ...Show All

• SQL Server identity

  i am using sql server mobile I have an insert statement with select @@identity: commandString = "insert into Location (Address,Suburb,State) values('627 beach rd', 'rose bay', 'NSW');SELECT @@IDENTITY" I execute the insert statement as below: command.CommandText = commandString; id = command.ExecuteNonQuery(); I get the following error: Error: There was an error parsing the query. [ Token line number = 1,Token line offset = 137,Token in error = SELECT ] Source: SQL Server 2005 Mobile Edition ADO.NET Data Provider this statement works ok in sql mobile query analyzer does anybody know where i am going wrong do i need an output paramete ...Show All

• .NET Development Setpixel and Getpixel method on bitmap class is very slow

  Hello, Right now I am working on graphics assigment in which I am using bitmap class and bitmap  members setpixel and getpixel  but these two methods are very slow due  to which the performance of my application is degrading. Does anybody know the substitute for these two methods and which is fast. Thank you for your patiance. Double post Jerald Check my answer over at this post: http://forums.microsoft.com/msdn/ShowPost.aspx PostID=18107 ...Show All

• Visual Studio 2008 (Pre-release) how to serialize my collection of itmes

  hi all, i have a colletion of items. now i want to serialize this collection. here is the example:- Eg: foreach (item in my collection_items) { item.serialize() } Can anyone please help me in doing this!! Thanks in advance bye nani There a a lot of examples of serialization over Internet: Have you try to search Also, there are not just 1 serialization but many: XmlSerialization, BinarySerialization, etc... Which one do you want to implement Bye ...Show All

• Visual C# Culture specfic decimal search in DataTable is failing

  hi all I'm getting a problem in select method of a DataTable. I'm using V 1.1 my current thread's culture is de-DE i.e) Germany. So here the decimal separator is "," and thousand separator is ".". if I try to do something like below it is throwing an runtime error " Syntax error in the expression. " CultureInfo myCultureInfo; string cultureInfo; cultureInfo = "de-DE"; myCultureInfo = new CultureInfo(cultureInfo, false ); Thread.CurrentThread.CurrentCulture = myCultureInfo; decimal val = 7508.05M; DataSet ds = new DataSet(); ds.Tables.Add(); DataColumn dc = new DataColumn(&quo ...Show All