Thanks for that all.  I am new SQL Server and my brain has been left at home.  Got it working, usde Kenneths suggestion.

Thanks again.

Kev.

Thanks for your help.

I got it to work, I went trough my VB Code and took out any code that I really didn't need ( that's what you get when...

I'm a bit if a Newbie when it comes to SQL Server.  How can you tell if the query is being blocked?

Kev.

Tried that. 

All that achieves is that the program doesn't do anything...it just hangs.

Thanks for your help.

Kev.

Ok, done that

I get

query wait (s) -1  2147483647  -1   -1 

remote login timeout (s) 0  2147483647  20  20 

remote query timeout (s) 0  2147483647  600  600 

Just checked, the compression option is switched off.

Using the cast command within the view worked.

Thanks for all your help.

Kevin

Resolved.

Found out that you do need to install the client tools on the PCs that will map to the server.

Thanks.

Thanks Again.

We have a processor license on for the server....will we need to get separate licenses for the PC's that will have the client tools?

Thanks