VARCHARs don't make good primary keys anyway. X|

I'd say create a new branch either right where 1.2 was merged into 2.0, or from the last commit on the 1.2 branch. I'm assuming that all the the 2.0 changes are going to stay 2.0. 3x12=36 2x12=24 1x12=12 0x12=18

Dan Neely wrote: lunching I bet it's just a very long one... (5 nonetheless) Agh! Reality! My Archnemesis![^] | FoldWithUs! | sighist | µLaunch - program launcher for server core and hyper-v server.

:laugh: Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] I only read code that is properly indented, and rendered in a non-proportional font; hint: use PRE tags in forum messages

Yes, you can test your credentials. Execute a command like select count(*) from myTable and redirect the output to a file, then parse the file for the expected results and if there is no error you have validated that your username/password combination is correct. Do this through osql.

If two files were both copied from the LAN, and only one is showing the message, I can't explain that. :-O

Please don't delete the post once someone has replied to it. It might help others. 50-50-90 rule: Anytime I have a 50-50 chance of getting something right, there's a 90% probability I'll get it wrong...!!

Thank you very much for your input. I was thinking scripting, but I wanted to get some real-world information. I really appreciate it.

Shouldn't be a problem. Maybe log file space/disk space/fragmentation? Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

mobius111001 wrote: Does it count I'm writing the COM object in C#? Yes, indeed: you lost 100 man points for doing it that way. :) If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile. This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke [My articles]

To misquote Pete "Lapdance. Spike heels. What more can I say" :-D Visit http://www.notreadytogiveup.com/[^] and do something special today.

GREAT advice - I have done my development this way for 3 1/2 years now and my experience is also with VMWare workstation. Until very recently, it was the only way to go. VirtualBox is good for 32 bit Windows VMs as long as you don't need external hardware to connect to it. Also, one other tip I would give on the hardware is this: Add up all the memory of all of the virtual machines you MIGHT run at the same time, then double it to get the amount of memory for the host machine. Any less than that, I have found does too much swapping and memory switching - i.e. performance suffers too much. So for example, say you want to run 3 512 MB vm's at the same time. This becomes 1.5GB. The host should then have 3GB MINIMUM. Also, unless you are using small memory footprint VMs, I would highly recommend a 64 bit OS on the host so that you can have as much memory as possible and you don't have to swap out the host OS when you want to upgrade its memory later. For the host, I have used all of Microsoft's 64 bit OSes, XP x64, Server 2003 x64, Vista x64, and Server 2008 x64. One thing I have used it for extensively is for installation testing on a clean machine. Snapshot the clean machine, do your installation testing, and revert it back to the snapshot after each test. Awesome for that - I used to have to do this through ghosting the machine and then bringing back down the image. A lot of waiting there - now, it is just a click of a button to do the same thing. David

If the column is fixed size in the database, what's it's length in there? The need to optimize rises from a bad design.My articles[^]

Yes you can. I do. Otherwise, I can't step into that code while debugging.

SourceOffSite http://www.sourcegear.com/sos/[^] I've worked with it pretty nicely for a very long time. NoelPV2

i still only get the byte[0] to write out. OdbcConnection cn = new OdbcConnection(); // assuming db connection made correction OdbcCommand cm = new OdbcCommand(); Random r = new Random( ( int )DateTime.Now.Ticks ); OdbcParameter op; cm.Connection = cn; byte[] b = new byte[32]; for ( int i = 0; i < b.Length; i++ ) { b[i] = ( byte )( r.Next() % 256 ); } cm.CommandType = CommandType.StoredProcedure; cm.Parameters.Clear(); op = cm.Parameters.Add( "@binVal", OdbcType.Binary ); op.Direction = ParameterDirection.Input; op.Size = b.Length; op.Value = b; cm.CommandText = "sp_SaveBinaryVal"; cn.Open(); try { cm.ExecuteNonQuery(); } finally { if ( cn.State == ConnectionState.Open ) { cn.Close(); } }

Check out PasswordSafe[^]. It's primarily Windows, but there are related projects for other OS's. It was designed by Bruce Schneier[^], a recognized security expert in the industry. Matt Newby President, Matt Newby Enterprises, Inc. matt@mattnewby.com

Are you doing TRUNCATE on the table? That could be one reason. "If the table contains a column defined as DEFAULT AUTOINCREMENT or DEFAULT GLOBAL AUTOINCREMENT, TRUNCATE TABLE resets the next available value for the column" Refer to: TRUNCATE TABLE statement [^] The need to optimize rises from a bad design.My articles[^]

mobius111001 wrote: Is any date between 01/01/2008 - 12/31/2015 in 11/21/2008 - 12/21/2009? If date1 = 01/01/2008 date2 = 12/31/2015 date3 = 11/21/2008 date4 = 12/21/2009 then it would be something like: ... date1 between date3 and date4 or date2 between date3 and date4 or (date1 < date3 and date2 > date4) ... The need to optimize rises from a bad design.My articles[^]