[RESOLVED] CRXI, VB6, SQL Server, Logon Failed

Hi all. Software is as in the title - Crystal Reports XI (dev version), Visual Basic 6, SQL Server (2000). I have a report that I made in CR and I'm accessing it through VB. I can see the data at design time but at run time it fails to log on to the server.

I'm using the report.database.logonserver function and I've tried every combination of servername, dsn, ip address, etc and I can't get logged into my SQL server. Depending on the connection type I get various errors but all basically "Logon Failed".

I've also seen mention of a logonserver for the tables property in report.database but it doesn't seem to exist in this version of crystal.

Any help much appreciated.