p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

crystal_reports thread: Having a bit of trouble using crystal reports


Message #1 by Karl King - TP Technologies <kking@t...> on Thu, 17 Oct 2002 12:38:10 +0100
I'm connecting to our reporting server/database using the following code in
vb:

Report.Database.LogOnServer "p2ssql.dll", "Server01", "ReportingDB", "sa",
""
Report.Database.Tables(1).SetLogOnInfo "Server01", "ReportingDB", "sa", ""

This works fine, but now I need to have the ability of connecting to the
server using NT authentication, I've looked at Seagate's knowledgebase and
can't find any example of how to this.

The only way I've found on an old example is do have the following:
Report.Database.LogOnServerEx
"p2ssql.dll","Server01",,,,,"Provider=SQLOLEDB.1;Persist Security
Info=False;User ID=sa;Password=;Initial Catalog=ReportingDB;Data
Source=Server01"

Has anyone come across or had to do anything similar ?

cheers Karl.




  Return to Index