Error 20599 opening Crystal Report in SQL Server from VB App 1

[benochka]

I have a simple report created in CR (8.5) that connects to an SQL Server 2000 DB through OLEDB and provides me with all the info. Works fine. However, I try to bring up this report from a VB6 app using the Crystl32.ocx component and I get the Error:
Run-time Error '20599'; Cannot open SQL Server

I've ensured that the LogonInfo(0) string is set so that UID=<<Use Integrated Security>> but it's still not letting me in. Any ideas on this would be gratefully appreciated as I'm totally new to CR.
Cheers

 

[AndrewBaines]

I've never been able to get integrated security working with the native driver (ODBC is OK). In fact, it's caused so much trouble that the native driver has been dropped from CR9.
Switch to an ODBC connection and it will work fine. Andrew Baines
Chase International

http://www.chase-international.com

 

[benochka]

Cheers Andrew,
I was beginning to suspect I'd tried every avenue. Had a number of problems with OLEDB and VB controls so I think I'll stick with ODBC from now on!
Ben