Search results for query: *

Everyone, I am attempting to upgrade an existing installation of SQL7 to SQL2k. It gets through most of the upgrade with no problem until it gets to the final piece of the upgrade where it runs 17 SQL scripts. It fails immediately on script 1 with the insightful message error running script 1...

Well it worked like a charm. Thanks a bunch.

I wrote into certain purchase order VB.NET applications, EMAIL notifications. I added cdo for windows 2000 COM object in my project and everything works fine in development. Once I moved these applications to production (2000 Server), I started getting the following error: File or assembly...

Very nice post. I will give it a try. I would suggest anyone using CDO in .NET copy the code in your post. Thanks again, Dave

Guys, I have a request to mark EMAILs as urgent (!) that are getting sent as a result of a vacation request. I have looked at the CDO properties and methods and I don't see a way to do this. However, since is is common knowledge that the more you look at something the less you see, I was...

adamroof, I was just getting ready to blow the form away again and recreate and debug it one text box or DDL at a time. I wouldn't have gotten any different results, although I may have left work early for the bar :) You were absolutely right, I had not databound my DDLs or text boxes. Once I...

Guys, I'm still sort of new to .NET. I am having problems being able to get selected values from one of my forms. All I get are the original values and not any changes that may have been made. I have tried everything I can think of from completely redoing the form from scratch to creating a...

Atmoic Chip is right. You have a column in a SQL table that has a character length too small for one of your values. It may not be your "Customers" column if you've double checked it. I would check every column you're updating because the error you're getting can be nothing other than a...

Thanks BoulderBum. That should work just fine. -Dave

Guys, I'm an old Visual C++ developer who hasn't use it for about 6 years. I am not using C#.net and I have a need to convert a string to int. In C++ it was easy to just atoi. When I try to use atoi in C#.net I get the old familiar "not in namespace" error. Here's the piece of code...

Chip, I tried that and I got a compile error stating that the "ToString" function only has one parameter. Thanks anyway, Dave

Guys, Thanks for your help, but I finally found the answer. If you're interested here's the code: wrk = tempDataRow["EDate"].ToString(); indx = wrk.IndexOf(" "); char[] DateArray = new char[indx]; wrk.CopyTo(0,DateArray ,0, indx); tempDateText= new String(DateArray); "wrk" starts with a...

You're sort of on the right track Chip. Here's exactly what I'm trying to do. I'm retrieving data, including a date (see below), from a SQL table using a stored procedure. wrk = tempDataRow["EDate"].ToString(); wrk now contains, we'll say, "7/2/2004 12:00:00". I want to now get rid of the...

Guys, I haven't worked in C for awhile and I'm trying to remember how to do the following: I have a date returned from a SQL table to a literal in my web app we'll call - EDate. This literal now contains the date but also a time. I want to eliminate the time portion and keep the date. This...

Got it to work okay. Here's the code snippet: wrkarry = Split(docList, ",") phyBound = UBound(wrkarry) indx1 = 0 cmd = New SqlCommand( _ "SELECT DrID, DrInit FROM PhyDoctor " _ & "ORDER BY...

Thanks Isadore. It looks like something that would work in my situation. I'll give it a shot. -Dave

checkai, Yeah, that's whay I'm trying to do, however I do not know the proper syntax to code it. .NET tends to be very picky about how you code everything. That's what I was looking for. Thanks for your help, Dave

Guys, I'm trying to load a listbox with database values and set multiple select values at the same time. For instance, I select an administrative assistant from a drop down box which kicks off the selected index change event which grabs the selected value of the drop down box and reposts the...

Sure. Go to your Default Web Site under IIS. Then find your web app and right click for properties. You'll see the Directory Security tab. Click on it. CLick on the Anonymous Access button and make sure that ONLY the Integrated Security check box is checked. That will force the NT login...

Thanks dragonwell. Worked as advertised. -Dave