OLEDB With 8.5 to SQL Server 200 Integrated Security 1

[fluteplr]

How do you set the logon info if you want to user ingerated (nt security) with SQL 2000 OLEDB Driver?

We were using the following code with SQL Security

FOR EACH otable IN ocrystal.reportobject.database.tables
otable.SetLogOnInfo('server','database','user','Password')
ENDFOR 
[\code]

Which worked just fine with sql security. 

I tried leaving out the last two parameters and setting them to an empty string, both return a 'Server has not yet been opened' error then the report is previewed.

 

[balves]

We don't use integrated security, but supposedly, the answer is:

.SetLogOnInfo &quot;&quot;, &quot;&quot;, &quot;<<Use Integrated Security>>&quot;, &quot;&quot;

Otherwise known as a hack.

 

[fluteplr]

Tried it, same message.

'Server has not yet been opened'

Thanks anyway.

 

[fluteplr]

My bad, it does work. I had left an extra quote mark in the string when I tried it the first time.

Boy that really is a hack. But also about par for the course with Crystal.