Link to home
Start Free TrialLog in
Avatar of jhredd
jhredd

asked on

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
Avatar of Mike McCracken
Mike McCracken

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
Avatar of jhredd

ASKER

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
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jhredd

ASKER

Hi, you are right of course. I had to use an ole db connection.

Thank You,
James