I just want to double check with you that you have done everything you need to do. So here is an example from my own code that works: oconn.ConnectionTimeout = 0 oconn.CommandTimeout = 0 oconn.Open "Driver={SQL Server};Server=Hal2000;Database=Europa;Uid=sa; Pwd= :P ;timeout=0;" One final thing do you need to set up an ODBC connection on the computer, and if you do have you set this up? You always pass failure on the way to success.

check for the column content and disable using the below code winnie

Yes, using string.Format is good. Seems I've been going down that road lately :-D "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon