You're using an outdated Crystal control. You should look at the RDC instead. There are articles on my web site to get you started with it.

>I created a system DSN ODBC connection to SQL Server using SQL server authentication. When I test the the connection it says it is successful.
>When I try to connect to the server to pass crystal reports the parameters
>I get an error "20599 Cannot open SQL Server". I know it must be authentication related because it works when I set the dsn connection to use windows authentication.
>I am using the following code
>OLECONTROL1=CREATEOBJECT("Crystal.CrystalReport")
>I know I have to pass crystal the SQL login name and password but I cannot figure out which method to use and also what syntax to use ?
>
>Thanks For Your Help !
>Stephen J. Hunt