I am using Crystal 7 Automation Server and I am having trouble getting the syntax for having Crystal log into MS SQL Server.

It all works fine using Visual FoxPro as the data source.

I think that I have to use something like:

oReport.LogOnServer("P2SODBC.DLL","ODBC name","","sa","")

I keep getting an "Unknown Name" error.

Any ideas?