When you run run Crystal Reports, can't you just pass an ADO Recordset? If so, just create the connection with the dsn-less string.

I hope this helps...

>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