Hi Everybody, i saw a video from asp.net site that solved my problem concerning this issue. the video number is 07, sql security and network connection.

This is the link to...

Thanks vijay, but i'm using windows forms, with asp.net its quite easy, i go through localhost or the webserver, but i don't know how to do so for windows forms.

Hi Henrico,

been there already, i tried some of the options locally, but they did not work, for example when i try:

<add name="MMSConn" connectionString="Data Source=PROGRAMMER\FREDSQLSERVER,1433;Initial Catalog=MediaMonitoring; Integrated Security=True" providerName="System.Data.SqlClient"/>

it doesn't connect.

i...

Hi thanks Stewart, some nice tsql there, you guys are gurus.

Thanks wayne, i'll stick to your advice. Thanks so much for your help.

Timotech

Hi Luzi, why do i still need to do a constraint, since i have what i need?

Hi Luzi, Thanks so much for your help, it has finally worked, i had to go through the records one at a time, then later discovered that some time entries...

Hi Luzi, thanks for your replies, i tried what u said, but i think the problem is comming from the table, because i checked the field for invalid data and...

thanks so much everybody, u've been so helpful, the little problem now is that, after i ran this command successfully:

ALTER TABLE tbl_TVRates ADD CONSTRAINT

DF_tbl_TVRates_1_Lower_Time DEFAULT N'19000101 00:00:00' FOR Lower_Time

then i...

ALTER TABLE myPoorlyDesignedTable ADD CONSTRAINT

DF_Table_1_Upper DEFAULT N'19000101 00:00:00' FOR Upper

Hi Luci, i don't understand the DF_Table_1_Upper,

should i do this:

ALTER TABLE tbl_TVRates ADD CONSTRAINT

DF_tbl_TVRates_1_Upper_Time DEFAULT N'19000101 00:00:00' FOR Upper_Time

because my table...

Hi Wayne, thanks for your post it was very helpful, but the second update did not run. i did this:

UPDATE tbl_TVRates

SET Upper_Time = '19000101 ' + Upper_Time

...

Hi thanks for your replies. unfortunately the fields has a lot of Null values. there are about 4000 records, how do i fill the nulls and probably convert the fields...

Hi Stewart, thanks for your contributions, i just tried it, it seems to give the same problem. i don't know what else to do.

Thanks,

I tried using '1900-01-01 04:01:00' but it still said cannot convert to datetime.

The problem is that the Lower_time field and Upper_time fields are of type nvarchar(8) containing values such as...

Thanks for your reply, i'm using sql server 2005

Timotech