Database Timeout error

Hi,

I am trying to coonect to a remote SQL Server ( they
changed the default port to some 8080). I have done
aliasing in Client Network Utility of SQL with IP:Port,
and mentioned the alias name in connection string in asp
and able to connect succesfully. But periodically I am
receiving Timeout error. How do i fix this?

Regards

Chip

Hi Chip,
I too faced the same problem.
Try this. It may help you out.
SqlCommand.Timeout = here goes your timeout in secs.
Replace "here goes your timeout in secs." with the time that you want.
Hope this helps you out.
Good luck.
Shobha

"Chip" wrote:

 > Hi,
 >
 > I am trying to coonect to a remote SQL Server ( they
 > changed the default port to some 8080). I have done
 > aliasing in Client Network Utility of SQL with IP:Port,
 > and mentioned the alias name in connection string in asp
 > and able to connect succesfully. But periodically I am
 > receiving Timeout error. How do i fix this?
 >
 > Regards
 >
 > Chip
 ><!-- ~MESSAGE_AFTER~ -->