Database

Isn't the password mentioned in the connectionstring? Bastard Programmer from Hell :suss:

An ADO.net connection will use the native client classes so it is better.

Sorry, I missed your post, yes it is the same. Good work! :) Luc Pattyn [My Articles] Nil Volentibus Arduum

:-\ That's a perfect answer!!!!How did you know that? hard work for me ;P

Really that's a nice site. Last 2 years I have used that site for 100s of questions in CP. BTW thanks. thatraja FREE Code Conversion VB6 ASP VB.NET C# ASP.NET C++ JAVA PHP DELPHI ColdFusion HTML Marquee & its alternatives Nobody remains a virgin, Life screws everyone :sigh:

I wouldn't bother -- the engine will figure it out. And deal with an Exception if one is thrown.

For this you can make Role 1 as Admin or Priorty Role.. which has command over Role 2. - Happy Coding - Vishal Vashishta

Then go with the view idea SELECT commonfields, Ing1Name AS fieldanme, Ing1Size, Ing1PRM, Ing1AcceptedUnderTol, Ing1SPCSample, Ing1TargetWgt, Ing1ActualWgt, Ing1PartialActualWgt, Ing1PreactWgt, Ing1SlowFeedTime, Ing1FastFeedTime FROM SomTable UNION ALL SELECT commonfields, Ing2Name, Ing2Size, Ing2PRM, Ing2AcceptedUnderTol, Ing2SPCSample, Ing2TargetWgt, Ing2ActualWgt, Ing2PartialActualWgt, Ing2PreactWgt, Ing2SlowFeedTime, Ing2FastFeedTime FROM SomTable Never underestimate the power of human stupidity RAH

vanikanc wrote: The select statement is not executing stating it is exceeding the 8000 characters selection limit. I can assure that a statement limit has existed for years. Pretty sure I saw it in Oracle 8. So in terms of a previous driver you got lucky because you were at the border anyways. And depending on the data it could have gone over with the older driver. The only solution for that, which I can think of (besides getting rid of all those fields) is to encode the data into xml and then return is as a blob and then re-extract.

The thing to look for is called "transaction".

Eddy Vluggen wrote: You can't "order" databases like that, you're not at MacDonalds. :laugh: "Yes... I would like a SQL Server database without onions, light on the ketchup, and oh... could you please super size that?" "The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon "Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham

Yet, I can't decide whether it can be done as commercial. Maybe a point will be in maintaining both commercial and freeware version. I'll think about posting an article, I will not be able to post it until the weekend. The first version of my program was written in old 2005:) I investigated the area that days and found nothing I could use to do the job I neeeded for free. But the time passed, things might have changed. You're right, I need to do the investigation nowadays also. If someone else will post answers here, I will be greatful!

bestbird7788 wrote: how to do? Create a linked server to both Excell files, and do a SELECT with a UNION into your Sql Server. bestbird7788 wrote: No, It's a big trouble.   so I need a tools like SQL+Excel. Good luck :) Bastard Programmer from Hell :suss:

This may be better asked in the C# forum. The biggest hurdle to database access is the security. Once you have solved that them it becomes more of a C# problem of object typing.

I did. He wants the ID's unique, and the first mailadress for that ID. Did I miss something? :) Bastard Programmer from Hell :suss:

jschell wrote: Excellent example. Graph 1.5 billion data points (from your first requirement) - so xactly how many pixels are on your screen? In meantime we already got here and I told my boss we need to downsample the information. :-) V.

And your question is? Never underestimate the power of human stupidity RAH

jojoba2011 wrote: hi dear I'd like to suggest a more neutral greeting. jojoba2011 wrote: See can u give me something like that No, because the structure of the ldf-file isn't public. You'd still need to talk to Microsoft if you want to read the ldf-file. Or try and lull the company into handing you some help. jojoba2011 wrote: I know that u can do that cause ur expert in SQL. Nope; I can only give some options - You can do a real audit in Sql Server, not Sql Express You can trace, but that doesn't show the "old" values You can insert without update. Sounds wrong, but is often the best solution, since your table is the most optimized structure to hold that type of data. You could create triggers to copy both old and new values to some other table, which would be the complex version of the point above, without too much added value. You can change the datalayer of the code talking to your server, and have it log there. Talk to Microsoft Bastard Programmer from Hell :suss:

Thanks for exporting me :cool:

Your syntax appears to be incorrect. Read this[^] to see how to construct a cursor. "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair. nils illegitimus carborundum me, me, me