Realtek hd 191 driver available
For interested people that have the following HD realtek devices. 1.91 version is now avail Xp and Vista
Things fixed
- Support ALC663/ALC272.
- Support ForteMedia microphone effect APO feature.
- Customizations.
- Windows Vista WHQL: ALC882, ALC883, ALC885, ALC888, ALC861VD, ALC660, ALC662, ALC663, ALC260,ALC262,ALC267, ALC268, ALC 269, ALC 272
- Windows 2000/XP WHQL: ALC880, ALC882, ALC883, ALC885, ALC888, ALC861VC, ALC861VD,ALC660, ALC662, ALC663, ALC260, ALC262, ALC267,ALC268, ALC269, ALC 272
- HDMI Device WHQL Support: ATI HDMI Device
Remember Search is your friend.
Keith
SoftGrid at MMS
This week is the Microsoft Management Summit (MMS) in Las Vegas.
A number of SoftGrid folks will be gathering Monday night to meet and libate. The group is rumored to include some of the Microsoft SoftGrid team - but who knows? We know for sure that there are a few scheduled presentations on SoftGrid at the conference itself, so they are in town. Below is a reprint of the posting by our organizer, Kevin Kaminski over on the softgridguru.com board:
Ok, this has been a bit of a circus to figure out but I've come up with something. How about the Laguna bar at the Palazzo on Monday the 28th of April at 7pm. The address is 3325 Las Vegas Blvd. South and is basically right beside the Venetian.
http://maps.google.ca/maps?f=q&hl=en&geocode=&q=palazzo+hoteal+las+vegas&ie=UTF8&ll=36.123282,-115.17059&spn=0.000975,0.001808&z=19&iwloc=A
I've never been there but it's close and does have capacity for what we want to do.
Everyone is invited and no reservations needed. I'll see you there!
- Changed type Tim ManganMVP, Editor Friday, July 10, 2009 9:47 PM
SP3 and Athlon 64 X2 install problem
I installed SP3 on three Intel machines (2 desktop; 1 laptop) with no problems. However, it caused major problems on my Athlon 64 dual core. No longer could boot to anything, including safe mode or logged. Repair console did not work, nor did a repair reinstall, nor manual loading of video card drivers, nor replacement of video card with a standard PCI card for generic video driver boots.
I did not want to do a new clean install due to the amount of work, home, and photo software/databases I use (6 HDs, 4 Gigs, etc.). Finally had to make a new XP install disk streamed with SP2, install to a new drive, and once booted to that drive, manually copy the 5 key restore files from my original boot drive's restore point immediately prior to the SP3 update to my origianl drives system32\config directory. Once I rebooted everything was back to normal.
Thanks Microsoft. Your lack of foresight in providing an easy CD-boot routine for extracting these lousy 5 files from a restore directory and inserting them in the current config file is appalling.
Reply:
Extract or create your integrated image to c:\sp3
From the CMD prompt (start>run) type c:\sp3\i386\winnt32.exe
Press enter
Choose "upgrade"
Enter your serial key.
After two reboots, you are back at your desktop and no need for recover options. You will still have all your files and folders and shortcuts and desktop as you had it before performing the upgrade. Hope that helps you out in the future.
------------------------------------
Windows Vista SP1 RC Available to the Public
We are pleased to announce the general availability of Windows Vista Service Pack 1 (SP1) Release Candidate (RC). It can be downloaded from http://technet.microsoft.com/en-us/windowsvista/bb738089.aspx. Please use this forum to discuss any issues with SP1.
A couple of caveats:
- We want to remind you that Windows Vista SP1 RC is pre-release software, time-limited, and is intended for IT professionals, developers, and other technically-inclined individuals that are comfortable using pre-release software.
- Please be sure to read all release notes and installation instructions carefully before downloading and installing Windows Vista SP1 RC.
Cheers,
-Tony Mann
Reply:
Hi Anthony,
Why don't you publish an error code list and what they mean? This may be helpful to all that are having installation issues.
Thank You,
Jim
------------------------------------
Reply:
We are publishing error codes that IT Pros are reporting and associated fixes for those errors. See the FAQ at http://technet.microsoft.com/en-us/bb972745.aspx.
------------------------------------
Reply:
this will help you too... http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=2581895&SiteID=17
------------------------------------
Reply:
Tony,
Simple question as I have a number of guys running Vista who are very interested in the results I have been getting with this RC1 version of the Service Pack:
Q. Is the Release Candidate 1 version on the Vista Service Pack 1 still only available to TechNet members and if not where can a non TechNet member download the standalone Service Pack?
Thanks if you can clarify?
Ridesy
------------------------------------
Reply:
HI Ridesy,
The page at http://technet.microsoft.com/en-us/windowsvista/bb738089.aspx shows the different ways to get Windows Vista SP1 RC. You don't have to be a subscriber to get it (although you did when it was first released).
One question though...What results are you getting with SP1 RC that people are interested in? Can you post some specifics?
Cheers,
-Tony Mann
------------------------------------
Reply:
Have had it installed a couple of days .
No instalation problems if you follow directions.
Computer is fast in several ways startup, shutdown surfing the web.
memory usage has dropped about 3%
One thing I was hoping for is a speed up of windows updates compared too xp updates vista is very slow in finding updates.
Is SP RC1 available on diskif not will the final release be available on disk as I have a son in the Army in Afganistan and would be eaiser for if I could get a disk and send to him!
So far a good job.
Thanks
LES
------------------------------------
Reply:
Tony,
Thanks for reply and I will check the detail on link to see if the guys who have asked can get it.
As to results: I have posted twice in forum and sent both feedback and a bug report back already, as I have the SP1 installed on three very different PC's with varying results.
The laptop (on which I am working now) is not a particulraly hi-spec one (single core 2Ghz Intel, 2GB RAM) and SP1 really has made little difference to this other than file transfers on Server 2007 network are a bit quicker and login off network (when remote) is quicker. The boot up time for the laptop seems slower (side-bar takes a good minute or more before it finally appears), but it always has been slower than other PC's with Vista and is a dual boot test laptop that really needs a full re-install with the SP1 combined to properly test if things have got better or worse (as the machine has loads of programs loaded to test with Vista and then SP1).
Two Desktops have SP1, one running 32 bit one 64 bit Vista and the results are noticable most on the 64 bit version, but not really in work environment stuff.
For my sins I play online FPS games and oddly the installation of SP1 on the Vista 64 machine has suddenly allowed it to run a game (COD2 Multiplayer) that had previously flatly refused to run and frinds still cannot get it to run on pre-SP1 versions (32 bit is OK, just 64 won't load). As soon as SP1 was installed , the same installation of COD2 started first time - no idea why, it just did.
Also have found that connecting to multiplayer games is for some reason now almost instant (1 - 2 sec max) when pre SP1 it could take 20 secs.
I have however posted two issues and reported feedback too:
1. On installing SP1 on the Vista 64 machine the Creative XFi soundcard was not working correctly (fine before) and I had to unistall and re-install drivers - and now it works fine.
2. Most annoying however is that the Vista 64 machine now rarely fully closedown the PC (1 in 10-20 attempts), the shutdown procedure appears to run fine (Windows shutting down etc...), screen goes blank and PC would normally switch off, but MB power remains on, fans etc working and even leaving for an hour or more it just sits there until I force a shut-down with power button held in for 5 secs.
On restart, no error in logs nothing, Vista starts fine, no request to start in safe mode etc, but the PC just won't shutdown fully.
I have now found that I am certainly not alone (replies to thread here) and for me the only time it does shutdown properly is if the PC has only been on a matter of minutes, anything longer and it won't close.
I did suggest in thread that I'd be interested to see if the same happened with a new install (containing SP1), but I haven't had time to re-install a new copy with SP1 to test.
Ridesy
------------------------------------
Reply:
Hi Ridesy,
Thanks so much for the great detailed feedback. I'm glad your experience with SP1 is mostly positive.
Cheers,
-Tony Mann
------------------------------------
Reply:
------------------------------------
Reply:
I have a couple questions to ask before I install this SP1 RC. First has anyone tested it on a HP Pavilion Laptop DV9500T? I am curious to know if it fixes the issues with the HP Quick Play or launch buttons. When I got this laptop a few weeks ago the buttons worked and now since some Windows Updates or something else now they don't work anymore. Also if I do install this what happens when the final SP is released? Do I uninstall this RC1 or will the final version just upgrade it?
Thanks!
------------------------------------
Reply:
Installed on two machines
Dell and Compaq, Vista Home and Ultimate
hung, black screen, reboots, slow
both machines Core II 2.0+g processor with 2gig ram and 100gig hd clean install 80% open drives NO other programs loaded
From the experience, I had to reload, I will pass installing on other machines.
MD
------------------------------------
Reply:
The update always got to the third stage of installing and always said 100% before rolling back.
------------------------------------
Reply:
| Scott Micale wrote: | |
|
The problem is that after some time Vista updates the original mouse driver to a "newer & better" PS/2 mouse driver. Just updating the driver from Device manager will not help as Vista still finds the PS/2 to be more suitable.
The solution to the launch buttons issue is:
- uninstall the mouse driver
- reinstall the Synaptics Touchpad driver found on HP homepage.
After that it should be fine!
Regards,
E.
------------------------------------
Reply:
Vista Version: Home
Installed the SP yesterday hoping it will fix the endless number of problems I have had with my laptop with blue "screen of deaths"
So far noticed shutdown is a lot quicker from 2 mins down to about 15seconds
Startup seems very slow now takes maybe 10-15s longer
Also dont like the fact on my desktop I have got the message
"Windows Vista"
"Evaluation Copy XXXXX"
------------------------------------
Reply:
Hi Tony,
To understand it clearly, could you provide us with a more accurate time frame for the Official Release of SP1 in combination with IE8.0 and eventually SP2 ?
This informations in enourmously usefull to plan Vista + Office Migrations.
Thx !
------------------------------------
Reply:
I have downloaded the latest vista service pack one rc. When i click on it the UAC pops up. I hit ok and it disapears. But then nothing happens. Anyone know what might be up with it.
I have looked and dont have any service pack entrys in the update page.
------------------------------------
Reply:
I've downloaded windows vista service pack rc. When i double click on it, and ok the UAC, nothing happens. No installation starts with no errors given,
Can anyone help me?
------------------------------------
Reply:
------------------------------------
Reply:
hello,
I installed SP1 RC over a Vista Business and since then i have a Evaluation Copy Build 6001 in my right lover corner. I have to say that Vista Business is a fully licensed copy and i am able to download updates after microsoft website validates my copy of windows.
Is this normal? or should i be worry?
I suppose that it will go away after instalation of SP1 final release... or not?
------------------------------------
Reply:
If you have build 1840 then that watermark should disappear after a few reboots. If an earlier build then you will have to uninstall it prior to installing SP1 RTM.
Then the watermark will disappear.
------------------------------------
Reply:
I downloaded the standalone and I get the error below and I cannot install the update using windows update.
Error code 0x80010108
I thought that perhaps my computer was mistakenly telling microsoft update that I already have sp1 but my winver tells me that I have version 6.0 build 6000
Why the <expletive> am I unable to install this update?
I am still having problems with WMI and Internet Explorer.
------------------------------------
RE: Unable to install my new Kodak 5500 All In One Printer.l
I have read the comments about installing the 5000 series printer and the associated software. I don't know all the circumstances surrounding the different installs, but I would like to give a few general tips for anyone who still cares.
FIRST: To the person with the BAD_POOL_CALLER error, I searched Microsoft Knowledge base and found this issue with several OS systems for various reasons. Microsoft states it is a known problem and in most cases there is a hot fix for it. They also suggest waiting until the next service pack comes out (depending on when it was written and what the exact issue is).
SECOND: The software will work on both XP with service pack two and Vista. Make sure your system meets the miminum requirements. All products state these requirements on the product box if people would just read them.
THIRD: The printer works well on a USB2 cable 6 foot or less and it needs the full power of a usb port (not on a hub). It will work on a USB 1.1 and even if it is longer than 6 ft, but you might have intermittent connection problems. In the case of Dell computers, the USB ports are sometimes a problem because of the way Dell configures them internally. Sometimes you have to try each port until the software recognizes the printer and will allow you to click on the NEXT button. If it does not see it, the software will sit there until hell freezes over.
FORTH: You can do just about everything using Microsoft's drivers that you can do with Kodak software execpt scan documents to rtf format for editing and programming your phonebook on the 5500, which you need the HomeCenter software to do each of those. There might be one or two more, but those are the big ones as far as I'm concerned.
FIFTH: The fax machine will not work on a digital phone line. If you have DSL you need to have a filter on the line going to the fax just as you do going to your phone.
SIXTH: Kodak does have at least 2 call centers in the US. One is right at Kodak headquarters in Rochester, NY, which handles only All in One Printer calls.
Well, that's all I can think of without having detailed information. Bottom line, the software can be a little tricky, but for the most part, it installs without any problems. Most of the time the problems are caused by the individual computer; what is installed on it, how full the hard drive is, how fragmented it is, etc. Sometimes antivirus software and firewalls will prevent some files from installing, which causes the install to fail.
Feb CTP SSIS Samples Link
Welcome
Welcome to the Microsoft Online Services Live Meeting forum. This is the place to interface with the Online Services community about Live Meeting.
Reply:
| Tom P (Microsoft) wrote: | |
|
------------------------------------
Solution Ntbackup "no entries found"
I don't know administrators deleted my post before answer my solution!
Well I've just done some adjusts in my scheduled backup:
C:\WINNT\system32\ntbackup.exe backup "@C:\Documents and Settings\backup\Local Settings\Application Data\Microsoft\Windows NT\NTBackup\data\BackupDiario.bks" /d "Backup Diario" /v:no /r:no /SNAP
Thanks a lot,
군인
이름 : 이성권
나이 : 25세
주소 : 경남 진해
Filter By: In thread - request for Since Last Visit or similar
-steve
Microsoft MVP Windows Live / Windows Live OneCare Forum Moderator
Reply:
Since we know the last date you visitted the thread as long as we don't overwrite that immediately when you view it again we could have a filter button that does "New posts since you last visitted this thread" and then return only the new posts.
I think we'll get asked for this in preview mode as well, so here's another suggestion I have:
When you select the "Unread" filter in the threads list we currently only show you new threads or threads that have new posts. If you hit the "preview" button to preview it, you get all the posts. Since we know which posts are new we could default to only show new posts, then you'd have to select the thread itself if you want to read it in it's entirety or we could have an additional switch to show all.
What do you think?
Sam Jarawan STO Forums - Senior Development Lead
------------------------------------
Reply:
You may be only one person in the world, but you may also be the world to one person.
------------------------------------
Reply:
Add another filter to allow a range of x hours/y days, I think it is a winner!
Arnie's idea to also show the original post in the return, but not all intermediate ones is probably of value in many cases. In my work in the OneCare forums this has lass value since the pattern is usually:
Post 1 = question or statement
Post 2 = either a "me too" post or an answer, with the occasional response being a request for more details from the OP
Post 3 = is usually a "me too" or just a piling on, often only vaguely related to the OP.
Where Arnie's idea works well in the OneCare forum model are the really long threads that go on for pages and pages of "me too" posts - merged by me from other standalone posts, or comments made by subsequent posters to the topic.
-steve
Microsoft MVP Windows Live / Windows Live OneCare Forum Moderator
------------------------------------
Renaming of stored procs, triggers, UDFs and views
There is a prior thread that discusses this situation (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1995597&SiteID=1); also, according to Help on sp_rename:
Renaming a stored procedure, view or trigger will not change the name of the corresponding object name in the syscomments table. This may result in problems generating a script for the object as the old name will be inserted from the syscomments table into the CREATE statement. For best results, do not rename these object types. Instead, drop and re-create the object by its new name.
From my perspective, I don't understand how this problem (http://support.microsoft.com/kb/243198) has been ignored for over 10 years. I don't want to see comments from Microsoft that there is overhead or it's complicated to properly rename an object; my orginazation doesn't pay a significant amount money for SQL Server to hear excuses like that. Here are some of the reasons why I feel this is a serious problem:
- If a proc, trigger, function or view is renamed through right-click in SSMS many people may not realize that sp_rename is being used behind the scenes and that the new name becomes out of sync with syscomments / sys.sql_modules
- Both DTS and SSIS have dependencies on the syscomments / sys.sql_modules tables; in SSIS one task in particular that fails if any of these object types are renamed is the Transfer SQL Server Ojbects task
- In this case, the destination server throws an error that duplicate objects are being created; it is very difficult to troubleshoot this when it happens because there are no apparent signs that duplicate objects actually exist
-
- When one of these types of objects are created or altered the proper information is placed into the syscomments / sys.sql_modules table; based on that, storing the correct metadata is the right thing to do. Given that, it's logical that sp_rename is NOT doing the right thing and is being inconsistent
I have people in my organization who have spent a significant amount of time trying to figure out issues or workarounds to something that was apparent long ago. If this really can't be addressed, it would be far more appropriate for sp_rename to simply not support renaming of objects such as these.
Regards.
Reply:
lot of confusion.
Unfortunately, I don't expect this to be addressed any time soon. Simply dropping the possibility to
so is easy, but it has compatibility problems. Rewriting the stored code requires more effort, and I am
not sure that this is a high-priority item.
The good news is that starting with SQL 2008, you can implement measures yourself to prevent this
from happen. That is, you can implement DDL triggers that acts on sp_rename, and rolls back the
operation if the object is of a type that is not good for renaming.
Permit me also to say that in organisations where SQL code is kept under version control,and the
database is only seen as a container for the binaries, this is a very small issue.
------------------------------------
Using a Timer with RollingFlatFileTraceListener
At any rate the big issue I was having is that although you may specify a RollingInterval of Minute, Hour, Day, etc. the library doesn't actually roll on those intervals unless you write to it. i.e. it only checks if it needs to roll whenever new data is written to the file. That means if you have a process that picks up the log files and does something with the data you may have situations where the normal roll interval is 1 minute but because no new data has been written to it for several hours or days that information just sits there completely unaccessible to your log reading/harvesting application. This becomes a bigger problem with Web Gardens where you have multiple files named GUID{YourFileName} and a request actually has to come in that requires local logging on that specific process in order to close the file.
Which brings us to...
Timer based Automated/Automatic Rolling or as I call it AutoRoll in my code additions to the source code released by Microsoft.
Here is the summary of changes:
- Modified the constructor to create a new Timer object whose period and due time are based off of the RollingInterval
- Added a destructor to ensure that the timer object is cleared out of the system when the trace listener is finalized. Used a lock(this) and check to make absolutely certain that the object is not disposed twice.
- Added a TimerCallback method that does the simple action of calling the methods to check if the necessary conditions exist to roll the file. try/catch ignore added to ensure the callback didn't create problems it is safe to ignore b/c this is simply a periodic process to help close out the file if no data is being written to it and the Rolling interval has expired.
- Added a lock(this) on the PerformRoll method to eliminate the possibility of a race between threads that might log and attempt to roll and the timer threads attempt to roll.
- Modified SafeMove( ) so that it will simply overwrite (and not move) the file if the file length is zero. This allows you to avoid creating another file in your directory that is just blank since that would be essentially pointless.
Here are the important code bits (modifications made to the RollingFlatFileTraceListener class):
--------------------------------------------------------------------------------------------------------------------------------
public RollingFlatFileTraceListener(string fileName,
string header,
string footer,
ILogFormatter formatter,
int rollSizeKB,
string timeStampPattern,
RollFileExistsBehavior rollFileExistsBehavior,
RollInterval rollInterval)
: base(fileName, header, footer, formatter)
{
this.rollSizeInBytes = rollSizeKB * 1024;
this.timeStampPattern = timeStampPattern;
this.rollFileExistsBehavior = rollFileExistsBehavior;
this.rollInterval = rollInterval;
this.rollingHelper = new StreamWriterRollingHelper(this);
if (this.rollInterval != RollInterval.None)
{
TimeSpan dueTime = TimeSpan.MinValue, period = TimeSpan.MinValue;
switch( this.rollInterval )
{
case RollInterval.Minute:
period = dueTime = TimeSpan.FromMinutes(1);
break;
case RollInterval.Hour:
period = dueTime = TimeSpan.FromHours(1);
break;
case RollInterval.Day:
period = dueTime = TimeSpan.FromDays(1);
break;
case RollInterval.Week:
period = dueTime = TimeSpan.FromDays(7);
break;
case RollInterval.Month:
period = dueTime = TimeSpan.FromDays(31);
break;
case RollInterval.Year:
period = dueTime = TimeSpan.FromDays(365);
break;
default: break;
}
if (dueTime != TimeSpan.MinValue && period != TimeSpan.MinValue)
_autoRollTimer = new Timer(AutoRoll, null, dueTime, period);
}
}
/// <summary>
/// Cleans up the AutoRoll timer when the object is destroyed
/// </summary>
~RollingFlatFileTraceListener()
{
lock (this)
{
if (_autoRollTimer != null)
{
using (_autoRollTimer) { }
finally { _autoRollTimer = null; }
}
}
}
private Timer _autoRollTimer = null;
private void AutoRoll(object state)
{
try { this.rollingHelper.RollIfNecessary(); }
catch { }
}
....and further down in the code
public void PerformRoll(DateTime rollDateTime)
{
///
/// Lock added by Matthew Erwin (Snaptech, LLC) to avoid contention between AutoRoll and
/// the normal roll that occurs when new messages come in.
///
lock (this)
{
string actualFileName = ((FileStream)((StreamWriter)this.owner.Writer).BaseStream).Name;
// calculate archive name
string archiveFileName = this.ComputeArchiveFileName(actualFileName, rollDateTime);
// close file
this.owner.Writer.Close();
// move file
this.SafeMove(actualFileName, archiveFileName, rollDateTime);
// update writer - let TWTL open the file as needed to keep consistency
this.owner.Writer = null;
this.managedWriter = null;
this.nextRollDateTime = null;
this.UpdateRollingInformationIfNecessary();
}
}
private void SafeMove(string actualFileName, string archiveFileName, DateTime currentDateTime)
{
try
{
if (File.Exists(archiveFileName))
{
File.Delete(archiveFileName);
}
// take care of tunneling issues http://support.microsoft.com/kb/172190
File.SetCreationTime(actualFileName, currentDateTime);
///
/// Avoid wasting time rolling empty files (Added logic by Matthew Erwin (Snaptech, LLC))
///
FileInfo fileInfo = new FileInfo(actualFileName);
if (fileInfo.Length == 0)
fileInfo.Delete();
else
File.Move(actualFileName, archiveFileName);
}
catch (IOException)
{
// catch errors and attempt move to a new file with a GUID
archiveFileName = archiveFileName + Guid.NewGuid().ToString();
try { File.Move(actualFileName, archiveFileName); }
catch (IOException) { }
}
}
--------------------------------------------------------------------------------------------------------------------------------
Of course I'd be happy to hear from anyone who improves on this or sees any deficiencies in the implementation above. I suppose I could have just inherited from this class an overrode these methods but since these changes were basically compatible with the normal operation of the library I decided to keep it as is.
Hope this is helpful to someone looking for the same kind of mechanism.
Cheers.
Matthew
Reply:
------------------------------------
Reply:
We have the exact same issue so hopefully this will sort things out nicely ... just a few points to note when implementing the above code:
1. Change the comment blocks to use two //, not /// which is an XML comment block
2. For the timer, add
using System.Threading;
3. Move the declaration of
private Timer _autoRollTimer = null;
to the beginning of the class
4. Change the destructor to include a try statement (otherwise it fails to compile)
/// <summary>
/// Cleans up the AutoRoll timer when the object is destroyed
/// </summary>
~RollingFlatFileTraceListener()
{
lock (this)
{
if (_autoRollTimer != null)
{
using (_autoRollTimer) try { }
finally { _autoRollTimer = null; }
}
}
}
------------------------------------
Reply:
Sorry about copying the uncompilable destructor in here...However, a note of caution -- the change you made to get it to compile will throw an exception when the Finalizer thread calls the destructor. Although the code you posted is compilable it will result in the following logic:
using( _autoRollTimer )
{
try { }
finally { _autoRollTimer = null } //doesn't properly dispose
} //throws an exception trying to call _autoRollTimer.Dispose( ) b/c it is now NULL
The original intended (and compilable) code is as follows:
/// <summary>
/// Cleans up the AutoRoll timer when the object is destroyed.
/// Destructor added by Matthew Erwin (Snaptech, LLC)
/// </summary>
~RollingFlatFileTraceListener()
{
lock (this)
{
if (_autoRollTimer != null)
{
try { using (_autoRollTimer) { } }
catch { }
finally { _autoRollTimer = null; }
}
}
}
Alternatively you could get rid of the "using( _autoRollTimer ) { }" block and replace it with _autoRollTimer.Dispose( ) if that adds extra readability/clarity for you.
--------------------------------------------------------------
Not sure why that didn't get copied in correctly the first time...perhaps I hit ctrl-z a couple times to look back at a change on that when I was writing the post or something.
The reason for the private variable declaration just above the AutoRoll( ) function was to keep the changes as closely together as possible since these are not supported by MS (though in perfect agreement that consistancy with the MS form the variable should be declared as you stated). Thanks for the feedback and glad to hear this post helped you out.
------------------------------------
selecting rowno from database
hi frnds...
Please help me in this query
I am using vs2005,vb.net,oracle database...
i need to select each row of my database.....and do some operations....can u tell me how can i select one by one row from database....
Please Help me out soon....very urgent..
thank u
in advance
Reply:
there are lots of ways
As this is in T_SQL I assume you want a T_SQL method.
In general T_SQL works on processing the table in one go and discurrages uses from processing one record
If you insist on row processing you will need to use a cursor
this is from BOL
Code SnippetSET NOCOUNT ON DECLARE @vendor_id int, @vendor_name nvarchar(50), @message varchar(80), @product nvarchar(50) PRINT '-------- Vendor Products Report --------' DECLARE vendor_cursor CURSOR FOR SELECT VendorID, Name FROM Purchasing.Vendor WHERE PreferredVendorStatus = 1 ORDER BY VendorID OPEN vendor_cursor FETCH NEXT FROM vendor_cursor INTO @vendor_id, @vendor_name WHILE @@FETCH_STATUS = 0 BEGIN PRINT ' ' SELECT @message = '----- Products From Vendor: ' + @vendor_name PRINT @message -- Declare an inner cursor based -- on vendor_id from the outer cursor. DECLARE product_cursor CURSOR FOR SELECT v.Name FROM Purchasing.ProductVendor pv, Production.Product v WHERE pv.ProductID = v.ProductID AND pv.VendorID = @vendor_id-- Variable value from the outer cursor OPEN product_cursor FETCH NEXT FROM product_cursor INTO @product IF @@FETCH_STATUS <> 0 PRINT ' <<None>>' WHILE @@FETCH_STATUS = 0 BEGIN SELECT @message = ' ' + @product PRINT @message FETCH NEXT FROM product_cursor INTO @product END CLOSE product_cursor DEALLOCATE product_cursor -- Get the next vendor. FETCH NEXT FROM vendor_cursor INTO @vendor_id, @vendor_name END CLOSE vendor_cursor DEALLOCATE vendor_cursor
------------------------------------
Reply:
Hello,
Since you are using Oracle DB, you can not use T-SQL.
You can have a look for solution for cursors for Oracle.
Or you may run a datareader on vb.net code, and make your changes on the code side while datareader is open for each record by one by
Eralper
------------------------------------
Indent doesn't do what its supposed to
Or it doesn't do what I assume its supposed to anyway. :)
I just posted a new thread in this forum and I wanted to indent some text so I highlighted the text in question and hit the indent button. The whole text in my entire post got indented - not what I wanted.
I assume this is a bug?
thanks
Jamie
http://blogs.conchango.com/jamiethomson - If your question is answered, please mark as answered.
Error in Spell Checker
I would think it should know that word if not any other. :)
Stephen Charles Rea [MCT] askthemct.com
Reply:
Thanks!
Alicia
Program Manager, Sustained Engineering Team
------------------------------------
Sorting a topic view
-steve
Microsoft MVP Windows Live / Windows Live OneCare Forum Moderator
Downgrading From Vista to XP Pro
.NET 2.0 SP1 and .NET 3.0 not offered anymore after SP3 RTM
Hi,
when you install a slipstreamed SP3 RTM
.NET 2.0 i offered, but not
.NET 2.0 SP1
and not .NET 3.0
(not by WSUS and not by MU)
Aslo IE7 is not offered anymore.
This will cause a problem is you patch by WSUS,
cause .NET 2.0 SP1 will superseed some securityfixes (eg KB928365)
But superseed hotfixes will be declined so this security fix will not be installed by WSUS.
BR,
127
SqlCeException does not inherit from DbException
I'm in the middle of developing some database independent code and I am surprised to find that the SqlCeException inherits from System.Exception not DbException. The argument I have seen is that DbException does not exist in the CE framework which I understand but this clearly breaks the model laid out by the other assemblies in the data namespace.
My issue is that I have a library which accepts an object implementing the IDBCommand. The execute command is wrapped in a try catch which is only interested in a DbException and allows all other exceptions through which therefore will allow and SqlCeException through.
I have three options available to me:
- Catch all exceptions - This is not acceptable as other exceptions need to bubble up to the calling code.
- Explicitly catch an SqlCeException - This too is not acceptable as it is a common library and not every application wants a reference to the SqlCe assembly
- Explicitly catch an SqlCeException outside of the method call - As hideous as it is this is the only viable solution available to me meaning that any calling code using an SqlCeCommand must be aware of this "feature".
If anyone else has a suggestion I am willing to listen otherwise I'm going to go back to banging my head against the wall.
</rant>Reply:
You can catch all exceptions and check its type dynamically, re-throw if it's not what you need to handle. Here's some pseudo code:
Type sqlCeExceptionType = Type.GetType("Full name of SQL CE exception type here"); if (exception.GetType() == sqlCeExceptionType) { // It's SQL CE exception }
------------------------------------
Reply:
Good suggestion but because the SqlCe assembly is signed i have to supply the version...
... which I don't want to do as I would be tied into a specific version of SqlCe.
Thanks for the help.
------------------------------------
Reply:
DbException class does not exist in .NET CF and SQL CE code is common (99%) across desktop and device. So, we have to live with the option of not deriving from DbException.
Thanks,
Laxmi
------------------------------------
Problem with Vista and XP
i installed XP but now i even cant see my partition D even when formatting...
What should i do?
Is it recoverable when i reinstall my Vista?
Reply:
Hi,
I would like to confirm the following points first:
1. Can partition D be seen in Disk Management or My Computer Windows XP?
2. Can partition D be seen when booting from the Windows XP disk to format the drive?
3. Can partition D be seen when booting from the Windows Vista disk to format the drive
4. Is your computer an OEM one with Windows Vista preinstalled?
I look forward to hearing from you.
Tim Quan - MSFT
------------------------------------
Reply:
Hi
As this thread has been quiet for a while we will be changing the issue type to 'Comment'.
If you wish to return to this question you can go ahead and change the type back to 'Question'. Then you can edit your initial post and change the radio button at the top of the post editor window.
If the issue has been resolved, we'd love to hear your solution. By sharing your experience you can help other community members facing similar problems.
Thanks!
Tim Quan - MSFT
------------------------------------
No comments:
Post a Comment