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