DB backup failure on 3rd party tool

Hi,
We are backing up this SQL database server using 3rd party
tool from CommVault. About once every a couple of months
the backups stop working. The backup jobs on CommVault
just hang. We have to reboot the SQL server to fix the
problem. And rebooting has been working well so far. We
had CommVault support worked on the problem and they
didn't find anything in their error log. So we started
looking at the windows 2000 server/SQL server 2000 side
trying to find any clue. I looked at SQL errorlog, system
Event Viewer but didn't see anything. Do you have any
suggestions about where else can I look? And any advice of
how to debug this prolem will be greatly appreciated! LiNothing in SQL logs and Window logs: you better ask the vendor. They must
have a clue.
"Li" <lichenzhao@.yahoo.com> wrote in message
news:00c001c3a305$7fa0bb70$a501280a@.phx.gbl...
> Hi,
> We are backing up this SQL database server using 3rd party
> tool from CommVault. About once every a couple of months
> the backups stop working. The backup jobs on CommVault
> just hang. We have to reboot the SQL server to fix the
> problem. And rebooting has been working well so far. We
> had CommVault support worked on the problem and they
> didn't find anything in their error log. So we started
> looking at the windows 2000 server/SQL server 2000 side
> trying to find any clue. I looked at SQL errorlog, system
> Event Viewer but didn't see anything. Do you have any
> suggestions about where else can I look? And any advice of
> how to debug this prolem will be greatly appreciated! Li

DateTime.Now expression expected problem

Hi - I'm using VWD, VB, and created a dataset/tableadapter to insert a record into a SQL Express database. The database has a couple of columns, but specifically a Datetime column.

Using the default insert created, I have the following code:

Dim da as New partyDetailsTableAdapters.partyDetailsTableAdapter
Profile.partyid = da.Insert(Profile.UserName, tbName.Text, DateTime.Now)

The compiler throws an error though, saying 'Expression expected' - and it squiggles an underline under the closing bracket after DateTime.Now - I have no problem if I'm trying to update a record using:

Dim da as New partyDetailsTableAdapters.partyDetailsTableAdapter
Dim pd as partyDetails.partyDetailsDataTable
pd = da.GetPartyDetailsByID(Profile.partyid)
da.Update(Profile.UserName, tbName.text, DateTime.Now, Profile.partyid, Profile.partyid)

Have I an error in my Insert section?

Thanks for any help,

Mark

Look at what the functions da.Insert and ds.Update are expecting as their arguments.

Maybe daInsert is expecting the date as a string instead of a DateTime object

Datepicker date invalid for type

Hi,
I'm working on a report within the development environment. A couple of the
parameters are Date/Time parameters for which RS provides a Date Picker.
The Date Picker returns dates consistent with my regional settings i.e. in
dd/mm/yyyy format, however, once I've selected a date from the date picker
with a day greater than 12, the message "An error occurred during local
report processing. The value provided for the report parameter "From_Date"
is not valid for its type." Which one would assume is because somewhere
within .NET or RS its expecting dates in mm/dd/yyyy format.
I can certainly type in a date in either mm/dd/yyyy, mmm/dd/yyyy,
dd/mmm/yyyy or even yyyy/mm/dd or yyyy/mmm/dd but once I move out of the date
parameter, RS reformats the date in dd/mm/yyyy format.
Of course we can surive without a date picker, but its a nice feature and a
shame not to use it. I will persevere without it for now and hope that
someone has a resolution to this problem.
How do I get the datepicker and .NET/RS to agree on which format the dates
are in?
thanks
MattI have RS2005. I found installing SP1 fixed the problems I was having
with this.
The correct behaviour is for the datepicker to display the date in the
format according to the browser regional settings.
Prior to SP1 I had to make my date parameters Strings or pick them from
a database list.
BlackDuck wrote:
> Hi,
> I'm working on a report within the development environment. A couple of the
> parameters are Date/Time parameters for which RS provides a Date Picker.
> The Date Picker returns dates consistent with my regional settings i.e. in
> dd/mm/yyyy format, however, once I've selected a date from the date picker
> with a day greater than 12, the message "An error occurred during local
> report processing. The value provided for the report parameter "From_Date"
> is not valid for its type." Which one would assume is because somewhere
> within .NET or RS its expecting dates in mm/dd/yyyy format.
> I can certainly type in a date in either mm/dd/yyyy, mmm/dd/yyyy,
> dd/mmm/yyyy or even yyyy/mm/dd or yyyy/mmm/dd but once I move out of the date
> parameter, RS reformats the date in dd/mm/yyyy format.
> Of course we can surive without a date picker, but its a nice feature and a
> shame not to use it. I will persevere without it for now and hope that
> someone has a resolution to this problem.
> How do I get the datepicker and .NET/RS to agree on which format the dates
> are in?
> thanks
> Matt