Thanks for the string but I need a little more help. If I've created a Crystal report using ODBC to connect to my DBC exactly what are the steps to make sure that the ODBC connection is established before I run the report using the automation server. How do I create the object oconn? Do I still use the createobject("adodb.connection")?

I apologise for being a pain but if you don't ask...

Thanks

Anthony