updating rows

[derwent]

I have a quick script that updates some columns of my MSSQL database, running it on my machine updates the fields perfectly, no problems.

However if I alter my connection script for our webserver and run the same script, the script times out and in task manager, a new entry appears which is

dllhost.exe
username: IWAM_mymachinename

running at 99% cpu until I kill the process.

Has anyone seen this before? It works fine on my local but as soon as I try it with the webserver this happens.

thanks

 

[ayanroy]

Try using this:-

objConn.ConnectionTimeout = 60
'Can be increased
objConn.CommandTimeout = 60
' Can be increased too

Ayan Kumar Roy
India

 

[derwent]

I normally use the machine name instead of IP, but as I was changing it frequently for my machine then for the webserver I just set to local.

 

[derwent]

still not working.

I even looked through event viewer to see if there are any issues but nothing came up. The only entry was to comment on a succesful db login

 

[Sheco]

but as I was changing it frequently for my machine then for the webserver I just set to local

OK, so the actual instance of MSSQL is running locally on the web server and when you test it on the development machine you are also connecting to the instance of MSSQL running on the web server?

 

[derwent]

I have two copies of all files, one copy resides on my local and another identical on the webserver. Each only connects to their respective MSSQL's.

I don`t think it can be the code as it used to work on both and still works on local.

I thought it may be windows updates but none have been installed on webserver at the time it stopped working.

 

[Sheco]

Are you saying that there are two separate instances of the database? One on the web server and one on your development machine?

 

[derwent]

yep, exactly the same database but located in two different locations. Niether know of the others existence.

I have the same environment on both as I obviously develop and test on my local then ftp to the webserver if all works ok on local.

 

[derwent]

another update:

I can update via a webpage using rs.update any field set to varchar in sql server. The fields I can`t update are set to text, 16.

I also can`t update any text, 16 fields on other databases on the webserver.