Hi Aashish

Thanks 4 the help. sorted my problem out with the help u gave me. Just one more thing.

I use the command SQLSTRINGCONNECT to create my connection. How can I set the timeout for the connection i'm trying to create. At the moment the program stops responding if no connection can be established.

Thanks

stuart