Connect through Trusted Connection to SQL Server 1

[vjee]

Hi,

I'm developing a VB6 application which generates reports from stored procedures. I succeeded to connect to the database by using the SetlogOnInfo with the necessary parameters.
Report.database.tables(1).SetLogOnInfo <server>,<database>,<username>,<password>

For testing purposes, this is ok, but at runtime, the users need to connect to the database using a trusted connection.
I'm using Crystal Reports 8.5, a SQL Server 2000 database and the application has to run on Windows 2000 machines.

Is there any way to connect to the database with a trusted connection? I tried to do this by leaving out the username and password on the SetLogOnInfo but then I'm getting an error &quot;Server is not yet opened&quot;... or something like that.

Any help would be greatly appreciated!

TIA
Bart

 

[balves]

I haven't used it, but this is allegedly the answer according to the KB:

crxRpt.Database.Tables(1).SetLogOnInfo &quot;&quot;, &quot;&quot;, &quot;<<Use Integrated Security>>&quot;, &quot;&quot;

 

[vjee]

Took me a while to try it due to other problems, but it worked.

Thanks!

Bart