[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 278
  • Last Modified:

Deploying Crystal Repoorts on many MSSQL Servers?

Hi, I' created some crystal reports and in my frontend I'm setting the table logon infor like:
CrystalReport.SetAllTablesLogOnInfo(GLO:DSN,GLO:DSNDB,GLO:DSNUser,GLO:DSNPassword,true)
where I am first priming the GLO:Variables.

IF this format does not look familiar it's because my front end app is developed with Clarion 5.5 Anyway it's looking for a DSN name but I want to be able to use a physical server name? We have about 30 servers in this intranet and I really don't want to have to create DSN's for them all. All of the servers are running MSSQL 2000 and all DB's have the same name and tables.

What is the best practices method of distributing my reports across the intranet? How should I approach this for the best solution.?

Many Thanks,
James
0
jhredd
Asked:
jhredd
  • 2
  • 2
1 Solution
 
mlmccCommented:
I haven't seen the ability to use a physical server name except if you use an ADO or OLE connection.  Apparently your reports are built using a dsn connection and in that case you will need to build a dsn to all databases

mlmcc
0
 
jhreddAuthor Commented:
How can I design the report with the physical server info so I can call it at runtime by the physical server name?

Thanks
James
0
 
jhreddAuthor Commented:
Hi, you are right of course. I had to use an ole db connection.

Thank You,
James
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now